XL: Formula to Calculate the Standard Error of the Mean

Article translations Article translations
Article ID: 214076 - View products that this article applies to.
This article was previously published under Q214076
Expand all | Collapse all

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.

Properties

Article ID: 214076 - Last Review: January 24, 2007 - Revision: 2.2
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbhowto KB214076

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com