- 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 ar1} is the array of independent values 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 ar2} is the array of dependent values.
Description
- This function gives the Pearson productmoment correlaton 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 and -1 indicates the perfect negative correlation.
- The formula for PPMC,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 \bar{y})} are Average of the two Samples x and 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 PEARSON(ar1,ar2)} , 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 ar1} 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 ar2} 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 ar1 and ar2.
Examples
- Array1 Array2
5 8 9 12 10 15 PEARSON(B1:B3,C1:C3)=0.968619605
- Array1 Array2
17 10
0 11 19 7 25 13 PEARSON(D1:D4,E1:E4)=-0.759206026
- Array1 Array2
1 4 2 5 3 PEARSON(A1:A3,B1:B2)=NAN
See Also
References
Array1, - represents a set of independent values.
Array2 - represents a of dependent values.
Returns the Pearson product momment correlation coefficient(P).
Formula :-
P =
PEARSON
Lets see an example in (Column3, Row1)
?UNIQa9cacf80da78a549-nowiki-00000002-QINU?
PEARSON returns -0.015.811.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 1 | -0.015811 | |
| Row2 | 8 | 2 | ||
| Row3 | 9 | 5 | ||
| Row4 | 7 | 8 | ||
| Row5 | 1 | 4 | ||
| Row6 | 2 | 6 |
