BUS 310 Midterm 2

By taking and submitting this exam you agree to adhere to the GMU Honor Code and
acknowledge the permitted sanctions outlined in the course syllabus for violations. You are
allowed to ONLY to communicate, by any method, only with the instructor.

Please download the exam Excel file from ExPrep. This file contains all the data required to
complete the assignment. Note that, in general, cells shaded green require inputs, calculations, or
text answers. Make sure all output worksheets are ordered to the right of each problem. Save
your Excel workbook as a .XLSX file. Upload your file to the ExPrep Portal when completed.

If you receive an error notification, that your submission is incorrect, it is best to download
the student file again, and rework and revise. The reason for this requirement, is that
ExPrep grades a submission based on existing worksheet names. So, any missing
worksheet or incorrectly named worksheet will generate errors.

All XLSTAT output is required to placed, using the range selection option, in cell A1 on the
existing worksheet(s) for each specific problem. Please keep all XLSTAT worksheet output
organized to the right of each problem worksheet.

You are allowed one upload submission attempt to the ExPrep submission site.

Each problem answer is required to contain the “4 Parts of a Hypothesis Test”. Place your
answers in the text box on the problem worksheet. You are required to use XLSTAT to answer
the problems. A XLSTAT output worksheet is required for each problem.

Problem 1:
Hotels typically have high employee turnover, especially during COVID-19. The director of
human resources of a large hotel chain has compiled data on randomly selected employees and
recorded their employment tenure. He believes that the employees are staying on the job longer
than 2 years. The hotel chain has a long-term average of 2 years of employment tenure.

Problem 2:
Using the Fillet O Fish drive through service data provided, determine if the chain can claim that
their average service time is less than 150 seconds.

Problem 3:
Using the Car Service Repair Time random sample, determine if a competitor shop can claim
that the average repair time is actually more than 15 days.

Problem 4:
The Sales Data provides information on a sample of customers. An industry trade publication
Problem 3:
Using the Car Service Repair Time random sample, determine if a competitor shop can claim
that the average repair time is actually more than 15 days.

Problem 4:
The Sales Data provides information on a sample of customers. An industry trade publication
claimed that the mean profit per customer for this industry is, surprisingly, more than $4,500.
Does the current data set support the trade publication’s claim?

Problem 5:
An employer is considering negotiating its pricing structure for health insurance with its provider
if there is sufficient evidence that employees would be willing to pay lower premiums for a
higher deductible. Specifically, the employer wants more than 30% of their employees to be
willing to make the change. Using this random sample, determine what decision the employer
should make.

Problem 6:
Determine if there is enough evidence to conclude that the mean number of vacations taken by
Undergraduate Students is less than the number taken by Working Individuals. These
observations are random samples.

Problem 7:
Use the random sample data to test the hypothesis that the number of months employed is less
for applicants with low credit risk than those applicants with high credit risk.

Problem 8:
Using the sample data of Graduate MBA students taking Business Analytics at GMU SBUS, can
you conclude that the class mean Final Exam grade is the different than the mean Midterm
grade?

Problem 9:
Using the random sample of Graduate MBA students from GMU SBUS, is there evidence to
support the claim that the GPAs of male students is lower than the female students?

Problem 10:
Using the random sample of family discretionary budgets from the Fairfax, VA. area, is there
enough evidence to conclude that the males spend less than females?
U Honor Code and
violations. You are
tor.

the data required to

puts, calculations, or
each problem. Save
al when completed.

is best to download
equirement, is that
So, any missing

on, in cell A1 on the

T worksheet output

on site.

s Test”. Place your

XLSTAT to answer

19. The director of

ected employees and
ng on the job longer
ment tenure.

chain can claim that

titor shop can claim

try trade publication

titor shop can claim

try trade publication

y, more than $4,500.

nce with its provider

wer premiums for a
eir employees to be
ecision the employer

f vacations taken by
Individuals. These

ths employed is less

at GMU SBUS, can

the mean Midterm

is there evidence to
udents?

x, VA. area, is there

120827
 Operator
