You are currently offline, waiting for your internet to reconnect

XL: Formula to Calculate the Standard Error of the Mean

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

Summary
Although the Descriptive Statistics tool in the Analysis ToolPak can generate a report that includes the standard error of the mean, there is no function in Microsoft Excel to automatically calculate this value by itself.
More information
To calculate the standard error of the mean by itself, use the one of the following formulas
= STANDARD DEVIATION / SQUARE ROOT OF THE POPULATION SIZE

-or-

= STDEV(range of values)/SQRT(number)
where:
  • The range of values is the data used to determine the standard deviation.

    -and-
  • The number is the size of all the possible random samples.
means XL2003 XL2007 XL2010
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 214076 - Last Review: 09/23/2015 06:43:00 - Revision: 4.0

Microsoft Office Excel 2003, Microsoft Office Excel 2007, Microsoft Excel 2010, Excel 2016, Microsoft Excel 2013

  • kbhowto KB214076
Feedback
" src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">