In: Statistics and Probability
Student |
Critical Reading |
Mathematics |
Writing |
1 |
526 |
534 |
530 |
2 |
594 |
590 |
586 |
3 |
465 |
464 |
445 |
4 |
561 |
566 |
553 |
5 |
436 |
478 |
430 |
6 |
430 |
458 |
420 |
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