• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Standard Deviation in Excel

April 8, 2021 by Andrew Childress
Standard deviation in Excel

Standard deviation helps you measure how much variability your data has. It’s easy to calculate using a spreadsheet. Let’s learn how to find standard deviation in Microsoft Excel.

How to Find Standard Deviation in Excel

Standard deviation looks at how your values are distributed around the mean of your dataset. You can find it two different ways in Excel. The difference comes when you’re working with either a sample or an entire population.

Consider a table of sample data. This is understood to not represent an entire population. That means you’ll want to use Excel’s STDEV.S function. The S stands for a sample. If you have an entire population of data, use the STDEV.P function. The remainder of the process is identical.

To find the standard deviation in Excel for this dataset, begin by clicking into an empty cell. Type =, which tells Excel to begin a formula. Next, type STDEV.S, and then (.

Standard deviation Excel

So far, your formula reads:

=STDEV.S(

Now, it’s time to select the range of data. All you’ll need is the numerical data, which is in column B in this example. Labels, column headers, and other details aren’t needed and shouldn’t be included.

Click and drag your cursor to highlight the range of data. Here, that’s B2:B6. Once you’ve done that, close the parentheses by typing ). Your entire standard deviation formula in Excel now reads:

=STDEV.S(B2:B6)

Standard deviation in Excel

Hit Enter, and Excel will return the standard deviation value in the cell you selected.

Find standard deviation

Remember when we talked about the standard deviation of a population? Imagine for a moment that this same dataset represented the entire population, not just a sample of it. As mentioned, your formula would vary only by one character:

=STDEV.P(B2:B6)

P, of course, refers to the population, while S referred to a sample.

As you can see, it’s easy to find standard deviation in Excel.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add line graph to ExcelLine Chart Excel
Next Post:Forecasting in ExcelForecasting in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top