PEARSON
Syntax:
PEARSON ( array-1 , array-2 )
Description: Computes the Pearson product moment correlation coefficient, a dimensionless index that ranges from -1.0 to 1.0, inclusive, and reflects the extent of a linear relationship between two data sets.
Mathematical Formula:
The formula for the Pearson product moment correlation coefficient, r, is:
where x and y are the sample means AVERAGE(
array-1)
and AVERAGE(
array-2)
.
Arguments:
Name |
Type |
Description |
---|---|---|
array-1 |
number, name, array, reference to number |
The set of independent numerical values. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included. |
array-2 |
number, name, array, reference to number |
The set of dependent numerical values. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included. |
Return Type and Value: number – The Pearson product moment correlation coefficient.
However, if
array-1 and array-2 have a different number of data points, the return value is unspecified.
array-1 or array-2 is empty, the return value is unspecified.