Excel Instructions: Standard Deviation
- To open Excel with the data in the worksheet, click here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.
- Use Excel to calculate the standard deviation of the three distributions:
- Click a cell outside of the three columns of data, and type =stdev(A2:A28). That is the standard deviation for the first distribution.
- Repeat for the other two distributions, adjusting the data range accordingly.