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.
What Is Standard Error?
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.”
The Standard Error Formula
=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.
Step-by-Step in Excel
- List your data in one column. For example, values in
A2:A9. - Calculate the sample standard deviation. Use
=STDEV.S(A2:A9). ChooseSTDEV.Sfor a sample, notSTDEV.P, unless your data is the entire population. - Count your data points. Use
=COUNT(A2:A9)to get the sample size, n. - Combine them in one formula. Divide the standard deviation by the square root of the count.
// Standard error for data in A2:A9
=STDEV.S(A2:A9)/SQRT(COUNT(A2:A9))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.
Worked Example
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:
=STDEV.S(A2:A9)/SQRT(COUNT(A2:A9))Result: SE ≈ 1.79
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.
Standard Error vs. Standard Deviation
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. For the step-by-step on STDEV.S versus STDEV.P, see how to calculate standard deviation in Excel.
Common Mistakes to Avoid
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, so 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.
Who Needs to Calculate Standard Error in Excel?
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 ToolsFrequently Asked Questions
Does Excel have a built-in standard error function?
No. There’s no single SE() or STDERR() function. You calculate it by combining STDEV.S and SQRT(COUNT()): =STDEV.S(range)/SQRT(COUNT(range)).
Should I use STDEV.S or STDEV.P for standard error?
Use 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.
What’s the difference between standard error and margin of error?
Margin of error is usually the standard error multiplied by a critical value (like 1.96 for a 95% confidence level). Standard error alone doesn’t tell you a confidence level. It’s the building block used to calculate one.
Why is my standard error a very large number?
A large standard error usually means a small sample size, highly variable data, or both. Check your sample size first, because standard error shrinks as you add more data points.
Can standard error be zero?
Only if every value in your dataset is identical (standard deviation = 0), or in the theoretical case of an infinitely large sample. In practice, a standard error of exactly zero is a sign to double-check your data range.
Does Google Sheets calculate standard error the same way?
Yes. Google Sheets supports STDEV.S, SQRT, and COUNT with identical syntax, so the same formula works there.
Related Free Guides & Tools From Anchor AI Tools
Accuracy Note: This guide explains standard statistical formulas for planning and educational purposes. For research, clinical, or regulated reporting, confirm your method and results with a qualified statistician.
Content Lead, Anchor AI Tools, California, USA. Spotted an error? Email hello@anchoraitools.com and it will be checked and corrected. See our editorial standards.