Function Index

MovingCorr

Calculates the correlation coefficient in a moving window.

Usage

MovingCorr(<field1>,<field2>,<above>,<below>)

field1 (required) The column representing the dependent data.

field2 (required) The column representing the independent data.

above (required) The number of rows above the current to include.

below (optional) The number of rows below the current to include. Defaults to 0.


Examples

MovingCorr([Population 2010], [Population 2000], 5, 5)
  • Calculate the correlation coefficient between the populations for each set of 11 adjacent values.