Difference between revisions of "Manuals/calci/MPEARSON"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "PEAR")
 
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
PEAR
+
<div style="font-size:30px">'''MPEARSON (ArrayOfArrays)'''</div><br/>
 +
*<math>ArrayOfArrays</math> is the array of two set of independent values.
 +
.
 +
 
 +
==Description==
 +
*This function gives the Pearson Product-Moment Correlation 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  <math> X </math>  and <math> Y </math>, giving a value between +1 and −1 inclusive.
 +
*Here
 +
+1 indicates the perfect positive correlation,
 +
  0 indicates no correlation
 +
-1 indicates the perfect negative correlation.
 +
*The formula for PPMC, <math> r </math> 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}</math>  and  <math>\bar{y} </math>  are Average of the two Samples  <math>x </math> and  <math>y </math>.
 +
*In  <math>MPEARSON(ArrayOfArrays)</math>, the value of <math> Array of Arrays</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 <math> Array of Arrays </math>
 +
 
 +
==Examples==
 +
1.
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C
 +
|-
 +
! 1
 +
| 5 || 9 || 10
 +
|-
 +
! 2
 +
| 8 || 12 || 15
 +
|}
 +
MPEARSON(A1:C1,A2:C2)
 +
{| class="wikitable"
 +
|-
 +
| 1 || 0.9686196045011367
 +
|-
 +
| 0.9686196045011367 || 1
 +
|}
 +
2. MPEARSON([[15,18,20,24],[-3,-8,43,31]])
 +
{| class="wikitable"
 +
|-
 +
| 1 || 0.7113828912825356
 +
|-
 +
| 0.7113828912825356 || 1
 +
|}
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|v=zt1K9qhFdfQ&t=191s|280|center|Pearson Product Moment Correlation}}
 +
 
 +
==See Also==
 +
*[[Manuals/calci/INTERCEPT  | INTERCEPT ]]
 +
*[[Manuals/calci/SLOPE  | SLOPE ]]
 +
 
 +
==References==
 +
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Pearson]
 +
 
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:14, 6 December 2018

MPEARSON (ArrayOfArrays)


  • is the array of two set of independent values.

.

Description

  • This function gives the Pearson Product-Moment Correlation 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 and , giving a value between +1 and −1 inclusive.
  • Here
+1 indicates the perfect positive correlation,
 0 indicates no correlation 
-1 indicates the perfect negative correlation.
  • The formula for PPMC, is defined by:

where and are Average of the two Samples and .

  • In , the value of 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

Examples

1.

Spreadsheet
A B C
1 5 9 10
2 8 12 15

MPEARSON(A1:C1,A2:C2)

1 0.9686196045011367
0.9686196045011367 1

2. MPEARSON([[15,18,20,24],[-3,-8,43,31]])

1 0.7113828912825356
0.7113828912825356 1

Related Videos

Pearson Product Moment Correlation

See Also

References

Pearson



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/MPEARSON&oldid=211430"