Calculate the Correlation Coefficient in Excel

Your goal

You need to calculate the coefficient coefficient (Pearson's \(r\)) between two numerical variables in Excel.

(If you need the coefficient of determination, \(r^2\), just calculate the correlation coefficient \(r\) and square it.)

Step-by-step tutorial

Excel has a CORREL function for calculating the sample correlation coefficient. Let's apply it to the Central Park precipitation data:

Calculating the correlation coefficient

The result:

Calculating the correlation coefficient