What is the function to calculate standard errors of the mean?

S

Steph

I'd like to calculate standard errors of the mean using the Excel function
tab... any idea how you do that?
 
J

Jerry W. Lewis

Assuming independence of observations, the standard error of AVERAGE(data) is
STDEV(data)/SQRT(COUNT(data))

Jerry
 
D

Dav

Although the Descriptive Statistics tool in the Analysis ToolPak ca
generate a report that includes the standard error of the mean, ther
is no function in Microsoft Excel to automatically calculate this valu
by itself.

To calculate the standard error of the mean by itself, use the one o
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 standar
deviation.

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

Regards

Da
 
Top