This function returns the square of the Pearson product moment correlation coefficient (R‑squared) through data points in known y’s and known x’s.
RSQ(array_dep,array_ind)
This function has these arguments:
| Argument | Description |
|---|---|
| array_dep | Array of dependent values (y’s) |
| array_ind | Array of independent values (x’s) |
The arrays must be the same size.
Accepts numeric data for both arguments. Returns numeric data.
RSQ(B2:B14,H2:H14)
RSQ(R2C2:R14C2,R2C8:R14C8)
RSQ({2,4,6},{10,15,25}) gives the result 0.964286
