How to Use Correlation on Excel 2007

Microsoft Excel 2007 is a spreadsheet application that is part of the Microsoft Office 2007 software package. It lets you store data, create charts and graphs, make rosters and perform advanced calculations. You can calculate the correlation coefficient between two types of measurement variables by using the correlation add-in feature. The analysis tool helps you to create an output table and correlation matrix to observe and compare the specific data.

...
Use the correlation analysis tool in Microsoft Excel 2007.

Step

Open Microsoft Excel 2007. Click on the “File” option, then select “Open.”

Step

Locate the Excel file that contains the different variables for which you want to calculate the correlation coefficient, then click “Open.”

Step

Select the data you want to compare by highlighting the data with your mouse. Click on the “Data” tab, then click the “Data Analysis” option from the “Analysis” group.

Step

Click the “Correlation” option, and the Correlation dialog box will appear. Click on the button in the “Input Range” field to make sure the correct fields are selected.

Step

Select the “Columns” or “Rows” option from the “Grouped By” field and then select the “Labels in first row” option. Choose the output range from the “Output options” fields, then click “OK.”