Empoyee ID Length of Service (years) Symbols
1 7.0219 <=
2 4.4247 =>
3 4.0274 >
4 3.5315 <
5 3.4658 ≠
6 3.2932 =
7 3.2712
8 3.1205
9 3.0493
10 3.0219
11 2.9479
12 2.9123
13 2.8767
14 2.5342
15 2.5342
16 2.4740
17 2.2959
18 2.2000
19 2.1589
20 2.1507
21 2.1507
22 2.1479
23 2.1315
24 2.1288
25 2.1233
26 2.1205
27 2.1123
28 2.0740
29 2.0548
30 2.0438
31 1.9479
32 1.9370
33 1.8767
34 1.8411
35 1.7781
36 1.7753
37 1.7507
38 1.7452
39 1.7123
40 1.6986
41 1.6438
42 1.4767
43 1.4603
44 1.4411
45 1.4137
46 1.3096
47 1.2986
48 1.2877
49 1.2575
50 1.2356
51 1.1616
52 1.1616
53 1.0959
54 1.0767
55 1.0466
56 1.0356
57 1.0192
58 0.9945
59 0.9836
60 0.9616
61 0.8658
62 0.8082
63 0.7644
64 0.6329
65 0.6055
66 0.5726
67 0.4877
68 0.3671
69 0.3452
70 0.3205
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
Service Times Operator
(sec.) Symbols
876 <=
714 =>
703 >
698 <
667 ≠
614 =
609
557
518
502
493
475
466
461
450
429
427
426
425
415
406
392
391
384
380
379
376
376
372
371
370
358
357
350
333
329
329
325
323
320
317
317
316
315
315
315
315
314
314
311
305
305
303
302
299
298
296
295
295
292
289
288
282
280
278
277
276
275
273
273
272
272
268
268
268
267
265
265
264
264
262
261
260
255
253
253
253
251
250
250
249
248
248
245
243
243
238
237
236
236
234
233
233
232
231
227
224
223
220
220
219
218
218
216
215
215
212
212
211
209
209
208
207
206
206
205
204
204
203
203
203
202
201
201
200
200
199
199
197
197
197
197
197
195
195
194
193
193
192
191
191
191
190
190
190
189
189
189
187
186
186
185
185
185
183
182
182
182
182
181
180
179
178
176
176
176
175
175
175
174
174
173
172
169
167
167
166
166
166
165
165
165
164
164
163
162
162
160
159
159
158
158
156
156
156
155
155
153
153
152
151
150
149
149
149
148
148
148
148
147
147
147
146
146
145
145
145
145
145
145
145
144
144
144
143
143
143
143
142
142
141
141
141
141
140
140
139
139
139
139
139
139
138
138
138
138
137
137
137
137
137
136
136
135
134
134
134
134
133
133
133
132
132
132
132
132
132
131
131
130
129
128
128
128
128
128
128
128
127
127
125
125
124
124
124
124
124
124
123
123
123
123
123
122
122
121
121
120
119
119
119
118
118
118
118
118
117
117
117
116
116
116
116
116
116
116
115
115
115
115
114
113
112
112
112
112
111
111
111
111
110
110
109
109
108
108
108
107
106
106
106
105
104
104
104
103
103
102
102
100
100
99
99
99
99
98
98
98
98
98
97
97
97
96
96
96
96
95
95
95
94
94
94
93
93
93
93
92
91
91
91
90
89
89
89
89
89
89
89
89
88
88
88
88
88
88
88
88
88
88
87
87
87
87
87
87
87
87
87
86
86
86
86
86
86
85
85
85
85
85
85
85
84
84
84
84
84
84
84
84
84
83
83
83
83
83
83
83
83
83
83
83
83
83
83
83
83
82
82
82
82
82
82
82
82
82
82
82
81
81
81
81
81
81
81
81
81
81
81
80
80
80
80
79
79
79
79
79
79
78
78
78
78
78
78
77
77
77
77
77
76
76
76
76
76
76
75
75
75
75
75
75
75
74
74
74
74
74
74
74
74
73
73
73
73
72
72
72
72
72
72
72
72
72
71
71
71
71
70
70
70
70
70
70
70
70
70
70
70
70
69
69
69
69
69
69
69
69
69
69
69
68
68
68
68
68
68
68
68
68
68
68
68
67
67
67
67
67
67
67
66
66
66
66
66
66
66
66
66
66
66
66
66
66
65
65
65
65
65
65
65
65
65
65
65
65
65
64
64
64
64
64
63
63
63
63
63
63
63
63
62
62
62
62
62
62
62
62
62
62
61
61
61
61
61
61
61
61
61
61
61
60
60
60
60
60
60
60
60
59
58
58
58
57
57
57
56
56
55
55
55
55
55
54
54
54
53
53
53
53
52
52
52
52
51
51
51
51
50
50
49
49
49
48
48
48
47
47
47
47
47
46
46
46
46
46
46
45
45
45
45
44
44
44
44
44
44
43
43
43
43
42
42
41
41
41
40
40
40
40
40
40
39
39
39
38
38
38
38
38
37
37
37
37
36
36
36
35
35
35
35
35
33
33
33
32
31
31
31
31
30
30
30
30
29
29
29
29
29
28
28
28
28
27
26
26
26
25
24
24
24
23
23
23
23
23
23
22
22
21
21
20
20
20
19
19
19
19
19
19
19
18
18
18
17
16
16
16
16
15
15
15
15
15
14
12
11
10
10
9
9
9
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
 Operator
