Microsoft KB Archive/214076

= XL: Formula to Calculate the Standard Error of the Mean =

Article ID: 214076

Article Last Modified on 1/24/2007

-

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

-



This article was previously published under Q214076





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/SQRT

where:
 * The  is the data used to determine the standard deviation.

-and-
 * The  is the size of all the possible random samples.

Additional query words: means XL2000 xl2002 xl2001 xl97 xl98

Keywords: kbhowto KB214076

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.