Tekforums

Chat => Entertainment & Technology => Topic started by: zpyder on March 28, 2008, 14:27:15 PM

Title: Excel and Standard Error
Post by: zpyder on March 28, 2008, 14:27:15 PM

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!

Title: Excel and Standard Error
Post by: White Giant on March 28, 2008, 17:33:30 PM

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

Title: Re:Excel and Standard Error
Post by: zpyder on March 28, 2008, 18:42:02 PM

Yup, thats the formula I am using :P 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!

Title: Re:Excel and Standard Error
Post by: BigSoy on March 28, 2008, 21:17:31 PM

Quote from: zpyder

Yup, thats the formula I am using :P 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  :)

Title: Excel and Standard Error
Post by: White Giant on March 29, 2008, 00:08:24 AM

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