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 No Assignments Assignments, Not Collected Assignments, Collected FALL 69 73 83 69 63 97 92 68 72 84 79 79 79 57 84 84 68 76 76 72 91 WINTER 63 74 76 76 49 83 82 84 88 89 79 91 72 71 96 72 80 68 65 74 99 EARLY SUMMER 73 71 89 47 63 80 92 88 79 71 83 91 83 89 83 81 82 83 92 69 76 LATE SUMMER 80 92 90 64 79 79 72 81 67 84 76 86 79 81 86 74 81 82 81 75 84

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