Calculate Correlation in Microsoft Excel

In this article we will learn how we can use the Correlation Analysis in Microsoft Excel 2010.

Correlation is used for determining the relationship between two variables. Excel has an in-built tool for Correlation and the Correl function in Microsoft Excel 2010 and 2013.

If you do not have Analysis tool pack follow below given steps:-

To access this tool, click on Data Tab, click on Data Analysis in the Analysis group. If the Data Analysis command is not available then you need to load the Analysis Toolpak.

To load and activate the Analysis Toolpak follow below mentioned steps:-

• Click the File Tab, Click options and click on Add INS Category.

• In the Manage box, select the Analysis Toolpak and then click on the Go button.

• In the Add Ins dialog box, select the Analysis Toolpak check box and then click Ok.
• If Analysis Toolpak is not listed in the Add Ins available box, click Browse to locate it.

Let’s come back to the topic, to find out the correlation between the data.

This example teaches you how to apply Correlation in data.To use the Correlation, follow the below given steps:-

• Go to Data Tab.
• Click on Data Analysis in the Analyses group.

• Data Analysis dialog box will appear.

• From the Analysis tool drop down menu, Correlation and click on ok.
• Correlation dialog box will appear.
• Click on Input range, select the range A1:C6.
• Click on labels to get the header in report.
• Select the output range where you want to put the data.
• Click on Ok.

We can create the chart to understand the data immediately.

• Select the data, Go to Insert Tab.
• Click on Line Chart in the Chart Group.

You can verify these conclusion by looking at the graph.