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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Mark Greenough

    Excel 97 Standard Toolbar

    Mark Greenough, Sep 11, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    391
    Mark Greenough
    Sep 11, 2003
  2. tony lincoln

    standard error bar in excel

    tony lincoln, Oct 23, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,130
    Bernard V Liengme
    Oct 23, 2003
  3. 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:
    1,137
  4. Guest
    Replies:
    3
    Views:
    291
    Jim Cone
    Nov 7, 2004
  5. Guest
    Replies:
    1
    Views:
    395
    Guest
    Nov 19, 2004
  6. Guest

    convert pocket excel back to standard excel

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

    calculate time does not calculate

    Wanna Learn, Aug 18, 2008, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    500
    MillyD
    Aug 18, 2008
  8. zizi
    Replies:
    2
    Views:
    13,394
Loading...