|
<< Click to Display Table of Contents >> PEARSON (Pearson correlation coefficient) |
Syntax:
PEARSON(Range1, Range2)
Description:
This returns the Pearson correlation coefficient r of two data sets.
This coefficient is a measure of the strength of the linear relationship between two data sets.
The result of the PEARSON function is within the range -1 to 1: 1 indicates a perfect linear relationship. -1 indicates a perfect inverse linear relationship (the values in Range2 decrease as the values in Range1 increase).
Range1 and Range2 are cell references to the two data sets. The ranges should contain numbers. Empty cells, text and logical values are ignored.
Range1 and Range2 must have the same number of values, otherwise the function returns a #N/A error value.
Example:
If A1:A3 contains the values 1, 2, 3 and B1:B3 contains 2, 3, 4, the following applies:
PEARSON(A1:A3, B1:B3) returns 1
If A1:A3 contains the values 1, 2, 3 and B1:B3 contains 4, 3, 2, the following applies:
PEARSON(A1:A3, B1:B3) returns -1
See also: