CumulativeCorr

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.