How to Do Standard Deviation in Excel: STDEV.S Guide 2026

Standard deviation tells you how spread out your numbers are from the average. In Excel, you don't need to remember the math formula or punch numbers into a calculator. The software handles every calculation in seconds — once you know which function to call. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).

This guide shows you exactly how to do standard deviation in Excel using built-in functions like STDEV.S, STDEV.P, and the older STDEV. You'll learn when to pick a sample formula versus a population formula, how to handle empty cells, and what the result actually means once Excel spits out a number.

Why does this matter? Standard deviation shows up everywhere — quality control reports, financial risk models, A/B test results, lab data, even sports analytics. A low value means your data points cluster tightly around the mean. A high value means they're scattered. Understanding the spread is often more useful than knowing the average alone.

If you're studying for the Excel certification or just trying to build a sharper spreadsheet at work, standard deviation is one of those skills that pays off fast. The function takes one line. The interpretation takes a bit of practice. We'll cover both.

Before you dive in: make sure your data sits in a single column or row with no stray text mixed in. Excel ignores text and logical values by default in STDEV.S and STDEV.P, but messy ranges still trip people up. Clean data first, calculate second.

Microsoft Excel Exam at a Glance

Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

• Free Excel Questions and Answers — 16 questions with instant scoring and answer explanations
• Excel flashcards — review key terms and concepts card by card
• Excel study guide — topic-by-topic overview of what the exam covers
• Excel cheat sheet — one-page printable summary for last-minute review

Pick the Right Standard Deviation Function

Excel ships with several flavors of the standard deviation function — and choosing the wrong one is the most common mistake people make. Here's the short version:

• STDEV.S — sample standard deviation. Use this when your data is a sample drawn from a larger group.
• STDEV.P — population standard deviation. Use this when your data represents the entire population.
• STDEV — older function, works the same as STDEV.S. Still supported for backward compatibility.
• STDEVA and STDEVPA — same as above, but they include text and logical values in the calculation.

Most real-world spreadsheets use STDEV.S. You almost never have data on every single customer, every employee, or every product unit ever made. You're working with a slice. Stick with STDEV.S unless you know for a fact that your range covers everyone.

Step-by-Step: Sample Standard Deviation with STDEV.S

Say you have ten test scores in cells A2 through A11: 78, 82, 91, 67, 88, 75, 94, 80, 85, 73. You want the spread of those scores.

Click an empty cell — let's say B2. Type the formula:

=STDEV.S(A2:A11)

Press Enter. Excel returns roughly 8.34. That's your sample standard deviation. The scores typically fall about 8.34 points away from the average score (which sits around 81.3).

You can also build the formula by clicking. Hit the fx button next to the formula bar, search for STDEV.S, then highlight your range. Same result, different path. Some people prefer the wizard the first few times, then graduate to typing the formula directly once muscle memory kicks in.

How to Calculate Population Standard Deviation

If your data covers every member of the group — say, every player on a 12-person basketball roster — switch to STDEV.P. The syntax matches:

=STDEV.P(A2:A13)

The math difference? STDEV.S divides by n-1 (Bessel's correction). STDEV.P divides by n. For small datasets the gap is noticeable; for large ones it shrinks. But the choice still matters for accuracy in academic and statistical work.

Watch Out for These Common Mistakes

A few traps catch beginners every time:

• Mixing text into the range. If column A has a header like "Score" in A1, don't include A1. Start at A2.
• Empty cells. STDEV.S skips them automatically. But if you accidentally entered a zero where a value should be blank, that zero gets counted — and it'll skew your spread.
• Single value. You can't calculate standard deviation from one number. Excel returns #DIV/0! if you try.
• Wrong function. Reaching for STDEV when you meant STDEV.P throws off the result. Double-check before you publish numbers in a report.

Combine Standard Deviation with Other Statistics

Standard deviation rarely lives alone. Pair it with the mean (AVERAGE) and the count (COUNT) to build a quick summary. A typical layout:

• Cell B1: =AVERAGE(A2:A11) — the mean
• Cell B2: =STDEV.S(A2:A11) — the spread
• Cell B3: =B1+B2 — one standard deviation above the mean
• Cell B4: =B1-B2 — one standard deviation below the mean

That four-cell summary tells you almost everything you need to know about the dataset's shape. Roughly 68% of values fall inside one standard deviation of the mean (assuming a normal distribution). It's a fast way to spot outliers without building a chart.

Use STDEV with Filtered or Conditional Data

Need the standard deviation of only certain rows? Wrap your range in IF logic or pull the values into a helper column. For criteria-based work, the array formula =STDEV.S(IF(B2:B11="A",A2:A11)) entered with Ctrl+Shift+Enter (or just Enter in modern Microsoft Excel) returns the spread for category A only. Pretty handy when you want to compare groups within a single dataset.

Sample Excel Practice Questions

Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.

1. What is the main difference between a PivotChart and a standard Excel chart?

   • A. A PivotChart cannot display a legend
   • B. A PivotChart is linked to a PivotTable and updates as fields change
   • C. A PivotChart only supports pie charts
   • D. A PivotChart cannot be formatted

Answer: B. A PivotChart is linked to a PivotTable and updates as fields change

PivotCharts are bound to PivotTable data and include interactive field buttons.

Answer: B. In the bottom-right corner of the selected cell

The fill handle in Excel is a small square located in the bottom-right corner of a selected cell or range. It is a powerful tool used to quickly copy data, formulas, or extend a series of data (like numbers, dates, or custom lists) to adjacent cells. Dragging this handle allows for efficient data entry and formula replication.

Answer: A. MAX

The `MAX` function in Excel is used to find the largest numerical value within a specified range of cells. You simply provide the cell range as an argument to the function, for example, `=MAX(A1:A10)`. Excel will then return the highest number found within that range.

Answer: A. SUM

To add several numerical values in Excel, the `SUM` function is the most appropriate and commonly used function. You can specify a range of cells, individual cells, or a combination, and the `SUM` function will calculate their total. For example, `=SUM(A1:A10)` would add all numbers in that range.

Take the full Excel practice test

Practice Beats Theory Every Time

Reading about STDEV.S won't lock it into memory. Open a blank workbook right now, paste twenty random numbers into column A, and run the formula. Then change a few values and watch the result shift. That hands-on tinkering builds the intuition no tutorial can match.

If you handle a lot of data on the job, learn the cousins too — VAR.S for variance, MEDIAN, MODE, and PERCENTILE. They all share the same logic and most use identical syntax. Once STDEV.S clicks, the others fall into place quickly.

What the Numbers Tell You

A standard deviation by itself is meaningless without context. A spread of 5 might be huge for shoe sizes and tiny for housing prices. Always compare your standard deviation to the mean (this is called the coefficient of variation) or to a benchmark from your industry. That's how analysts decide whether a result is normal or weird.

For students prepping for Microsoft Excel certification or the MOS exam, standard deviation questions appear under the "Manage Data" and "Perform Operations with Formulas" objectives. Expect to see scenarios with messy ranges, mixed text, and a choice between STDEV.S and STDEV.P. Practice both.

One Last Tip

If you're working in newer versions of Excel — Microsoft 365 or Excel Online — you can drop dynamic array formulas like =STDEV.S(FILTER(A2:A100,B2:B100="Q1")) directly into a cell. No Ctrl+Shift+Enter needed. Filter functions opened up a whole new way to handle conditional statistics, and they pair beautifully with STDEV.S.

Standard deviation isn't hard. It's one function, two forms, and a quick reality check on the result. Build the habit of running it on every dataset you touch. Within a week, you'll spot outliers and unusual spreads the moment a workbook lands on your screen.