RSQ function

Category: Statistical
Introduced: Excel 365

Summary

Returns the square of the Pearson product moment correlation coefficient

Syntax

RSQ(known_y's,known_x's) The RSQ function syntax has the following arguments:
• Known_y's Required. An array or range of data points.
• Known_x's Required. An array or range of data points.

Example

=RSQ(A3:A9, B3:B9)

Microsoft Support Page

https://support.microsoft.com/en-us/office/rsq-function-d7161715-250d-4a01-b80d-a8364f2be08f

Back to Functions