Sample Repair Time (Days) Symbols
1 40 <=
2 39 =>
3 38 >
4 37 <
5 36 ≠
6 36 =
7 34
8 31
9 29
10 29
11 27
12 27
13 26
14 26
15 25
16 25
17 25
18 23
19 23
20 23
21 23
22 22
23 22
24 22
25 22
26 21
27 21
28 21
29 21
30 21
31 20
32 20
33 20
34 20
35 20
36 20
37 20
38 20
39 19
40 19
41 19
42 19
43 19
44 19
45 19
46 19
47 19
48 18
49 18
50 18
51 18
52 18
53 18
54 18
55 18
56 18
57 17
58 17
59 17
60 17
61 17
62 17
63 17
64 17
65 17
66 17
67 17
68 17
69 17
70 17
71 17
72 17
73 17
74 16
75 16
76 16
77 16
78 16
79 16
80 16
81 16
82 16
83 16
84 16
85 16
86 16
87 16
 88 16
89 16
90 16
91 16
92 15
93 15
94 15
95 15
96 15
97 15
98 15
99 15
100 15
101 15
102 15
103 15
104 15
105 15
106 15
107 15
108 15
109 15
110 15
111 15
112 15
113 15
114 15
115 14
116 14
117 14
118 14
119 14
120 14
121 14
122 14
123 14
124 14
125 14
126 14
127 14
128 14
129 14
130 14
131 14
132 14
133 14
134 14
135 13
136 13
137 13
138 13
139 13
140 13
141 13
142 13
143 13
144 13
145 13
146 13
147 13
148 13
149 13
150 13
151 13
152 13
153 13
154 13
155 13
156 13
157 13
158 12
159 12
160 12
161 12
162 12
163 12
164 12
165 12
166 12
167 12
168 12
169 12
170 12
171 12
172 12
173 12
174 12
175 12
176 12
177 12
178 12
179 12
180 12
181 11
182 11
183 11
184 11
185 11
186 11
187 11
188 11
189 11
190 11
191 11
192 11
193 11
194 11
195 11
196 11
197 11
198 11
199 11
200 10
201 10
202 10
203 10
204 10
205 10
206 10
207 10
208 10
209 10
210 10
211 10
212 10
213 10
214 10
215 10
216 10
217 10
218 10
219 9
220 9
221 9
222 9
223 9
224 9
225 9
226 9
227 9
228 9
229 9
230 9
231 9
232 9
233 8
234 8
235 8
236 8
237 8
238 8
239 8
240 8
241 8
242 8
243 8
244 8
245 7
246 7
247 7
248 7
249 7
250 6
251 6
252 5
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
Industry Profit per Operator
Customer Customer Symbols
1 $25,379.34 <=
2 $25,074.14 =>
3 $16,925.55 >
4 $15,079.87 <
5 $12,988.64 ≠
6 $12,243.36 =
7 $12,067.22
8 $11,520.81
9 $11,477.03
10 $9,870.71
11 $7,301.49
12 $7,284.68
13 $6,914.82
14 $6,485.76
15 $6,261.00
16 $5,500.18
17 $5,405.26
18 $5,395.95
19 $5,336.28
20 $4,576.04
21 $3,503.07
22 $3,481.70
23 $3,184.50
24 $2,949.32
25 $2,772.88
26 $2,318.40
27 $2,223.48
28 $2,095.00
29 $1,853.34
30 $1,817.34
31 $1,507.52
32 $1,221.44
33 $1,210.64
34 $1,118.72
35 $998.92
36 $957.12
37 $778.07
38 $723.60
39 $717.23
40 $670.41
41 $604.80
42 $501.12
43 $487.80
44 $461.40
45 $457.92
46 $366.48
47 $313.74
48 $291.04
49 $278.00
50 $276.12
51 $230.60
52 $183.71
53 $139.70
54 $126.70
55 $99.96
56 $99.96
57 $86.70
58 $57.92
59 $54.78
60 $40.60
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
 Operator
Employee # Premium/Deductible** Symbols
36 N <=
55 N =>
61 N >
65 N <
53 N ≠
50 N =
28 N
62 N
48 N
31 N
57 N
44 N
38 N
27 N
56 Y
43 Y
45 Y
42 Y
29 N
28 Y
36 Y
49 N
46 N
52 N
Copy to use the specific symbols to answer question
1 and 2 **Would you be willing to pay a lo
For H0 what operator is used? Count of N
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
ould you be willing to pay a lower premium for a higher deductible?
Count of Y Total
120827
120827
 Student Working
