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.
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.
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.
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1–1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
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.
Interactive Excel resources on PracticeTestGeeks, free to start:
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.
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
What is the main difference between a PivotChart and a standard Excel chart?
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.
What is the location of the filling handle?
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.
Which function can locate a cell range's highest value?
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.
How would you add several numerical values? Which function?
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.
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.