PDF download Download Article

Step-by-step tutorial for the STDEV functions

PDF download Download Article

This wikiHow shows you how to find the standard deviation of a dataset in Microsoft Excel. Whether you’re studying for statistics, analyzing data at work, or just researching something for fun, calculating a standard deviation is essential. And, it’s pretty easy to do in Excel! There are built-in functions for calculating the standard deviation.

Things You Should Know

  • There are four functions for calculating standard deviation.
  • STDEV.P and STDEV.S cover most situations. Use STDEV.P for populations and STDEV.S for samples.
  • The function will calculate the standard deviation for a selected range of cells.
  1. Pick a column in which you want to enter your data, then type each data value into individual cells in that column. Using Excel is a great way to organize and analyze your data.
    • 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.
    • If needed, you can move columns in your spreadsheet to organize your data.
  2. There are four functions in Excel for calculating standard deviation. The functions differ in two ways: [1]
    • The selected function will either calculate the standard deviation for a sample (using n - 1) or a population (using n), where n is the sample size.
    • The selected function will include or exclude logical values (TRUE and FALSE) and text (numbers represented as text). TRUE is interpreted as a 1, while FALSE is 0.
    Advertisement
  3. Here are the four options for calculating standard deviation:
    • STDEV.P — Finds the standard deviation of a population. This function doesn’t include logical values or text. [2]
    • STDEV.S — Finds the standard deviation of a sample. This function doesn’t include logical values or text. [3]
    • STDEVA — Finds the standard deviation of a sample. This function does include logical values or text. [4]
    • STDEVPA — Finds the standard deviation of a population. This function does include logical values or text. [5]
    • There are also two outdated functions that have been replaced by the above functions. They are still present in Excel for backward compatibility reasons, but may be phased out in future versions.
      • STDEV — This function was replaced by STDEV.S. Finds the standard deviation of a sample. This function doesn’t include logical values or text. [6]
      • STDEVP — This function was replaced by STDEV.P. Finds the standard deviation of a population. This function doesn’t include logical values or text. [7]
  4. This should be the cell in which you want to display the standard deviation value. Doing so selects the cell.
  5. In the cell you selected, enter the standard deviation function you want to use. Here is STDEV.S() as an example:
    • =STDEV.S()
  6. To do so:
    • In between the parentheses, type the letter and number of the cell containing your first data value.
    • Type a colon (:)
    • Type the letter and number of the last cell.
    • For example, if you entered your data in column "A" from rows 1 through 10, you would have =STDEV.S(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.S(A1,B3,C5) ).
  7. This will prompt Excel to run the formula, displaying the standard deviation of the selected cells in the formula's cell.
  8. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I use Excel to calculate 2 standard deviations?
    Community Answer
    Use =STDEV(), and put your range of values in the parentheses. This can be 2 cells or 2 values (numbers).
Ask a Question
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 529,100 times.

      Is this article up to date?

      Advertisement