Question: what is the difference between rsq and correl excel?
Answer: RSQ is calculated by essentially calculating PEARSON and squaring the result. Because PEARSON and CORREL both compute the Pearson Product-Moment Correlation Coefficient, their results should agree. ... Therefore, an alternative to RSQ for an earlier version of Excel is to use CORREL instead and then to square the result.