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

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

Jerry

"Steph" wrote:

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

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.

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)
whe
• 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.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562037