Manuals/calci/MPEARSON
- 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 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 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 X } and 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 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, 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 r } is defined by:
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 r= \frac{ \Sigma(x-\bar{x})(y-\bar{y})}{\sqrt {\Sigma(x-\bar{x})^2(y-\bar{y})^2}}}
where 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 \bar{x}} and 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 \bar{y} } are Average of the two Samples 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 x } and 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 y } .
- In 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 MPEARSON(ArrayOfArrays)} , the value of 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} 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.
| 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