# Anova - hand calculations in Excel

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.

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.