Article ID: 214076 - Last Review: January 24, 2007 - Revision: 2.2

XL: Formula to Calculate the Standard Error of the Mean

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.
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
Back to the top
Keywords: 
kbhowto KB214076
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

 

Related Support Centers