Question: how to use rsq in excel?
Answer: 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.
=RSQ( A2:A15, B2:B15 )
NOTE: