Manuals/calci/PEARSON
PEARSON(Array1, Array2)
where,
Array1, - represents a set of independent values.
Array2 - represents a of dependent values.
Returns the Pearson product momment correlation coefficient(P).
Formula :-
P =
If Length of Array1 =! Length of Array2 , PEARSON returns the #ERROR.
PEARSON
Lets see an example in (Column3, Row1)
=PEARSON(R1C1:R6C1, R1C2:R6C2)
PEARSON returns -0.015.811.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 1 | -0.015811 | |
| Row2 | 8 | 2 | ||
| Row3 | 9 | 5 | ||
| Row4 | 7 | 8 | ||
| Row5 | 1 | 4 | ||
| Row6 | 2 | 6 |
