Hypothesis:
Ho : There is a no significant difference with these groups.
V/s
H1 : There is a significant difference with at least one
group.
using Excel Data Analysis tool pack
Excel => Data => Data Analysis => Anova: Single
Factor => select input range => Labels => output range
=> ok
| Alcohol |
Medication |
Placebo |
| 10 |
7 |
5 |
| 15 |
7 |
3 |
| 12 |
5 |
2 |
| 8 |
8 |
4 |
| 5 |
10 |
6 |
| 21 |
13 |
5 |
| 10 |
12 |
1 |
| 11 |
11 |
2 |
| 13 |
11 |
5 |
| 20 |
15 |
2 |
| Anova: Single Factor |
|
|
|
|
|
|
|
|
|
| SUMMARY |
|
|
|
|
| Groups |
Count |
Sum |
Average |
Variance |
| Alcohol |
10 |
125 |
12.5 |
25.16667 |
| Medication |
10 |
99 |
9.9 |
9.655556 |
| Placebo |
10 |
35 |
3.5 |
2.944444 |
| ANOVA |
|
|
|
|
|
|
| Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
| Between Groups |
429.0667 |
2 |
214.5333 |
17.04148 |
1.63E-05 |
3.354131 |
| Within Groups |
339.9 |
27 |
12.58889 |
|
|
|
|
|
|
|
|
|
|
| Total |
768.9667 |
29 |
|
|
|
|
Here p-value = 0.0000163 or 1.63E-05 < alpha =0.05 then we
reject Ho.
Conclusion : with 0.05 level of significance we conclude that
,there is a significant difference with at least one group.