Number of Number of
Vacations per Vacations per Operator
Year Year Symbols
2 0 <=
4 6 =>
2 7 >
4 6 <
2 4 ≠
1 5 =
4 2
1 1
5 2
1 6
2
1
5
2
2
1
2
2
3
2
2
2
1
5
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
 Risk High Risk Low
Months Months Operator
Employed HR Employed LR Symbols
0 12 <=
119 45 =>
14 13 >
9 16 <
4 2 ≠
0 15 =
63 14
4 26
2 8
16 33
5 116
23 15
23 33
58 46
7 24
46 12
1 32
42 2
74 34
33 41
3 40
75 0
8 26
5 60
6 1
114 119
5 5
60 36
10 10
8 28
4 16
0 32
5 46
9 17
69 115
2 31
3 0
17 81
3 28
20 85
59 32
 3 0
25 9
3 6
11 14
79 65
13 14
21 2
13 1
14 93
41 108
22 16
14 88
45 1
89 9
20 21
14 6
15 24
12 15
53 81
0 14
56 9
42 18
21 79
10 94
20 73
87 94
54 23
2 6
20 99
13 7
89 10
17 0
3 3
5 25
7 63
15 78
9 36
8 6
48 19
55 3
1 2
111 37
2 14
1 54
2 14
 11 0
4 2
4 5
3 19
1 24
19 14
0 93
0 96
42 35
4 48
0 85
10 100
20 7
14 36
20 3
4 47
2 12
0 5
13 66
90 4
15 0
6 4
0 108
2 0
35 23
0 19
45 57
24 9
14 21
19 12
58 11
3 41
4 71
2 74
6 29
3 2
4 108
111 8
21 42
17 70
85 35
37 9
1 0
22 83
40 1
 6 3
83 89
0 26
7 38
18 46
49 66
52 75
28 27
31 5
36 4
35 53
61 5
15 21
23 65
14 17
103 0
24 71
15 22
7 118
119 22
29 17
54 11
90 65
28 13
4 34
28 20
81 3
57 13
2 22
119 14
13 0
2 0
33 36
83 62
5 0
18 67
101 12
75 9
42 107
19 24
20 114
30 16
59 111
21 102
10 29
 90 77
32 21
62 31
46 9
73 27
40 14
5 99
2 89
16 2
0 6
7 1
22 95
27 92
65 23
105 9
40 41
109 5
3 47
24 17
21 26
51 93
17 3
92 4
52 37
40 23
13 40
0 23
11 17
3 30
5 69
25 106
5 4
53 24
103 7
6 91
70
51
39
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
 MBA Operator
Student Midterm Final Exam Symbols
1 62 76 <=
2 90 84 =>
3 68 79 >
4 84 88 <
5 58 76 ≠
6 79 66 =
7 73 75
8 93 94
9 65 66
10 86 92
11 53 80
12 83 87
13 49 86
14 72 63
15 87 92
16 89 75
17 81 69
18 94 92
19 78 79
20 71 60
21 84 68
22 74 71
23 74 61
24 54 68
25 97 76
26 79 72
27 89 99
28 53 58
29 78 82
30 82 72
31 69 77
32 98 95
33 93 72
34 80 71
35 82 72
36 96 96
37 61 72
38 84 89
39 97 94
40 89 85
41 72 60
42 93 66
43 84 96
44 87 83
45 99 88
46 97 92
47 92 80
48 93 80
49 78 91
50 82 74
51 99 96
52 72 80
53 79 62
54 75 70
55 90 87
56 95 90
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
MBA GPA for MBA GPA for Operator
Female Male Symbols
2.5 3.0 <=
2.7 2.8 =>
2.8 3.2 >
2.9 3.5 <
3.0 2.9 ≠
3.0 4.0 =
3.2 4.0
3.2 3.3
3.3 3.1
3.4 3.2
3.6 2.9
3.7 3.5
4.0 3.7
4.0 2.6
4.0 3.3
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827
Monthly Budget Monthly Budget Operator
Female Male Symbols
$1,500 $200 <=
$1,400 $700 =>
$1,000 $300 >
$850 $450 <
$840 $400 ≠
$700 $1,000 =
$675 $350
$600 $600
$580 $420
$450 $280
$400 $150
$400 $350
$370 $400
$350 $800
$350 $175
$350 $600
$300 $800
$300 $720
$285 $400
$275 $300
$150 $355
$700
$600
$250
$355
$175
$300
$350
$500
Copy to use the specific symbols to answer question
1 and 2
For H0 what operator is used?
For H1 what operator is used?
What is the P value of the test?
What is the decision? Type Fail To Reject or Reject
120827
120827