The standard error tells you how much your sample mean is likely to differ from the true population mean — the smaller it is, the more precisely your sample average reflects reality. Excel doesn't have a single "STANDARD ERROR" function, but you can calculate it in one line by combining two functions you already know: STDEV.S and SQRT.
This guide from Anchor AI Tools shows you the exact formula, walks through a worked example, and explains how standard error differs from standard deviation so you don't mix the two up.
Quick Answer: To calculate standard error in Excel, divide the sample standard deviation by the square root of the sample size: =STDEV.S(range)/SQRT(COUNT(range)). This is called the standard error of the mean (SEM) — it estimates how much your sample average would vary if you repeated the sampling.
The standard error (SE) measures how much variation you'd expect in the sample mean if you took repeated samples from the same population. A small standard error means your sample mean is likely a precise estimate of the true population mean; a large one means there's more sampling noise, often because the sample is small or the underlying data is spread out.
Standard error is what shows up as the "±" figure in polls, scientific charts, and A/B test reports — for example, "average order value: $48.20 ± $1.35."
=STDEV.S(range)/SQRT(COUNT(range))
Sample standard deviation ÷ square root of the sample sizeIn plain terms: Standard Error = Standard Deviation ÷ √(sample size). As your sample gets larger, the denominator grows, so the standard error shrinks — bigger samples give more precise estimates of the mean.
A2:A9.=STDEV.S(A2:A9) — use STDEV.S for a sample, not STDEV.P, unless your data is the entire population.=COUNT(A2:A9) to get the sample size, n.If you already know your sample size and don't want to recount it each time, you can hard-code it: =STDEV.S(A2:A9)/SQRT(8). Using COUNT() is safer, though, since the formula updates automatically if you add or remove rows.
A teacher records the test scores of 8 students and wants to know the standard error of the class average.
| Student | Score |
|---|---|
| 1 | 82 |
| 2 | 88 |
| 3 | 79 |
| 4 | 91 |
| 5 | 85 |
| 6 | 90 |
| 7 | 77 |
| 8 | 86 |
| Mean | 84.75 |
📋 Formula Used
With scores in A2:A9:
The class average is 84.75, with a standard error of about 1.79. That means if the teacher repeated this test with different groups of 8 students from the same population, the average score would typically fall within roughly ±1.79 points of 84.75.
These two terms get mixed up constantly, but they answer different questions:
| Measure | What It Tells You | Excel Formula |
|---|---|---|
| Standard Deviation | How spread out individual data points are | =STDEV.S(range) |
| Standard Error | How precise the sample mean is as an estimate | =STDEV.S(range)/SQRT(COUNT(range)) |
Standard deviation describes your data. Standard error describes your estimate of the mean. As sample size increases, standard deviation stays roughly the same, but standard error keeps shrinking.
Using STDEV.P instead of STDEV.S. STDEV.P assumes your data is the entire population, which understates variability for a sample. Use STDEV.S unless you truly have every member of the population.
Reporting standard error as if it were standard deviation. They answer different questions — check which one your audience actually needs before you report a number.
Forgetting that small samples produce large, unstable standard errors. With fewer than about 5 data points, the standard error estimate itself becomes unreliable.
Including blank cells or text in the range. COUNT() only counts numeric cells, so a stray text label in your range can quietly shrink your sample size.
This comes up for researchers and students reporting experimental results, data analysts summarizing survey data, quality engineers tracking measurement precision across production batches, and anyone building charts with error bars to show how reliable an average is.
If you're also checking whether a difference between two groups is statistically meaningful, see our guide on how to calculate a p-value in Excel. If you specifically need standard error for chart error bars or a confidence interval, see how to calculate SEM in Excel.
Need more free calculators and formula guides?
Explore Free Tools →SE() or STDERR() function. You calculate it by combining STDEV.S and SQRT(COUNT()): =STDEV.S(range)/SQRT(COUNT(range)).STDEV.S for almost all real-world cases, since you're usually working with a sample rather than the full population. Only use STDEV.P if your data genuinely includes every member of the population you care about.STDEV.S, SQRT, and COUNT with identical syntax, so the same formula works there.P-Value in Excel
Test whether a difference in your data is statistically significant.
SEM in Excel
Use standard error for chart error bars and confidence intervals.
Percentage Calculator
Calculate percentage increase, decrease, and discounts.
Time to Decimal Calculator
Convert hours and minutes to decimal for payroll.
SEO Audit Tool
Check your site's SEO health and AI visibility.
Published by Anchor AI Tools · © 2026 Anchor AI Tools