Monthly expenditures on alcohol were gathered for 50 Central students and for 50 students from Southwest Baptist University. These figures are given below and are in dollars ($'s). Assuming that the variances for both schools' data are the same, use Excel and the data to test whether the mean alcohol expenditures for UCM students is equal to that of SBU students using a 1 % level of significance. Will your answer change for α = 0.02? Show.
|
UCM Students:
|
|
198
|
295
|
403
|
105
|
214
|
76
|
188
|
295
|
198
|
100
|
|
180
|
10
|
200
|
203
|
410
|
192
|
372
|
394
|
297
|
108
|
|
356
|
103
|
94
|
27
|
404
|
377
|
383
|
387
|
390
|
63
|
|
307
|
207
|
366
|
198
|
105
|
198
|
191
|
293
|
425
|
210
|
|
255
|
393
|
226
|
500
|
320
|
182
|
281
|
12
|
283
|
402
|
|
SBU Students:
|
|
136
|
144
|
0
|
96
|
202
|
2
|
72
|
39
|
392
|
109
|
|
151
|
363
|
72
|
175
|
177
|
357
|
160
|
68
|
7
|
72
|
|
206
|
189
|
98
|
21
|
35
|
262
|
178
|
20
|
10
|
303
|
|
0
|
62
|
105
|
165
|
240
|
182
|
178
|
101
|
306
|
66
|
|
135
|
91
|
25
|
10
|
310
|
281
|
30
|
291
|
397
|
199
|
Finally, an SBU administrator claims that their students spend no more than $150 on average on alcohol (the local city council claims they spend much more!). Is there enough evidence to support either the administrator's or council's claim? (Use a one-tailed test and a 5% level of significance.)