# 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:

The result: