How do I calculate standard error in excel?

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

  1. Kyle

    Kyle Guest

    How do I calculate standard error in excel?
     
    Kyle, Jul 13, 2009
    #1
    1. Advertisements

  2. Kyle

    JoeU2004 Guest

    "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
    #2
    1. Advertisements

  3. Kyle

    Luke M Guest

    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
    #3
  4. Kyle

    EricG Guest

    EricG, Jul 13, 2009
    #4
  5. Kyle

    Jim Cone Guest

    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
    #5
  6. Kyle

    Francis Guest

    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)
    --
    Hope this is helpful

    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
    #6
  7. Kyle

    JoeU2004 Guest

    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
    #7
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tony lincoln

    standard error bar in excel

    tony lincoln, Oct 23, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    782
    Bernard V Liengme
    Oct 23, 2003
  2. Bernie Deitrick

    Re: Calculate once - "lookup" value once and never calculate again

    Bernie Deitrick, Jul 15, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    448
  3. Guest

    convert pocket excel back to standard excel

    Guest, Dec 9, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    186
    Guest
    Feb 16, 2006
  4. Wanna Learn

    calculate time does not calculate

    Wanna Learn, Aug 18, 2008, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    325
    MillyD
    Aug 18, 2008
  5. zizi
    Replies:
    2
    Views:
    7,501
Loading...

Share This Page