Calculates the square of r; where r is the Pearson product-moment correlation coefficient of a dataset.
Sample Usage
RSQ(A2:A10, B2:B10)
Syntax
RSQ(data_y, data_x)
- data_y - The array or range representing dependent data.
- data_x - The array or range representing independent data.
Examples
RSQ(A2:A10, B2:B10) returns the square of r, the Pearson product-moment correlation coefficient of the dataset.