writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − PEAR+ + + + + + + + + + + + + + + + + + + +
Manuals/calci/MPEARSON (view source)
Revision as of 20:33, 14 December 2016
, 20:33, 14 December 2016no edit summary
<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>