The CumulativeCorr function calculates the correlation coefficient of the input column up to and including the current value.
Syntax
CumulativeCorr([Column 1], [Column 2])
Function Arguments:
[Column 1] (required) - The column representing the dependent data.
[Column 2] (required) - The column representing the independent data.
📘
Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.
Example
CumulativeCorr([Weekly Cost], [Weekly Revenue])
A table contains the weekly revenue of a store and the total amount spent by that store that week. The CumulativeCorr function can be used to find the correlation coefficient up to and including each row value.
