Manuals/calci/MPEARSON

MPEARSON (ArrayOfArrays)

• $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 $X$ and $Y$, 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, $r$ is defined by:

$r={\frac {\Sigma (x-{\bar {x}})(y-{\bar {y}})}{\sqrt {\Sigma (x-{\bar {x}})^{2}(y-{\bar {y}})^{2}}}}$

where ${\bar {x}}$ and ${\bar {y}}$ are Average of the two Samples $x$ and $y$.

• In $MPEARSON(ArrayOfArrays)$, the value of $ArrayofArrays$ 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 $ArrayofArrays$

Examples

Spreadsheet

	A	B	C
1	5	9	10
2	8	12	15

1	0.9686196045011367
0.9686196045011367	1