View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default How do I calculate standard error in excel?

Errata....

I wrote:
"Kyle" wrote:
How do I calculate standard error in excel?


=STDEV(range) / SQRT(COUNT(range))


As others noted, arguably it depends on what standard error you want. The
formula above is the standard error of the mean.


----- original message -----

"JoeU2004" wrote in message
...
"Kyle" wrote:
How do I calculate standard error in excel?


=STDEV(range) / SQRT(COUNT(range))

Note that in Excel, STDEV is the sample std dev (variance computed using
n-1), not the population std dev (STDEVP; variance computed using n)