# How to Calculate SEM in Excel (3 Handy Cases)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for ways to calculate SEM or Standard Error Mean in Excel, then this article is for you. SEM will indicate whether the values of the dataset are staying away or closer to the mean point of that dataset. To know more details about this statistical parameter letâ€™s start with our main article.

## How to Calculate SEM in Excel: 3 Handy Ways

Here, we have the following dataset containing the Student IDs, Student Names, and Marks of the students. By using the following 3 ways we will determine the SEM or Standard Error Mean of the Marks.

We have used the Microsoft Excel 365 version here, you can use any other version at your convenience.

### Method-1: Implementing Analysis Toolpak to Calculate SEM in Excel

In this section, we are going to use the Descriptive Statistics option from different options of the Analysis Toolpak to calculate SEM for the following Marks of the students.

Steps:
If you donâ€™t have activated the Analysis Toolpak, then you have to activate this Analysis Toolpak first.
âž¤ Go to the File Tab.

âž¤ Select the Options Option.

After that, the Excel Options dialog box will open up.
âž¤ Select the Add-ins option from various options in the left pane and then choose the Analysis Toolpak in the right part.
âž¤ Choose the Excel Add-ins option in the Manage box and then click on the Go option.

Then, the Add-ins wizard will pop up.
âž¤ Check the Analysis ToolPak option and press OK.

In this way, we have activated the Analysis ToolPak.
âž¤ Go to the Data Tab >> Analysis Group >> Data Analysis Option.

Afterward, the Data Analysis wizard will appear.
âž¤ Click on the Descriptive Statistics option and press OK.

Later, you will be taken to the Descriptive Statistics wizard.
âž¤ Select the following.

• Input Range â†’ \$D\$4:\$D\$13
• Grouped By â†’ Columns
• Output Range â†’ \$E\$3

âž¤ Check the Summary statistics option and press OK.

Finally, the summary of different statistical calculations will be shown in our given output range and here we have gained the Standard Error of 2.769877655 which represents the SEM value of the marks.

Read More: How to Calculate Standard Error in Excel

### Method-2: Using STDEV.S, SQRT, and COUNT Functions to Calculate Standard Error Mean

Here, we will use the combination of the STDEV.S, SQRT, and COUNT functions to determine the SEM value of the Marks of the students. You can also use the STDEV function instead of the STDEV.S function.

Steps:
âž¤ Type the following formula in cell C15.

`=STDEV.S(D4:D13)/SQRT(COUNT(D4:D13))`

Here, D4:D13 is the range of the Marks.

• STDEV.S(D4:D13) â†’ returns the standard deviation of a list of values of the sample D4:D13.
• Output â†’ 8.75912222898061
• COUNT(D4:D13) â†’ counts the number of cells with numeric values.
• Output â†’ 10
• SQRT(COUNT(D4:D13)) â†’ gives the square root value
• Output â†’ 3.16227766016838
• STDEV.S(D4:D13)/SQRT(COUNT(D4:D13)) â†’ becomes
• 8.75912222898061/3.16227766016838
• Output â†’ 2.769877655

âž¤ Press ENTER.
Then, you will get the SEM or Standard Error Mean value of the marks.

### Method-3: Using STDEV.P, SQRT, and COUNT Functions to Calculate SEM in Excel

You can also use the STDEV.P function with the combination of the SQRT, and COUNT functions to calculate the Standard Error Mean value of the marks of the students.

Steps:
âž¤ Apply the following formula in cell C15.

`=STDEV.P(D4:D13)/SQRT(COUNT(D4:D13)-1)`

Here, D4:D13 is the range of the Marks.

• STDEV.P(D4:D13) â†’ returns the standard deviation of a list of values of the population.
• Output â†’ 8.30963296421689
• COUNT(D4:D13) â†’ counts the number of cells with numeric values.
• Output â†’ 10
• SQRT(COUNT(D4:D13)-1) becomes
• SQRT(10-1) â†’ SQRT(9) â†’ gives the square root value
• Output â†’ 3
• STDEV.P(D4:D13)/SQRT(COUNT(D4:D13)-1) becomes
• 8.30963296421689/3
• Output â†’ 2.769877655

After pressing ENTER, you will get the desired SEM value of the Marks.

## Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.

## Conclusion

In this article, we tried to cover the steps to calculate SEM in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

## Related Articles

<< Go Back to Standard ErrorÂ in Excel | Excel for StatisticsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF