CumulativeCorr

Calculates the correlation coefficient of the column up to and including the current value.

Usage

CumulativeCorr(field1, field2)

field1 (required) The column representing the dependent data.

field2 (required) The column representing the independent data.

NOTE: Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

Example

CumulativeCorr([Population 2010], [Population 2000])
  • For each pair of values in [Population 2010] and [Population 2000], calculate the correlation coefficient the group of values containing that pair of values and all the preceding values.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us