Difference between revisions of "Manuals/calci/PEARSON"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''PEARSON (ar1,ar2)'''</div><br/> | <div style="font-size:30px">'''PEARSON (ar1,ar2)'''</div><br/> | ||
| − | *<math>ar1</math> is the array of independent values | + | *<math>ar1</math> is the array of independent values |
| + | *<math>ar2</math> is the array of dependent values. | ||
==Description== | ==Description== | ||
| Line 11: | Line 12: | ||
<math> r= \frac{ \Sigma(x-\bar{x})(y-\bar{y})}{\sqrt {\Sigma(x-\bar{x})^2(y-\bar{y})^2}}</math> | <math> r= \frac{ \Sigma(x-\bar{x})(y-\bar{y})}{\sqrt {\Sigma(x-\bar{x})^2(y-\bar{y})^2}}</math> | ||
| − | where <math>\bar{x} and \bar{y} </math> are Average of the two Samples x and y. | + | where <math>\bar{x} and \bar{y} </math> are Average of the two Samples x and y. |
*In <math>PEARSON(ar1,ar2)</math> , the value of <math> ar1</math> and <math> ar2</math> must be either numbers or names, array,constants or references that contain numbers. | *In <math>PEARSON(ar1,ar2)</math> , the value of <math> ar1</math> and <math> ar2</math> 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. | *Suppose the array contains text,logicl values or empty cells, like that values are not considered. | ||
Revision as of 23:17, 5 January 2014
PEARSON (ar1,ar2)
- is the array of independent values
- is the array of dependent values.
is the array of independent values
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:
where are Average of the two Samples x and y.
are Average of the two Samples x and y.
- In , the value of and 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.
, the value of Examples
- 1.Array1 Array2
5 8 9 12 10 15 PEARSON(B1:B3,C1:C3)=0.968619605
- 2.Array1 Array2
17 10
0 11 19 7 25 13 PEARSON(D1:D4,E1:E4)=-0.759206026
- 3.Array1 Array2
1 4 2 5 3 PEARSON(A1:A3,B1:B2)=NAN