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

  2. Kyle

    JoeU2004 Guest

    =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
    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.
    Luke M, Jul 13, 2009
  4. Kyle

    EricG Guest

    EricG, Jul 13, 2009
  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
  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
    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
    Francis, Jul 13, 2009
  7. Kyle

    JoeU2004 Guest

    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, Jul 14, 2009
  8. Kyle


    Nov 9, 2017
    Likes Received:
    Standard Error (SE)
    Click on STDEV and drag across those cells you want to calculate the STDEV of
    put "/SQRT(n)" after the STDEV to divide it by square root of number of samples
    You should have "=STDEV(XX:XX)/SQRT(n)" as the formula in the cell - this will give the SE.
    Laura_Joy, Nov 9, 2017
    1. Advertisements

Ask a Question

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.