Home>Blogs>Predictive Analytics>Correlation Coefficient in Excel
Correlation Coefficient
Predictive Analytics

Correlation Coefficient in Excel

In this article, we have explained how to calculate the Correlation Coefficient in Microsoft Excel. We have explained it using Excel Formula and Data Analysis Add-in.

What is Correlation Coefficient?

A correlation coefficient is a numerical measure of some type of correlation, meaning a statistical relationship between two variables. Correlation can be between -1 to +1. Correlation in minus is called negative correlation and in plus called positive correlation. If correlation value is close to ±1 then it is called strong correlation if it is close to zero then it is called poor correlation.

How to Correlation Coefficient using Excel formulas?

We can use “CORREL” Or “PEARSON” Excel formula to calculate the correlation between to variables.

For example, we have height and weight data points as given in below image –

Height and weight data points
Height and weight data points

Below is the formula to calculate the correlation-



Correlation using Excel Formula
Correlation using Excel Formula


You can use the Data Analysis Add-in also. It can help you calculate the multiple variables correlation with each other.

if the Data Analysis command is not available in your version of Excel, you need to load the Analysis ToolPak add-in program. These instructions apply to Excel 2010, Excel 2013 and Excel 2016.


  • Click the File tab, click Options, and then click the Add-Ins category.
  • In the Manage box, select Excel Add-ins and then click Go.
  • In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
  • Data Analysis button will be available in Data tab.

Below is the steps to get the multiple variables correlation with each other.

  • Click on Data Analysis button in Data Tab
  • Data Analysis window will be opened.
  • Select the Correlation in this window and click on OK
Data Analysis window
Data Analysis window
  • Provide the input range in Correlation window (Select the data including headers)
  • Tick the Label in first row check box
  • Click on OK.
Correlation window
Correlation window
  • Correlation summary will be created on new worksheet.
Correlation summary
Correlation summary

Click here to download this practice file.

Watch the step by step video tutorial:

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!