Guide for performing a Correlation in Excel

1. Open your data file in Excel.

2. From the Data Tab, choose Data Analysis.

Scroll down until you see Correlation; highlight it, then click on OK.

Using the mouse, highlight the cells containing the data for both of the samples. Click on the circle labeled colums, assuming the data is arranged in that manner.

In the section labeled "Output Options", click on the circle beside output range; then click in the box beside it. Using the mouse, select a cell on your worksheet into which you would like the results to be placed, then click OK.

The resulting information will determine the correlation coefficent for the data sets. The second box on the second row will give this coefficent (in this case 0.77171).

Original work on this document was done by Central Virginia Governor's School students Lauren McGehee, Forrest Frazier, and Tony Lassaletta. (Class of '98).

Copyright © 1997 Central Virginia Governor's School for Science and Technology Lynchburg, VA