Manuals/calci/PEARSON

PEARSON (ar1,ar2)

$ar1$ is the array of independent values and $ar2$ is the array of dependent values.

Description

This function gives the Pearson productmoment correlaton coefficient.
It is denoted by PPMC, which shows the linear relationship between two variables.
It is a measure of the strength of a linear association between two variables .
The two variables X and Y, giving a value between +1 and −1 inclusive.
Here +1 indicates the perfect positive correlation, 0 indicates no correlation and -1 indicates the perfect negative correlation.
The formula for PPMC,r is defined by:

$r={\frac {\Sigma (x-{\bar {x}})(y-{\bar {y}})}{{\sqrt {\Sigma }}(x-{\bar {x}})^{2}(y-{\bar {y}})^{2}}}$

where ${\bar {x}}and{\bar {y}})$ are Average of the two Samples x and y.

In $PEARSON(ar1,ar2)$ , the value of $ar1$ and $ar2$ must be either numbers or names, array,constants or references that contain numbers.
Suppose the array contains text,logicl values or empty cells, like that values are not considered.
This function will return the result as error when the number of values are different for ar1 and ar2.

5 8 9 12 10 15 PEARSON(B1:B3,C1:C3)=0.968619605

17                    10

0 11 19 7 25 13 PEARSON(D1:D4,E1:E4)=-0.759206026

1 4 2 5 3 PEARSON(A1:A3,B1:B2)=NAN

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)

?UNIQa9cacf80da78a549-nowiki-00000002-QINU?

PEARSON returns -0.015.811.

Syntax

Remarks

Examples

Description