Using Excel: Data > Data Analysis > Anova: Single
Factor
Anova: Single Factor |
|
|
|
|
|
|
|
|
|
|
|
|
SUMMARY |
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
Razor |
8 |
81 |
10.125 |
2.410714 |
|
|
Blazer |
8 |
78 |
9.75 |
2.785714 |
|
|
Tracer |
8 |
69 |
8.625 |
0.839286 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit at 0.05 |
Between
Groups |
9.75 |
2 |
4.875 |
2.423 |
0.113017 |
3.4668 |
Within
Groups |
42.25 |
21 |
2.012 |
|
|
|
|
|
|
|
|
|
|
Total |
52 |
23 |
|
|
|
|
a. Null and Alternative hypothesis:
H0:
?Razor = ?Blazer = ?Tracer.
HA: Not all population means are equal.
b-1. ANOVA table.
Source of Variation |
SS |
df |
MS |
F |
P-value |
Between
Groups |
9.75 |
2 |
4.875 |
2.423 |
0.1130 |
Within
Groups |
42.25 |
21 |
2.012 |
|
|
Total |
52 |
23 |
|
|
|
b-2. As p-value = 0.01130 > 0.05, we fail to
reject the null hypothesis.
There
is not enough evidence to conclude that not all population means
are equal.
b-3. As p-value = 0.01130 > 0.10, we fail to
reject the null hypothesis.
There
is not enough evidence to conclude that not all population means
are equal.