Difference between revisions of "Manuals/calci/PEARSON"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PEARSON'''(Array1, Array2) where, '''Array1,''' - represents a set of independent values. '''Array2'''...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''PEARSON (ar1,ar2)'''</div><br/> |
| + | *<math>ar1</math> is the array of independent values and <math>ar2</math> 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: | ||
| + | <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. | ||
| + | *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. | ||
| + | *This function will return the result as error when the number of values are different for ar1 and ar2. | ||
| + | |||
| + | ==Examples== | ||
| + | #Array1 Array2 | ||
| + | 5 8 | ||
| + | 9 12 | ||
| + | 10 15 | ||
| + | PEARSON(B1:B3,C1:C3)=0.968619605 | ||
| + | #Array1 Array2 | ||
| + | 17 10 | ||
| + | 0 11 | ||
| + | 19 7 | ||
| + | 25 13 | ||
| + | PEARSON(D1:D4,E1:E4)=-0.759206026 | ||
| + | #Array1 Array2 | ||
| + | 1 4 | ||
| + | 2 5 | ||
| + | 3 | ||
| + | PEARSON(A1:A3,B1:B2)=NAN | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/INTERCEPT | INTERCEPT ]] | ||
| + | *[[Manuals/calci/SLOPE | SLOPE ]] | ||
| + | |||
| + | ==References== | ||
| − | |||
'''Array1,''' - represents a set of independent values. | '''Array1,''' - represents a set of independent values. | ||
| Line 33: | Line 70: | ||
Lets see an example in (Column3, Row1) | Lets see an example in (Column3, Row1) | ||
| − | + | UNIQa9cacf80da78a549-nowiki-00000002-QINU | |
PEARSON returns -0.015.811. | PEARSON returns -0.015.811. | ||
Revision as of 00:14, 6 January 2014
PEARSON (ar1,ar2)
- is the array of independent values and is the array of dependent values.
is the array of independent values and 
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
- Array1 Array2
5 8 9 12 10 15 PEARSON(B1:B3,C1:C3)=0.968619605
- Array1 Array2
17 10
0 11 19 7 25 13 PEARSON(D1:D4,E1:E4)=-0.759206026
- Array1 Array2
1 4 2 5 3 PEARSON(A1:A3,B1:B2)=NAN
See Also
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 | ||
| Row3 | 9 | 5 | ||
| Row4 | 7 | 8 | ||
| Row5 | 1 | 4 | ||
| Row6 | 2 | 6 |
