PEARSON(array_x, array_y)

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:

image\ebx_-1037207177.gif

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:

Other statistical functions