How to Use Correlation on Excel 2007

By Greg Lindberg

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.

Step 1

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

Step 2

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

Step 3

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 4

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 5

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."