Calculate the Correlation Coefficient in Excel
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.)
Excel has a
CORREL function for calculating the sample correlation coefficient. Let's
apply it to the
Central Park precipitation data: