How Do You Calculate Mean And Standard Deviation With Excel 2007?
• Enter the range of numbers in your Excel spreadsheet. After the data has been entered, place the cursor where you wish to have the mean (average) appear and click the mouse button. • Click on the formulas tab and then the Insert Function (fx) button. • Wait for the dialog box to appear and scroll down and select the AVERAGE function. • Enter the cell range for your list of numbers in the number 1 box, for instance D4:D13 and click OK. The mean (average) for the list will appear in the cell you selected. • Place your cursor where you wish to have it appear and click on the Insert Function (fx) tab again. • Scroll down the dialog box and select the STDEV function. Enter the cell range for your list of numbers in the number 1 box and click OK. The standard deviation will appear in the cell you selected.
