Skip to Content

RSQ

Returns the square of the Pearson product moment correlation coefficient

Syntax

RSQ(known_y's, known_x's)

Parameters

  • known_y's: Required. An array or range of data points
  • known_x's: Required. An array or range of data points

Example

=RSQ(A1:A10, B1:B10)
Returns: NumberSince: Excel 2003