How to Calculate Mean and Standard Deviation With Excel 2007

Adding Data

1. 
   Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a green "X" on a green-and-white background.

   1. If you already have an Excel document that contains your data, double-click the document to open it in Excel 2007, then skip ahead to finding the mean.
2. 
   Select a cell for your first data point. Click once the cell in which you want to enter your first number.

   1. Be sure to select a cell in a column that you want to use for the rest of your points.
3. 
   Enter a number. Type in one of your data points' numbers.
4. 
   Press ↵ Enter. Doing so will both enter the number into your selected cell and move your cursor down to the next cell in the column.
5. 
   Enter each of the rest of your data points. Type in a data point, press Enter, and repeat until you've entered all of your data points in the same column. This will make it easier to calculate the mean and the standard deviation of the list.