How to calculate standard deviation in excel (Step-by-Step)

Would you like to know how to calculate the standard deviation in excel? In this article, you will learn how to use the standard deviation. In this, we are using the formula STDEV.P. 

How to Calculate Standard Deviation in Excel

How to calculate standard deviation in excel step by step

Here are the steps for how to calculate the standard deviation in excel.

Here are the seven steps that will help you in this regard

First Step: Open the Excel Document

So are you looking for how to calculate standard deviation in excel? Then you need to follow each step. By doing this, you will learn it like a pro, so without any further delay, let get back to how to calculate standard deviation in excel. Open your Personal computer to perform this task.

  1. For this first, you need to open the start menu. At the bottom of the start, the list enters the word Excel Microsoft. You will see the Option with the Name Excel. Right-click on it and choose the Option. OR you can identify the Excel by its icon. It is the White X against the Dark-green background. When you click on the open, the new windows of the Excel office will appear on the screen.
  2. If you want to open the save date from the excel office for this, you have to double click. Remember, you click the saved documents from the Option. These saved documents usually appear under the option Open. 
  3.  Once you open the saved document or new, you need to click on the empty cell.

So far, it is as simple as ABC. There is no hardcore rule to find how to calculate the standard deviation in excel. After that, move to the second step. So, have a complete grip on how to calculate the standard deviation in excel.

2nd Step: How to calculate mean and standard deviation in excel

  1. Once you have opened the Excel document and click on the black cell, then you need to move to the 2nd Step
  2. In this Step, you need to double click on the Blank Workbook to find how to calculate standard deviation in excel.
  3. It is present on the left side of the Launch page of Excel.
  4. After doing this, you are one step closer to how to calculate standard deviation in excel.
  5. Let move to the third step to learn how to calculate mean and standard deviation in excel.how to calculate standard deviation in excel (1)

3rd Step: Enter values that you would like to use

  1. so after following the steps mentioned above, move to the 3rd Step. For this, you need to pick the column. It is the column where you would like to enter the data. After that type, every value of the data in it. You type the value in the individual cells.
  2. So here is the example of this Step and find out how to calculate sample standard deviation in excel.
  3. Have you selected column A? It is the area where you would like to enter the value of the data? You enter the number n A3, A2, A1, AND so on.how_to_calculate_standard_deviation_in_excel (1)
  4. Till this step, are you following the procedure on how to calculate standard deviation in excel?

4th Step: Click the blank cell

After following the steps mentioned above to learn how to calculate standard deviation in excel 2016, you need to follow the 4th step. It is an easy and smooth process to find out the calculation. If you are following the 1st, 2nd and 3rd step, then move to the 4th one.

  1. You need to click on the blank cell. It is that cell where you would like to display the value of standard deviation. So, select all the cells of standard deviation data. 
  2. Once you have made this move to the 5, the step. So, far it is simple and easy. Let us move to other steps.how_to_calculate_standard_deviation_in_excel (1)

5th step: Now type in a Deviation formula in the empty cells.

You need to type the standard deviation formula that is =STEDV.P( ). Here the P is Population.

  1. You can also find a Sample deviation. Here you will type instead of P is S. So the formula for this is =STDEV.S ( ).
  2. Are you following it so far, if yes then it is excellent they move to the next step that steps no 6? Now you are coming closer to the end.how_to_calculate_the_standard_deviation_in_excel (1)

Also read: How to Lock Cells in Excel

6th Step: Add the value range:

So in between parentheses, you need to type in the number and the letter in a cell containing the first part of the data, type in the colon(:), and also type the number, and the letter is the last cell data. Here is the best example.

  1. For instance, you entered the data in yo the A column from the rows 10 through 1, and then you must have 

=STDV.P (A1Ä10)

  1. Do you like to showcase the standard deviation of a data of few cells like A1, Cs, and B3 yo can enter the name of the cells separately? You commonly use it when entering the name. for example =STDVEV.P(A1,B3,CS)

Now you have almost completed the step. Now you learn how to calculate mean and standard deviation in excel. So move to the next step.how to calculate the standard deviation in excel (1)

7th step: Execute the formula

After performing the above-mentioned step, then you need to hit the button enter from the keyboard to complete the formula. So now, you can calculate the standard deviation because it is simple.how-to-calculate-the-standard-deviation-in-excel (1)

Now you have learned How to calculate standard deviation in excel. It’s time to work in excel. You can calculate the standard deviation easily. You can work online as well on office.com.

Last Words

Have you learned how to calculate standard deviation in excel? If yes, then do let us know. These are some simple steps that can save you a lot of time. After reading these articles, Microsoft Excel is not a more complicated software. It is made to provide you comfort and ease. So let us know what you have learned from it.

Leave a Comment