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 14: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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array of Arrays }

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"