Explore BrainMass
Share

Explore BrainMass

    Anova - hand calculations in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Chpt 12: Inferences Pairs of Treatment Means Assignment

    The following are six observations collected from treatment 1, ten observations collected from treatment 2, and eight observations collected from treatment 3. Test the hypothesis that the treatment means are equal at the .05 significance level.

    Treatment 1 Treatment 2 Treatment 3
    3 9 6
    2 6 3
    5 5 5
    1 6 5
    3 8 5
    1 5 4
    4 1
    7 5
    6
    4

    a. State the null hypothesis and the alternate hypothesis.
    b. What is the decision rule?
    c. Compute SST, SSE, and SS total.
    d. Complete an ANOVA table.
    e. State your decision regarding the null hypothesis.
    f. If H0 is rejected, can we conclude that treatment 2 and treatment 3 differ? Use the 95% level of confidence.

    © BrainMass Inc. brainmass.com October 10, 2019, 8:25 am ad1c9bdddf
    https://brainmass.com/statistics/data-collection/anova-hand-calculations-excel-624947

    Solution Preview

    The following are six observations collected from treatment 1, ten observations collected from treatment 2, and eight observations collected from treatment 3. Test the hypothesis that the treatment means are equal at the .05 significance level.
    Treatment 1 Treatment 2 Treatment 3
    3 9 6
    2 6 3
    5 5 5
    1 6 5
    3 8 5
    1 5 4
    4 1
    7 5
    6
    4
    Mean 2.5 6.5 4.666666667 Grand Mean 4.541666667

    a. State the null hypothesis and the alternate hypothesis.
    The Null hypothesis is that there is no difference in the ...

    Solution Summary

    The expert shows hand calculations on how to do Anova for three groups.

    $2.19