The Excel RSQ function calculates the square of the Pearson Product-Moment Correlation Coefficient for two supplied sets of values.
Syntax: RSQ( array1, array2 )
Where array1 and array2 are two arrays of numeric values and are of equal length.
Rsq Function Example
Columns A and B of the spreadsheet on the right contain two arrays of values. The square of the Pearson Product-Moment Correlation Coefficient of the values in columns A and B of the spreadsheet can be calculated using the Excel Rsq function, as follows:
This gives the result 0.71166629.
Note that this result is the square of 0.843603159, which is the Pearson Product-Moment Correlation Coefficient for the two arrays of values.
Rsq Function Errors
If you get an error from the Excel Rsq function this is likely to be one of the following :
|#N/A||–||Occurs if the two supplied data arrays have different lengths|
|#DIV/0!||–||Occurs if either of the supplied data arrays has length 1 (i.e. contain just one data value)|