How to Calculate Standard Error in Excel

If you want to find out how reliable your sample average is, you need the standard error, and Excel does not give you a single button for it.

But nothing to worry about. It is easy to get once you know which functions to combine, and in this article I will show you a few simple ways to calculate the standard error of the mean in Excel.

This Tutorial Covers:

What Is Standard Error (And How Is It Different From Standard Deviation)?

Before we jump into the formulas, let me quickly explain what the standard error actually tells you.

When you collect a sample, you calculate its average and use that average to guess the average of the whole group. The standard error tells you how close that guess is likely to be to the real average.

A small standard error means your sample average is a precise estimate. A large one means it could be off by quite a bit.

This is where people often get confused with standard deviation, so here is the difference in plain terms.

Standard deviation measures how spread out your individual data points are. Standard error measures how much your sample average would jump around if you took the sample again and again.

The formula for the standard error of the mean is simple. You take the sample standard deviation and divide it by the square root of the sample size.

Method 1: Using a Single Formula (STDEV.S, SQRT, and COUNT)

The easiest way to get the standard error is to combine three functions into one formula: STDEV.S, SQRT, and COUNT.

This gives you the answer in one cell, and you do not need any helper columns. Let me show you how it works.

Below I have the test scores of 10 students, sitting in cells A2:A11. I want to find the standard error of the average score.

Excel dataset in column A with header Test Score followed by ten numerical test scores from rows 2 to 11

Here is the formula:

=STDEV.S(A2:A11)/SQRT(COUNT(A2:A11))

Excel formula =STDEV.S(A2:A11)/SQRT(COUNT(A2:A11)) calculating standard error for test scores in column A

For this dataset, the formula returns about 1.94.

How does this formula work?

STDEV.S(A2:A11) calculates the sample standard deviation of the scores, which comes out to about 6.14. I have used STDEV.S because these 10 scores are a sample, not every score that exists.

COUNT(A2:A11) counts how many numbers are in the range, which is 10. I have wrapped it inside SQRT(), so this part gives me the square root of 10, which is about 3.16.

Dividing 6.14 by 3.16 gives roughly 1.94, which is the standard error of the mean.

So I can say the average score of 85.8 has a standard error of about 1.94.

Use STDEV.S when your data is a sample, which is the case most of the time. If you genuinely have every value in the entire population, swap it for STDEV.P instead.

Method 2: Using Helper Cells

If the all-in-one formula feels like a lot, you can break it into separate cells. This makes each step easy to see and check.

This is also handy when you want to show the standard deviation and the count on the sheet anyway.

Let’s suppose you have the same 10 test scores in cells A2:A11.

Excel dataset showing Test Score header in cell A1 followed by ten numerical test scores in cells A2 through A11

Here is the standard deviation, which you can put in cell D2:

=STDEV.S(A2:A11)

Excel formula bar showing STDEV.S(A2:A11) to calculate standard deviation for test scores in column A

Here is the count of scores, which you can put in cell D3:

=COUNT(A2:A11)

Excel formula bar showing =COUNT(A2:A11) to calculate the count of test scores in column A

Now you have the two pieces you need. Put the formula below in cell D4 to get the standard error:

=D2/SQRT(D3)

Excel formula =D2/SQRT(D3) calculating standard error using standard deviation and count in helper cells

This returns the same 1.94 as Method 1, just spread across three cells.

The advantage here is that you can glance at the standard deviation (6.14) and the count (10) on their own. If something looks off, it is easy to spot which part is causing it.

Method 3: Using the Data Analysis ToolPak

If you would rather not type formulas, Excel has a built-in tool that gives you the standard error directly, along with a bunch of other summary stats.

This is the Data Analysis ToolPak. It is an add-in that ships with Excel but stays switched off until you enable it.

If you have never used it, you will need to turn it on first.

We are still working with those same 10 test scores in A2:A11 (with a header in A1), and the goal is to let the ToolPak hand us the standard error directly.

Excel dataset in column A with header Test Score and ten numerical values from 72 to 91 for se 07 method3 calculation

Here are the steps to enable the Analysis ToolPak:

Click the File tab, then click Options, then go to Add-ins.

Excel Options dialog box with the Add-ins menu item selected and highlighted by a red border

At the bottom, next to Manage, make sure Excel Add-ins is selected and click Go.

Excel Add-ins selected in the Manage drop-down menu with a red border highlight

Check the box for Analysis ToolPak and click OK.

Excel Add-ins dialog box with a red box highlighting the checked Analysis ToolPak option

You will now see a Data Analysis button on the right side of the Data tab.

With the ToolPak enabled, here are the steps to get the standard error:

Go to the Data tab and click Data Analysis.

Excel ribbon with the Data tab selected and a red box highlighting the Data Analysis button in the Analysis group

In the dialog box that opens, select Descriptive Statistics and click OK.

Data Analysis dialog box with Descriptive Statistics highlighted in blue and outlined in red

For the Input Range, select your data (here that is A1:A11, including the header).

Descriptive Statistics dialog box with the Input Range field highlighted, showing the range $A$1:$A$11 including the header

Check Labels in first row, then pick an Output Range or a new worksheet, and check Summary statistics.

Descriptive Statistics dialog with Labels in first row, New Worksheet Ply, and Summary statistics options highlighted

Click OK.

Excel Data Analysis Toolpak output showing descriptive statistics for Test Score, including mean, median, and range

Excel drops a small table of summary statistics onto the sheet. The second row is labeled Standard Error, and for our scores it shows about 1.94, the same value we got from the formulas.

Pro Tip: The ToolPak gives you a snapshot. If you change the data later, the numbers do not update on their own. You have to run Descriptive Statistics again. For a result that always stays current, use the formula in Method 1 instead.

Things to Keep in Mind

Use STDEV.S for a sample and STDEV.P for a full population. Most real-world data is a sample, so STDEV.S is the right pick in almost every case. Only use STDEV.P when your range literally contains every value in the group.

COUNT function only counts numbers. It skips blank cells and text, so your sample size stays correct even if a few cells are empty. If your data accidentally has text where numbers should be, the count will be lower than you expect.

The standard error shrinks as your sample gets bigger. Since you are dividing by the square root of the sample size, more data points pull the standard error down. That is the math behind why larger samples give more reliable averages.

The ToolPak result is a one-time calculation. It does not recalculate when your data changes, unlike the formulas. Re-run the tool whenever your data updates.

In this article, I showed you three ways to calculate the standard error of the mean in Excel, using a single formula, helper cells, and the Data Analysis ToolPak.

I hope you found this article helpful.