PEARSON
Returns the Pearson product moment correlation coefficient.
StatisticalStatistics & Analysis
What it does
Calculates Pearson correlation coefficient r.
Syntax
PEARSON(array1, array2)
Arguments
array1(range) — First data set.array2(range) — Second data set.
Examples
Pearson r
Calculate correlation.
FORMULA
=PEARSON(A1:A5, B1:B5)
RESULT
0.98
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 2 |
| 3 | 2 | 4 |
| 4 | 3 | 5 |
| 5 | 4 | 8 |
| 6 | 5 | 10 |