Manuals/calci/RSQ
- 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 y values .
- 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 x values.
Description
- This function gives the square of Pearson Product Moment Correlation Coefficient.
- This function is calculated using the data points 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 y} 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 x} values.
- 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 } .
- This function gives 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 r^2} , which is the square of this correlation coefficient.
- The square value can be interpreted as the proportion of the variance in y attributable to the variance in x.
- 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 RSQ(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 ar1} 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 1. ar1 and ar2 are empty or having the different number of data points.
2. The arguments having only one data point. 3. The arguments that are error values or text that cannot be translated in to numbers. We want to know more detail, see PEARSON.
Examples
- =RSQ(A1:A6,B1:B6) = 0.4003286578
- =RSQ(C1:C6,D1:D6) = 0.02320694105
- =RSQ(E1:H1,E2:H2) = 0.72060025461
- =RSQ(E3:E5,G3:G5) = 0.346037364910
- =RSQ(G3:G5,H3:H4) = NAN
See Also
References
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | 12 | 10 | 17 | 21 | 25 | 31 | 19 | 5 |
| 2 | 4 | 37 | 8 | 18 | 0 | 13 | 15 | 41 |
| 3 | 9 | 7 | 23 | 11 | 22 | 30 | 6 | 15 |
| 4 | 50 | 47 | 26 | 13 | 20 | 14 | 33 | 1 |
| 5 | 4 | 17 | 25 | 44 | 2 | 9 | -1 | |
| 6 | 18 | 36 | 40 | 11 |