RSQ Function in Excel calculates the R Square i.e. it calculates the square of the Pearson Product-Moment Correlation Coefficient for two supplied sets of values.
R SQUARE FORMULA (RSQ):
R SQUARE for two sets of values, x and y, is given by the formula:
where x and y are the sample means of the two arrays of values.
Syntax of RSQ Function in Excel (R Square Function):
RSQ( known_y’s, known_x’s )
Where known_y’s and known_x’s are two arrays of numeric values that are of equal length which you want to calculate the R square of.
Example of RSQ Function in Excel (R Square Function):
The column X and Y contains the two array values. R square of these values can be calculated using formula
=RSQ( A2:A15, B2:B15 )
as shown in the above example. This result in the value of 0.807681.
NOTE:
- #N/A – Occurs if the supplied arrays are of different lengths.