Excel Function : RSQ
Category
Statistical
Description
Returns the square of the Pearson product moment correlation coefficient
Microsoft Excel Reference Page
https://support.office.com/en-us/article/RSQ-function-d7161715-250d-4a01-b80d-a8364f2be08f
Syntax and Description of the RSQ Excel Function
=RSQ(y range, x range)
About RSQ Excel Function
The RSQ function returns the square of the Pearson product moment correlation coefficient, R, through data points in known_y's and known_x's.
