How to Use Correlation on Excel 2007

1. Open Microsoft Excel 2007. Click on the 'File' option, then select 'Open.'
2. Locate the Excel file that contains the different variables for which you want to calculate the correlation coefficient, then click 'Open.'
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.
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.
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.'