How to Calculate the Correlation Coefficient in Excel
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
The correlation coefficient helps you determine the relationship between different variables.
Looking at the actual formula of the Pearson product-moment correlation coefficient would probably give you a headache.
Fortunately, there’s a function in Excel called ‘CORREL’ which returns the correlation coefficient between two variables.
And if you’re comparing more than two variables, Excel also has a ‘Correlation’ tool inside the ‘Analysis ToolPak’.