Guide for Determining a Mean of Data Using Excel

1. Open your data file in Excel.

2. Click in a cell that does not contain any data. The results of your function will appear here.

3. From the Insert menu, select Function.

4. Scroll down until you see Statistical. Click on Statistical.

5. In the Statistical menu, click on AVERAGE and click "OK." 

5. The following dialogue box will appear. Highlight the cells containing the data from the sample and press the "Enter" key. 

6. Click "OK." and the mean of the sample will be calculated.

Original work on this document was done by Central Virginia Governor's School students Jennifer Rice, Eliza Evans, and Chris Earle (Class of '03).

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