a)
excel data analysis tool for one factor anova,steps are: write
data>menu>data>data analysis>anova :one factor>enter
required labels>ok, and following o/p Is obtained,
|
Anova: Single Factor |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUMMARY |
|
|
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
| Critical
Reading |
6 |
3012 |
502 |
4686 |
|
|
|
Mathematics |
6 |
3090 |
515 |
3161.2 |
|
|
|
Writing |
6 |
2964 |
494.00 |
5042.80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
| Source of
Variation |
SS |
df |
MS |
F |
P-value |
F
crit |
| Between
Groups |
1348.00 |
2 |
674.00 |
0.16 |
0.8562 |
3.682 |
| Within
Groups |
64450.00 |
15 |
4296.67 |
|
|
|
|
|
|
|
|
|
|
|
Total |
65798.00 |
17 |
|
|
|
|
Ho: µ1=µ2=µ3
H1: not all means are equal
F stat = 0.16
p value = 0.8562 >α=0.05, do not reject Ho
so, students do not perform differently on the three areas of
the SAT
b)
|
Groups |
|
|
Average |
| Critical
Reading |
|
|
502 |
|
Mathematics |
|
|
515 |
|
Writing |
|
|
494 |
Writing area of the test seems to give the students the most
trouble because its mean score is least
