RSQ
Returns the square of the Pearson product moment correlation coefficient.
StatisticalStatistics & Analysis
What it does
Calculates R-squared value.
Syntax
RSQ(known_y's, known_x's)
Arguments
known_y's(range) — Y values.known_x's(range) — X values.
Examples
R-Squared
Calculate R2.
FORMULA
=RSQ(B1:B5, A1:A5)
RESULT
0.95
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 2 |
| 3 | 2 | 4 |
| 4 | 3 | 5 |
| 5 | 4 | 8 |
| 6 | 5 | 10 |