Ans a ) using excel>data>data analysis >one way
ANOVA
we have
Anova: Single Factor |
|
|
|
|
|
|
|
|
|
|
|
SUMMARY |
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
New |
5 |
45 |
9 |
1 |
|
|
A |
5 |
60 |
12 |
2 |
|
|
B |
5 |
56 |
11.2 |
2.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
Between Groups |
24.13333 |
2 |
12.06667 |
6.961538 |
0.009839 |
3.885294 |
Within Groups |
20.8 |
12 |
1.733333 |
|
|
|
|
|
|
|
|
|
|
Total |
44.93333 |
14 |
|
|
|
|
(a) the test statistic F = 6.96
(ii)the p-value
0.005<p <0.01
Ans 2 )
using excel>data>data analysis >one way ANOVA
we have
Anova: Single Factor |
|
|
|
|
|
|
|
|
|
|
|
SUMMARY |
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
A |
4 |
16 |
4 |
0.666667 |
|
|
B |
4 |
21 |
5.25 |
0.25 |
|
|
C |
5 |
46 |
9.2 |
3.7 |
|
|
D |
3 |
8 |
2.666667 |
1.333333 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
Between Groups |
101.2208 |
3 |
33.74028 |
20.02721 |
5.78E-05 |
3.490295 |
Within Groups |
20.21667 |
12 |
1.684722 |
|
|
|
|
|
|
|
|
|
|
Total |
121.4375 |
15 |
|
|
|
|
(a) the test statistic F = 20.03
(ii)the p-value
0.<p <0.00001