Calculates the correlation coefficient of the column up to and including the current value.
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.
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.