Manuals/calci/MPEARSON

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

See Also

References

Pearson