# How do I calculate standard error in excel?

Discussion in 'Microsoft Excel Misc' started by Kyle, Jul 13, 2009.

1. ### KyleGuest

How do I calculate standard error in excel?

Kyle, Jul 13, 2009

2. ### JoeU2004Guest

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

JoeU2004, Jul 13, 2009

3. ### Luke MGuest

If your referring to statistics, I think you mean standard deviation (how far
data is off from the average). In which case, you want to use STDEV.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Kyle" wrote:

> How do I calculate standard error in excel?

Luke M, Jul 13, 2009
4. ### EricGGuest

EricG, Jul 13, 2009
5. ### Jim ConeGuest

Look up "standard error" in the Excel help file and see what is says about "STEYX"
--
Jim Cone
Portland, Oregon USA

"Kyle" <>
wrote in message
How do I calculate standard error in excel?

Jim Cone, Jul 13, 2009
6. ### FrancisGuest

assuming that your data are as :
Known y's are in range A2: A20
Known x's are in tange B2 : B20

try this
=STEYX(A2:A20,B2:B20)
--

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

"Kyle" wrote:

> How do I calculate standard error in excel?

Francis, Jul 13, 2009
7. ### JoeU2004Guest

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
news:...
> "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)

JoeU2004, Jul 14, 2009