Standard Error function

[Sharon]

Does anyone know how to calculate standard error of the mean in Excel. This is a frequently needed scientific calculation which is availble in Quattro Pro, but I can't find it in Excel. I suppose I could look up the statistical function and write the formula into each cell, but that's a pain.

 

[Peo Sjoblom]

=STDEV(Range)/SQRT(COUNT(Range))



--

Regards,

Peo Sjoblom

Does anyone know how to calculate standard error of the mean in Excel.

This is a frequently needed scientific calculation which is availble in
Quattro Pro, but I can't find it in Excel. I suppose I could look up the
statistical function and write the formula into each cell, but that's a
pain.

 

[Sharon]

Thanks. That's what I did, but it seems to me that Excel ought to have that in their list.
Sharon

 

[Jerry W. Lewis]

Assuming that the observations are uncorrelated.

Jerry

 

[dayofsun]

=Steyx()

 

[Bernie Deitrick]

Your point being? STEYX() is simply STandard Error of Y values for
each X value in a regression.....

Bernie
MS Excel MVP