1. (9+1 for Excel work) The instructor in the previous example teaches the same sections of the course four times a year and wanted to investigate if there was not only a difference in the way assignments were treated but also in the time of year the course was given. The following data was collected. Assume all populations are normally distributed, observations are independent, and population variances are equal. Using EXCEL perform all remaining tests necessary to determine whether the grades were influenced by assignment method and/or semester. Use alpha = 0.05 in all tests. No post tests are required.

1. (9+1 for Excel work) The instructor in the previous example teaches the same sections of
the course four times a year and wanted to investigate if there was not only a difference in
the way assignments were treated but also in the time of year the course was given. The
following data was collected. Assume all populations are normally distributed, observations
are independent, and population variances are equal. Using EXCEL perform all remaining
tests necessary to determine whether the grades were influenced by assignment method
and/or semester. Use alpha = 0.05 in all tests. No post tests are required.
TERM
FALL

WINTER

EARLY SUMMER

LATE SUMMER

No Assignments
69
69
92
84
79
84
76
63
76
82
89
72
72
65
73
47
92
71
83
81
92
80
64
72
84
79
74
81

Assignments, Not Collected
73
63
68
79
57
68
72
74
49
84
79
71
80
74
71
63
88
83
89
82
69
92
79
81
76
81
81
75

Assignments, Collected
83
97
72
79
84
76
91
76
83
88
91
96
68
99
89
80
79
91
83
83
76
90
79
67
86
86
82
84