Calculates r, the Pearson product-moment correlation coefficient of a dataset.
Sample Usage
PEARSON(A2:A100,B2:B100)
Syntax
PEARSON(data_y, data_x)
- data_y - The array or range representing dependent data.
- data_x - The array or range representing independent data.
Examples
PEARSON(A2:A100,B2:B100) returns the correlation coefficient of the two data sets in columns A and B..