The PEARSON function calculates the Pearson product moment correlation coefficient. This is a measure, between -1 and 1 inclusive, of the extent of the relationship between two sets of data.
array_x is the set of independent and array_y is the set of dependent numbers. The arrays must have a matching number of values. PEARSON is calculated using the formula:
where r is the correlation coefficient of the linear regression line running through the data points described by array_x and array_y.
For example:
PEARSON({10, 7, 5, 3, 2}, {12, 8, 13, 4, 1})
returns 0.756437.
See also: