Least Significant Difference calculation

Discussion in 'Microsoft Excel Misc' started by Peggy, Jun 27, 2008.

  1. Peggy

    Peggy Guest

    After I have done an ANOVA how do I calculate the LSD. i don't find that the
    program does this for me. Do I have to do it manually???
     
    Peggy, Jun 27, 2008
    #1
    1. Advertisements

  2. Peggy

    Fred Smith Guest

    This is an Excel newsgroup. Do you have an Excel question?

    Regards,
    Fred.

    "Peggy" <> wrote in message
    news:...
    > After I have done an ANOVA how do I calculate the LSD. i don't find that
    > the
    > program does this for me. Do I have to do it manually???
     
    Fred Smith, Jun 28, 2008
    #2
    1. Advertisements

  3. Peggy -

    As you have observed, the three Anova tools of the Analysis ToolPak do not
    calculate the LSD.

    So, yes, you would have to use worksheet functions and formulas.

    - Mike Middleton
    http://www.DecisionToolworks.com
    Decision Analysis Add-ins for Excel


    "Peggy" <> wrote in message
    news:...
    > After I have done an ANOVA how do I calculate the LSD. i don't find that
    > the
    > program does this for me. Do I have to do it manually???
     
    Mike Middleton, Jun 28, 2008
    #3
  4. Peggy

    Peggy Guest

    "Fred Smith" wrote:

    > This is an Excel newsgroup. Do you have an Excel question?
    >
    > Regards,
    > Fred.
    >
    > "Peggy" <> wrote in message
    > news:...
    > > After I have done an ANOVA how do I calculate the LSD. i don't find that
    > > the
    > > program does this for me. Do I have to do it manually???

    >
    > This is an Excel question
     
    Peggy, Jun 30, 2008
    #4
    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.

Share This Page