Hi All
Im just after a quicky to make sure Im not being dumb...does excel have a basic formula to calculate the Standard Error of a mean?

I mean, you have Stdev for the deviation of a bunch of rows, but from what I have read/know, to get the error, you need to use a longer formula in the style of:

=(STDEV(A1:A2))/(SQRT(COUNT(A1:A2)))

Which is just stupid to be honest!

http://mtsu32.mtsu.edu:11009/Graphing_Guides/Excel_Guide_Std_Error.htm  ?

Yup, thats the formula I am using My question is, if there a function that cuts all that down to something similar to "=stdev" like "=sterr" or something. Itd be easy enough for them to do!

Quote from: zpyderYup, thats the formula I am using My question is, if there a function that cuts all that down to something similar to "=stdev" like "=sterr" or something. Itd be easy enough for them to do!

Cant remember if this or isnt tbh, but alternatively you could write your Custom sterr function based around that formula  

No idea sorry, I just google all the questions Ive got no idea about