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.

Examples

1. Array1 Array2

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

1. Array1 Array2

17                    10

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

1. Array1 Array2

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

See Also

• INTERCEPT
• SLOPE

References

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

---

	Column1	Column2	Column3	Column4
Row1	5	1	-0.015811
Row2	8	2	File:Copy-cube.gif
Row3	9	5
Row4	7	8
Row5	1	4
Row6	2	6

File:Calci1.gif

---