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)
|