Question: how to calculate r in excel?
Answer: The correlation coefficient, r can be calculated by using the function CORREL. R squared can then be calculated by squaring r, or by simply using the function RSQ. In order to calculate R squared, we need to have two data sets corresponding to two variables.