how to find standard deviation excel

Steps

1. 1

   Open Microsoft Excel. Click or double-click the Microsoft Excel app icon, which resembles a white "X" on a dark-green background. The Excel launch page will open.

   • If you have an Excel document which contains the data you want to use, double-click the document to open it in Excel, then skip ahead to the "Click a blank cell" step.

2. 2

   Click Blank Workbook . It's in the upper-left side of the Excel launch page.

   Advertisement

3. 3

   Enter the values you want to use. Pick a column in which you want to enter your data, then type each data value into individual cells in that column.

   • For example, if you select column "A" as the area in which to enter your data, you might type a number into cell A1, cell A2, cell A3, and so on.

4. 4

   Click a blank cell. This should be the cell in which you want to display the standard deviation value. Doing so selects the cell.

5. 5

   Type in the standard deviation formula. The formula you'll type into the empty cell is =STDEV.P( ) where "P" stands for "Population". Population standard deviation takes into account all of your data points (N).^[1]

   • If you want to find the "Sample" standard deviation, you'll instead type in =STDEV.S( ) here. Sample standard deviation takes into account one less value than the number of data points you have (N-1).

6. 6

   Add your value range. In between the parentheses, type in the letter and number of the cell containing your first piece of data, type in a colon (:), and type in the letter and number of the last data cell.

   • For example, if you entered your data in column "A" from rows 1 through 10, you would have =STDEV.P(A1:A10) typed here.
   • If you just want to display the standard deviation of the value of a few scattered cells such as A1, B3, and C5, you can type the cell names separated by commas (e.g., =STDEV.P(A1,B3,C5)) instead.

7. 7

   Press ↵ Enter . This will prompt Excel to execute the formula, thus displaying the standard deviation of your selected cells in the formula's cell.

   Advertisement

Add New Question

• Question

  How do I use Excel to calculate 2 standard deviations?

  

  Use =STDEV(), and put your range of values in the parentheses. This can be 2 cells or 2 values (numbers).

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Video

• In most cases, you'll use population standard deviation to account for all of the data points you've selected.

Advertisement

• The old =STDEV( ) formula doesn't work in versions of Excel older than 2007.

Advertisement

About This Article

Thanks to all authors for creating a page that has been read 385,887 times.

Is this article up to date?

how to find standard deviation excel

Source: https://www.wikihow.com/Calculate-Standard-Deviation-in-Excel

Posted by: robertscatill93.blogspot.com

Share this post