Guide for Determining the Standard Deviation Using Excel

1. From the Insert menu, select Function.

2. In the Statistical menu, scroll down until STDEV appears. Select STDEV and click "OK."

3. The following dialogue box will appear. Using the mouse, highlight the cells containing the data from the sample.

4. Click "OK," and the standard deviation of the data will be computed.


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