1 / 12

Instruction on calculating Standard Deviation in Excel

Instruction on calculating Standard Deviation in Excel. Standard Deviation Formula. Population Standard Deviation : = Population Standard Deviation = Population Mean = Each Value = Dispersion: how far each value is from the mean. Sample Standard Deviation :

odell
Download Presentation

Instruction on calculating Standard Deviation in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Instruction on calculating Standard Deviation in Excel

  2. Standard Deviation Formula Population Standard Deviation: = Population Standard Deviation = Population Mean = Each Value = Dispersion: how far each value is from the mean Sample Standard Deviation: = Sample Standard Deviation = Sample Mean = Each Value = Dispersion: how far each value is from the mean

  3. 1. Copy the data to excel

  4. 2. Calculate the mean Select a cell in excel Enter the = sign in the cell Type in Average Double click on the formula and select the data Close parenthesis by doing Shift + 0 Press Enter

  5. 3. Find the Dispersion Dispersion is the difference between each data and the mean. Next to the column near the first data Enter the equal sign Select the first data Enter the minus sign Select the mean Enter

  6. 3. Continue • Next we want to copy the dispersion formula for the rest of the data. To do this we need to make the mean cell fixed • For that select the cell • Click next to the cell number which in this example is A11 • Function + F4, note this will place $ next to cell column and row the. i.e. $A$11 • Now place your mouse in the lower right corner of the cell, once you see the filled in plus sign, left click and drag down

  7. 4. Dispersion squared Go to the next column on the first row Enter the equal sign Select the Dispersion cell, in this example B4 Then Shift + 6 The number 2 And then enter

  8. 4. Continue Now we need the same formula for all the other values. So place your mouse in the lower right corner of the cell, once you see the filled in plus sign, left click and drag down

  9. 5. Sum the dispersion squares Select a cell Enter the equal sign Enter the word sum Select the data Shift + 0 to close the parenthesis Enter

  10. 6. Divide the number from step 5 If you are calculating the sample standard deviation divide the number from step 5 by one less than the number of data. If you are calculating the population, then divide the number from step 5 to number of data Select a cell Enter the equal sign Select the cell that has step 5’s value The division sign Then enter the number. For this example there are 7 numbers. So we divide by 7 Enter

  11. 7. Take square root This is the last step. We need to take the square root of the number we found in part 6. To do that follow the following steps Enter the equal sign into a cell Then type SQRT and select Excel's formula Select the cell from step 6 Shift+0 to close parenthesis Enter

  12. Alltogether Here is the entire excel parts:

More Related