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.
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.
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:
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.
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.
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.
A few traps catch beginners every time:
Standard deviation rarely lives alone. Pair it with the mean (AVERAGE) and the count (COUNT) to build a quick summary. A typical layout:
=AVERAGE(A2:A11) — the mean=STDEV.S(A2:A11) — the spread=B1+B2 — one standard deviation above the mean=B1-B2 — one standard deviation below the meanThat 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.
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.
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.
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.
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.