« previous next »
Pages: [1]

Author Topic: Excel and Standard Error  (Read 2845 times)

  • Offline zpyder

  • Posts: 6,946
  • Hero Member
Excel and Standard Error
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!
Logged
Logged

  • Offline zpyder

  • Posts: 6,946
  • Hero Member
Re:Excel and Standard Error
Reply #2 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!
Logged

  • Offline BigSoy

  • Posts: 1,353
  • Hero Member
  • They sicken of the calm, who knew the storm.
Re:Excel and Standard Error
Reply #3 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  :)
Logged
"Within your 'purview'? Where do you think you are, some f**king regency costume drama? This is a government department, not some f**king Jane f**king Austen novel!"
Excel and Standard Error
Reply #4 on: March 29, 2008, 00:08:24 AM
No idea sorry, I just google all the questions Ive got no idea about :)
Logged
Pages: [1]
« previous next »

0 Members and 1 Guest are viewing this topic.