A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Month
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
B
Machine Hours
1539
1284
1490
1355
1500
1777
1716
1045
1364
1516
1623
1376
1327
1178
1491
1667
1769
1104
1196
1794
1379
1448
1505
1420
1475
1118
1433
1589
1585
1493
1124
1536
1678
1723
1413
1390
C
Production Runs
31
29
27
22
35
30
41
29
47
21
37
37
49
50
37
41
34
44
46
29
38
32
32
42
27
34
58
26
32
33
36
28
41
35
30
54
D
Overhead
99798
87804
93681
82262
106968
107925
117287
76868
106001
88738
105830
88730
100624
98857
102622
108059
110054
91892
98693
110530
96883
99593
94564
105752
93224
75398
113137
85609
98498
101803
88371
102419
117183
107828
88032
117943
E
F
G
H
Dataset for prediction
Month
Machine Hours
Production Runs
37
1430
35
38
1560
45
39
1520
40
I
A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Generic foot size
9.034
13.396
13.932
16.015
11.73
5.062
12.885
9.771
9.14
13.639
14.351
14.435
16.8
17.194
8.433
16.497
7.405
4.682
7.83
14.101
12.095
18.692
21.311
16.149
3.308
17.868
10.889
11.279
14.154
16.985
10.944
15.435
12.346
13.038
10.025
13.84
15.844
7.227
13.801
10.796
16.965
9.283
12.986
15.771
8.225
15.082
13.736
10.896
15.345
11.985
16.916
15.125
10.441
15.022
15.708
10.325
13.802
13.874
8.303
17.509
9.623
15.053
14.001
3.026
11.415
14.396
17.615
15.561
16.459
9.281
17.266
16.7
8.861
13.76
7.724
12.083
12.745
13.638
12.998
10.422
14.252
17.452
10.19
16.069
11.941
12.513
8.156
15.297
13.399
15.63
15.191
15.037
7.333
17.241
12.322
16.5
11.018
10.223
9.178
14.474
B
Left
9.118
13.249
14.169
16.125
11.839
5.4
12.687
9.752
9.023
13.989
14.118
14.346
16.804
17.451
8.606
16.444
7.418
4.647
8.184
14.195
12.007
18.462
21.32
16.04
3.187
17.85
10.989
11.511
14.267
16.382
10.975
15.566
12.076
13.383
10.196
14.353
15.915
6.873
14.106
10.771
16.612
9.356
12.81
15.895
8.295
14.906
13.911
11.233
15.036
12.19
16.945
14.966
10.406
14.931
16.039
10.408
13.724
13.694
8.292
17.453
9.915
15.4
13.806
3.013
11.107
14.234
17.641
15.481
16.88
9.41
17.33
16.484
8.913
13.764
7.437
11.667
12.826
13.532
13.244
10.577
14.062
17.328
10.192
16.263
11.629
12.672
7.916
15.221
13.753
15.778
15.27
15.514
7.644
17.286
12.11
16.339
10.872
10.242
9.066
14.85
C
Right
8.551
13.245
14.049
16.07
11.712
5.048
12.794
9.886
9.234
13.659
14.46
14.477
16.749
17.479
8.32
16.764
7.411
4.549
7.973
14.316
12.139
18.864
21.341
16.063
2.918
17.88
10.614
11.376
14.425
17.078
10.978
15.642
12.365
12.997
9.927
13.614
15.658
6.925
13.983
10.897
16.806
9.313
12.698
15.743
7.932
15.086
13.554
11.269
15.11
11.987
17.112
15.375
10.33
14.721
15.81
10.545
13.605
13.863
8.54
17.408
9.564
15.152
14.251
2.759
11.683
14.301
17.447
15.665
15.948
9.336
17.155
16.528
8.953
13.688
7.9
12.485
12.654
14.089
12.809
10.503
14.377
17.532
10.117
16.124
11.945
12.571
8.091
15.439
13.825
15.617
14.91
14.99
7.832
17.154
12.187
16.49
10.931
9.839
9.76
14.072
D
Height
60.376
78.538
77.023
78.286
65.912
51.539
73.981
69.619
64.502
71.543
73.624
82.811
84.491
82.56
60.108
79.987
50.302
47.43
59.065
82.306
66.17
89.991
105.921
86.64
41.638
89.09
70.824
66.332
75.851
92.242
70.155
85.065
69.445
78.39
69.392
75.273
79.088
62.149
78.04
60.435
82.778
64.042
75.709
76.735
57.638
80.091
73.157
61.151
86.079
69.753
83.604
83.688
66.455
80.7
78.032
59.618
78.331
77.849
52.752
87.533
63.995
78.411
77.371
40.705
65.695
78.778
91.412
83.668
83.123
59.39
86.887
82.372
61.783
73.419
56.096
69.813
72.777
73.27
68.138
63.847
77.522
84.692
65.86
84.431
65.656
71.196
57.472
79.271
73.967
77.627
75.403
77.973
54.057
90.134
71.706
80.119
69.192
66.262
59.217
75.308
Ex.3
Customer
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Age Gender Own Home
73
0
0
22
0
1
51
1
1
48
1
1
57
1
0
29
0
0
33
0
0
55
0
1
62
1
1
37
1
1
63
1
0
31
1
1
34
1
1
45
1
0
53
0
1
49
0
1
55
0
1
49
1
1
43
0
0
23
1
0
27
0
1
69
1
1
42
0
0
71
0
0
30
1
0
43
1
0
24
0
1
32
0
1
76
0
1
38
1
1
32
0
1
41
1
1
38
0
0
29
0
1
53
1
1
47
0
1
28
1
0
22
1
1
36
0
1
68
0
0
26
1
1
65
1
1
56
1
1
Married
0
1
1
1
0
0
0
1
0
1
1
1
0
0
1
1
1
1
0
1
0
0
0
0
0
0
0
1
1
1
0
1
0
0
0
0
1
0
0
1
1
0
1
Page 3
Close
1
0
1
1
1
1
1
0
1
0
1
0
1
0
1
1
1
1
1
1
0
0
1
1
1
0
1
1
1
0
0
1
0
1
0
0
1
1
1
1
1
1
1
Salary
$16,400
$108,100
$97,300
$26,800
$11,200
$42,800
$34,700
$80,000
$60,300
$62,300
$94,200
$73,800
$45,900
$52,600
$82,200
$76,700
$79,400
$66,900
$12,400
$52,600
$28,300
$53,900
$28,900
$15,900
$50,700
$17,800
$51,300
$74,400
$88,200
$79,000
$55,200
$95,800
$13,700
$41,300
$65,400
$29,600
$49,800
$73,700
$39,900
$36,600
$51,200
$59,400
$107,300
Children
1
3
1
0
0
0
0
0
0
0
1
0
2
1
1
2
3
0
1
1
0
0
0
0
3
1
0
0
0
1
0
3
2
1
1
3
0
1
0
0
0
0
2
Ex.3
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
44
32
41
74
27
35
59
51
52
55
28
67
55
60
34
75
43
75
24
74
36
52
53
30
68
37
27
44
58
50
28
41
59
21
53
30
55
40
74
24
56
70
40
69
1
1
1
0
0
0
0
0
1
0
0
1
0
1
1
0
0
0
0
0
1
1
0
0
1
1
1
0
1
0
0
0
0
1
0
0
0
0
0
1
1
0
0
1
1
1
1
0
1
1
0
0
1
0
1
1
1
1
1
1
0
0
1
1
1
0
0
1
1
0
1
1
0
0
0
0
0
1
0
1
0
1
0
0
1
1
1
0
1
1
1
1
1
0
0
0
0
0
1
1
0
0
0
1
1
0
0
0
1
1
1
0
0
1
1
1
1
1
1
0
0
0
1
1
1
1
0
0
1
0
1
0
0
0
0
1
1
1
1
1
1
0
1
0
0
1
1
1
1
1
0
1
1
1
0
1
1
0
0
1
0
1
1
0
0
1
1
1
1
1
1
0
1
1
0
1
Page 4
$90,700
$74,400
$15,400
$60,100
$81,700
$36,100
$47,000
$28,200
$56,700
$12,600
$21,500
$96,800
$22,000
$57,600
$65,300
$63,300
$38,200
$11,000
$24,000
$47,600
$87,000
$117,700
$30,100
$12,800
$63,200
$41,600
$75,500
$74,900
$72,200
$36,500
$73,000
$15,100
$19,800
$64,000
$79,400
$82,000
$63,500
$118,000
$13,300
$45,100
$45,900
$43,900
$110,000
$63,000
3
0
0
0
3
0
0
1
2
0
0
2
0
1
0
2
0
2
1
1
0
1
0
0
0
0
0
0
3
1
1
0
1
3
0
0
1
3
1
1
0
2
0
0
Ex.3
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
47
55
37
29
29
23
37
29
69
27
51
25
35
46
51
57
74
23
27
47
74
35
27
31
43
37
24
25
39
53
63
33
52
42
25
64
59
55
71
56
44
46
66
42
1
0
0
0
1
0
1
1
0
1
0
1
0
0
0
1
0
1
1
0
0
1
1
1
1
1
0
0
0
0
1
1
1
0
0
1
0
0
0
1
1
1
1
1
0
0
0
1
0
0
0
1
1
1
0
0
1
1
1
1
0
0
0
1
0
0
0
1
1
0
0
1
0
1
1
1
1
0
1
1
1
0
1
1
1
1
0
0
0
1
1
0
1
0
0
0
0
1
0
0
1
1
0
1
0
1
0
1
1
1
0
1
0
0
0
0
1
0
1
0
1
0
1
1
1
1
1
1
0
1
0
0
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
1
1
0
1
0
1
1
1
1
1
1
0
0
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
Page 5
$61,800
$53,300
$42,000
$25,900
$20,200
$46,600
$18,700
$45,700
$32,600
$96,100
$14,400
$54,200
$80,600
$48,900
$30,300
$124,900
$13,700
$60,300
$43,100
$128,700
$118,300
$36,500
$13,400
$101,700
$76,800
$21,900
$16,100
$64,100
$95,900
$58,200
$120,000
$68,400
$83,600
$13,400
$54,700
$41,300
$130,700
$39,500
$93,400
$83,100
$55,900
$71,200
$57,800
$59,100
0
0
3
2
1
0
0
0
3
0
1
0
0
3
0
0
1
1
1
0
1
0
0
1
1
0
0
2
0
0
3
0
2
1
0
0
3
0
2
2
1
1
0
2
Ex.3
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
46
24
23
40
55
30
61
40
55
48
23
64
29
35
32
67
47
26
25
54
58
34
26
49
26
32
51
42
44
24
67
43
36
30
76
22
51
26
44
53
22
70
53
33
0
1
0
1
1
0
0
1
1
0
1
1
0
1
1
1
0
0
1
1
1
1
1
0
1
0
1
1
1
0
0
1
0
0
1
1
1
0
0
0
0
1
1
1
0
0
1
0
0
0
0
1
0
0
0
1
1
1
1
1
0
0
0
1
0
0
1
0
1
1
0
1
0
0
1
0
0
0
0
1
0
1
1
0
0
1
0
0
0
0
0
1
0
1
1
0
0
0
0
1
1
0
1
1
0
0
0
1
0
0
1
0
1
1
0
1
0
1
1
1
0
0
0
1
0
0
1
0
1
1
1
0
0
0
0
1
1
0
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
0
1
1
0
1
1
0
1
1
0
1
1
1
Page 6
$23,100
$10,900
$47,500
$76,200
$14,200
$52,500
$43,300
$66,600
$55,100
$10,600
$56,300
$58,900
$102,500
$71,500
$73,300
$69,900
$12,100
$23,000
$39,500
$55,500
$45,600
$19,500
$70,400
$10,200
$83,700
$72,600
$40,500
$63,300
$14,800
$84,800
$85,500
$84,100
$26,600
$42,500
$15,300
$67,600
$15,200
$56,000
$84,800
$10,600
$88,400
$87,200
$106,700
$27,100
2
0
0
1
1
0
3
0
2
2
0
0
3
0
0
1
1
3
1
0
0
0
2
3
0
1
1
2
3
0
2
1
2
0
0
1
0
3
1
2
0
0
2
1
Ex.3
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
27
42
54
33
61
72
28
52
23
23
56
41
47
71
42
24
48
73
64
48
42
68
25
72
55
26
22
60
25
47
73
58
40
63
26
65
30
60
38
43
25
39
31
30
0
0
0
0
0
1
0
0
0
1
0
1
0
0
0
1
0
1
1
1
0
1
1
0
0
0
0
1
0
1
0
1
0
0
0
0
1
0
0
1
1
0
1
0
1
1
1
1
1
0
1
0
0
1
1
1
0
0
0
1
1
1
0
0
1
0
1
0
0
0
1
0
0
1
1
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
1
0
1
0
0
1
1
1
0
0
0
1
1
1
1
0
1
0
1
0
0
1
1
0
0
1
0
0
0
1
1
1
1
0
0
1
1
0
0
1
1
1
1
1
0
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
1
0
1
1
1
0
0
1
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
Page 7
$46,600
$49,100
$35,200
$35,200
$84,100
$25,800
$49,700
$13,200
$14,600
$109,900
$126,300
$100,600
$11,700
$36,400
$22,200
$106,400
$112,800
$95,900
$88,000
$44,500
$43,600
$20,800
$23,400
$46,600
$31,300
$33,200
$70,400
$17,000
$26,200
$108,900
$17,300
$51,900
$33,600
$61,000
$41,600
$54,200
$66,200
$72,200
$39,700
$36,900
$96,100
$11,700
$31,600
$82,800
2
2
0
0
0
0
2
1
3
2
1
3
0
2
2
0
0
0
2
0
0
0
0
0
1
1
0
0
1
0
0
0
0
1
0
1
0
0
3
0
3
0
1
0
Ex.3
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
58
23
50
22
58
54
36
45
66
71
54
47
69
65
43
24
44
62
42
51
27
45
53
32
38
35
56
38
36
67
50
27
43
61
47
43
62
45
28
42
25
35
54
65
0
1
1
0
0
0
0
0
0
1
1
1
0
1
1
1
1
0
1
0
1
1
1
1
1
1
1
0
0
1
1
0
1
0
1
1
0
1
0
1
0
0
0
1
0
0
0
1
0
1
0
1
0
0
1
1
1
1
0
0
1
0
0
0
1
1
1
1
1
1
0
0
1
0
1
0
0
0
1
1
1
0
0
1
0
1
0
1
1
1
1
1
1
1
0
0
1
0
1
1
0
0
1
0
1
1
1
0
1
0
1
1
0
0
0
0
0
1
0
0
0
0
1
1
1
1
0
0
0
1
1
0
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
0
1
1
1
0
1
1
1
1
1
0
1
0
0
1
1
0
1
1
0
1
0
1
Page 8
$40,900
$65,800
$39,700
$79,300
$40,500
$64,100
$42,000
$32,500
$68,600
$60,400
$130,600
$73,100
$23,800
$52,900
$53,600
$55,600
$52,000
$79,500
$64,600
$14,300
$100,000
$48,100
$107,300
$85,600
$62,700
$55,600
$54,700
$46,500
$35,900
$106,100
$49,200
$10,800
$45,200
$20,400
$95,800
$111,400
$49,200
$48,800
$14,000
$82,800
$12,900
$44,100
$72,900
$59,300
1
2
0
0
2
1
3
0
0
1
0
0
0
1
1
0
0
0
2
1
1
2
2
0
2
0
0
1
0
3
3
3
1
0
3
0
0
2
0
0
1
1
0
0
Ex.3
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
53
58
47
61
46
24
25
54
48
47
44
73
29
37
48
35
23
36
25
43
28
22
36
63
26
25
21
24
70
57
65
39
34
50
54
54
74
31
49
45
49
38
26
66
1
1
1
0
0
0
1
1
0
1
0
0
0
1
0
0
1
1
1
0
1
1
0
0
0
0
0
0
1
1
0
1
1
1
0
0
0
1
0
1
0
1
0
1
1
1
1
0
1
1
0
0
1
1
0
0
0
1
1
0
0
0
0
1
0
0
0
0
0
1
0
0
0
1
1
1
1
1
0
0
0
1
1
1
0
1
0
1
0
0
0
0
0
0
1
1
0
0
1
0
0
0
1
0
1
0
0
0
0
0
0
1
1
0
0
0
1
1
0
0
1
1
1
0
1
1
1
1
0
1
1
0
1
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
0
1
1
0
0
1
0
1
1
1
1
1
1
1
1
1
1
0
0
1
0
0
1
1
0
1
1
Page 9
$59,700
$40,200
$62,800
$22,600
$54,400
$33,400
$63,300
$87,400
$27,000
$65,300
$104,900
$20,100
$14,600
$48,100
$107,600
$58,600
$80,700
$40,200
$25,000
$46,600
$21,900
$13,900
$25,700
$72,200
$76,400
$20,300
$11,400
$17,000
$60,000
$107,400
$37,300
$68,900
$83,000
$97,400
$92,400
$44,800
$50,500
$65,400
$83,100
$117,500
$43,300
$103,900
$41,700
$44,800
1
2
3
0
3
1
3
2
2
3
3
0
1
0
2
1
3
0
0
3
2
0
2
0
0
1
2
0
0
0
0
2
2
1
1
1
0
3
1
2
3
1
1
0
Ex.3
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
52
54
75
29
62
45
25
34
50
72
36
71
29
58
24
49
21
28
43
21
25
41
55
27
54
27
71
37
49
30
52
36
34
45
21
25
39
37
42
51
57
43
37
42
1
0
0
1
1
0
1
0
1
1
1
0
0
1
1
1
0
1
1
1
0
1
1
1
1
0
0
1
1
1
1
1
0
0
0
0
1
1
0
1
0
1
1
1
1
0
0
0
1
0
0
1
1
0
1
1
0
1
0
1
0
1
0
0
0
1
1
0
0
0
1
0
1
1
1
0
1
1
0
0
1
1
1
1
1
0
1
0
0
0
1
0
1
0
1
0
1
0
0
1
0
1
1
0
0
1
0
0
1
1
0
0
0
0
1
0
1
0
0
1
1
0
0
1
1
0
1
1
0
0
1
1
Page 10
0
1
1
0
1
1
1
0
1
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
0
1
0
0
1
1
1
1
1
1
1
0
1
1
1
0
1
0
1
0
$45,000
$43,700
$23,600
$20,400
$123,000
$44,600
$55,500
$56,200
$96,300
$32,400
$60,200
$72,900
$19,300
$74,800
$34,300
$75,400
$11,400
$30,400
$41,200
$21,400
$60,600
$105,300
$63,700
$15,800
$56,900
$15,900
$37,500
$42,500
$97,500
$29,600
$55,600
$74,600
$68,500
$51,900
$17,200
$51,900
$70,200
$61,500
$70,900
$72,500
$33,200
$58,600
$54,700
$64,000
1
0
1
0
0
0
3
0
2
1
0
0
1
0
3
0
3
0
0
0
3
1
0
2
0
0
0
1
0
3
0
2
2
2
1
0
0
2
1
0
0
2
0
1
Ex.3
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
30
51
24
25
56
41
44
47
42
33
23
37
60
62
50
53
32
46
29
29
35
37
23
58
27
53
28
65
33
22
67
33
22
42
24
21
38
51
29
24
43
49
38
47
0
1
1
1
0
0
0
1
1
1
0
0
1
1
1
1
1
1
0
1
1
1
0
0
0
1
1
0
1
1
1
1
1
1
1
1
1
1
0
0
1
1
0
1
0
1
0
0
1
1
1
0
1
1
0
1
1
0
1
0
0
1
0
0
1
1
0
1
0
1
1
1
1
0
1
1
0
0
0
0
1
1
0
0
1
0
1
1
0
1
0
1
1
1
0
1
0
1
0
0
1
1
1
0
1
1
0
1
1
1
0
1
0
0
0
1
0
0
1
1
1
0
0
0
1
1
0
0
1
0
0
1
Page 11
0
1
1
1
1
1
0
0
0
0
1
1
0
0
1
0
1
0
1
1
1
1
0
1
0
1
1
1
1
1
1
1
0
0
1
1
1
0
0
1
1
0
1
0
$12,500
$122,700
$23,200
$41,600
$69,400
$109,800
$66,800
$87,100
$80,800
$122,100
$19,400
$43,300
$33,000
$66,300
$96,300
$55,800
$63,500
$82,400
$14,200
$41,500
$82,500
$85,600
$18,400
$62,600
$13,800
$60,300
$31,500
$111,500
$67,900
$29,200
$84,500
$84,700
$67,300
$51,100
$23,500
$21,300
$90,100
$84,300
$13,200
$22,100
$53,700
$38,700
$35,200
$113,300
1
1
1
3
0
1
3
2
2
0
1
1
0
0
1
1
2
2
0
0
0
1
1
0
3
0
3
0
0
0
0
3
3
0
0
1
0
2
0
2
1
1
2
1
Ex.3
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
37
70
32
26
21
38
35
44
35
46
39
44
47
45
28
34
41
44
67
50
23
22
69
48
39
65
72
55
50
40
62
62
38
40
21
36
40
27
35
59
43
38
62
35
1
0
0
0
0
0
1
1
0
1
1
1
0
0
1
1
1
1
1
1
0
0
0
0
1
0
1
0
1
0
1
0
0
1
0
1
1
0
0
0
0
1
0
1
0
1
1
0
0
1
1
0
1
1
1
1
1
0
1
1
1
0
1
1
1
0
1
1
1
1
1
0
0
1
1
1
1
1
0
0
1
0
0
1
1
1
1
0
1
1
0
0
0
0
1
0
1
0
1
0
0
0
0
1
0
0
0
0
0
0
0
1
1
1
1
1
0
0
0
1
0
1
0
1
1
0
1
1
1
1
1
1
Page 12
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
0
0
0
0
1
0
0
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
0
0
$105,600
$74,700
$60,200
$12,000
$16,700
$46,100
$103,700
$63,800
$65,400
$49,900
$64,300
$59,600
$45,100
$39,900
$33,400
$99,600
$58,400
$35,100
$53,400
$61,600
$21,400
$20,000
$32,700
$99,200
$109,600
$22,800
$76,900
$97,400
$43,700
$49,600
$71,300
$10,100
$35,800
$113,400
$23,200
$88,500
$96,900
$22,000
$81,400
$114,800
$79,900
$107,400
$78,800
$124,800
3
0
1
0
2
2
1
1
2
1
2
2
1
1
0
1
0
1
1
0
3
3
0
0
1
0
2
3
0
1
0
1
1
3
2
2
1
1
2
0
3
1
0
3
Ex.3
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
27
23
51
28
41
60
68
64
37
43
28
24
40
34
34
47
29
32
45
75
28
36
67
29
45
44
41
28
28
58
29
21
22
32
38
27
47
32
21
61
49
63
30
23
0
0
0
1
1
0
0
1
0
0
0
0
1
1
1
1
0
1
0
1
0
1
0
0
0
1
0
1
0
1
1
1
1
0
1
0
1
1
0
0
1
1
0
1
0
0
1
1
1
1
1
1
0
0
0
0
0
1
0
0
0
0
0
1
0
0
0
0
0
1
0
0
0
1
1
0
0
0
1
0
1
1
0
0
1
1
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
1
0
0
0
1
1
1
0
0
1
0
0
1
1
0
0
1
1
1
0
1
1
0
1
1
1
0
1
0
0
0
Page 13
1
0
1
1
0
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
$36,900
$12,800
$65,800
$20,900
$49,700
$25,500
$20,600
$84,300
$31,200
$50,500
$15,500
$12,900
$52,400
$97,600
$50,500
$55,900
$28,900
$108,300
$46,700
$102,700
$15,600
$39,000
$60,200
$17,300
$36,900
$64,800
$67,300
$15,400
$22,600
$54,600
$62,200
$56,300
$21,000
$66,900
$66,500
$13,600
$54,200
$102,400
$42,300
$14,900
$123,800
$58,700
$15,000
$14,100
1
1
1
0
0
0
0
0
3
1
1
1
0
2
0
1
0
2
0
0
0
0
0
0
1
2
1
0
3
0
0
0
0
2
3
1
1
1
0
0
2
0
2
0
Ex.3
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
29
55
62
43
38
53
72
51
28
73
45
42
46
35
27
41
49
28
29
69
22
49
24
31
30
48
33
74
49
31
23
53
29
68
63
29
24
45
51
42
72
44
68
33
0
1
0
1
1
0
0
1
0
1
1
1
0
1
1
1
1
1
1
0
1
0
0
1
1
1
0
1
1
0
1
1
0
0
1
0
0
0
1
0
0
1
0
0
0
1
0
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
0
1
0
1
1
0
0
1
0
0
0
1
0
1
0
1
1
0
0
0
1
0
0
0
1
1
0
1
1
0
1
1
0
1
0
1
1
1
1
1
1
1
0
1
1
1
0
1
1
0
0
1
0
0
0
1
1
1
1
1
1
0
1
0
1
1
1
1
0
1
Page 14
0
0
1
1
1
1
0
1
0
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
1
0
1
1
0
1
1
1
1
0
1
0
1
1
1
0
0
1
1
$17,300
$77,800
$65,900
$73,200
$88,100
$51,900
$47,500
$74,500
$27,900
$58,300
$81,200
$104,100
$87,200
$76,400
$64,300
$119,800
$56,300
$67,800
$66,700
$91,800
$17,700
$97,900
$76,200
$47,200
$21,700
$82,400
$35,600
$42,800
$72,000
$90,400
$37,200
$77,000
$71,200
$61,000
$37,000
$25,300
$53,700
$48,100
$96,300
$75,200
$81,500
$83,500
$30,900
$75,600
1
1
0
0
2
3
0
0
0
0
0
0
0
2
3
2
3
0
0
0
1
0
0
0
1
0
3
0
0
1
1
0
3
0
0
3
0
0
1
1
0
2
0
0
Ex.3
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
29
72
49
32
56
42
73
39
42
24
46
47
30
40
40
26
28
69
23
26
73
38
69
44
39
75
58
34
58
23
53
28
53
65
49
28
21
33
35
56
43
50
27
39
1
0
0
0
1
0
0
1
1
0
1
0
0
0
1
0
0
0
0
1
0
0
0
0
1
0
0
1
0
0
1
0
1
0
1
1
0
0
0
1
1
1
0
0
0
0
1
0
0
1
1
1
0
0
0
0
1
1
0
0
0
1
1
0
1
1
1
0
0
1
0
1
1
0
1
0
1
1
0
0
0
1
0
0
1
1
1
1
1
1
1
0
0
1
1
1
1
0
0
1
1
0
0
0
0
1
0
1
0
0
0
0
1
1
0
1
1
0
1
1
0
1
1
0
1
0
1
1
1
1
0
1
Page 15
0
1
1
1
1
0
0
1
1
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
0
0
1
0
1
1
1
1
0
1
1
1
1
0
1
$25,100
$41,700
$35,300
$35,300
$44,400
$44,200
$57,900
$97,100
$96,400
$23,100
$67,700
$53,900
$42,400
$52,700
$47,000
$14,800
$12,700
$96,200
$15,100
$43,700
$43,300
$36,700
$28,500
$32,100
$92,900
$40,100
$21,400
$72,200
$67,900
$21,100
$93,000
$40,900
$61,300
$110,700
$81,800
$19,100
$73,600
$62,500
$48,600
$69,800
$90,300
$74,500
$32,000
$68,200
0
0
0
0
0
0
0
0
1
2
0
1
1
2
1
1
3
0
0
1
0
1
0
2
1
0
0
0
0
1
3
2
2
0
1
0
1
3
0
0
0
2
1
1
Ex.3
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
30
31
41
30
21
39
44
54
22
74
27
36
46
46
22
50
34
52
74
25
30
22
32
40
39
50
59
47
43
25
47
30
61
27
42
68
33
55
26
67
60
68
70
29
0
0
0
0
0
0
1
1
1
1
0
0
1
0
0
1
0
1
1
1
0
1
0
0
1
0
0
1
0
0
1
1
0
1
0
1
0
1
1
1
0
1
0
0
1
0
0
0
0
0
0
1
0
1
0
1
1
1
0
1
1
1
1
0
0
0
0
1
1
0
1
1
0
1
1
0
0
0
1
0
1
1
0
1
1
1
1
0
0
0
1
0
0
1
1
1
0
1
0
1
0
1
0
1
1
0
1
0
0
1
1
1
1
0
1
1
0
1
0
1
0
0
0
0
1
1
1
0
1
1
1
0
Page 16
1
0
1
0
0
1
1
0
0
0
1
0
0
1
1
0
1
1
1
1
0
0
0
1
1
1
1
1
0
0
0
0
0
1
1
1
1
0
1
1
1
1
0
1
$21,600
$38,200
$91,000
$12,000
$18,200
$72,100
$38,400
$79,700
$17,700
$112,900
$17,800
$52,300
$60,200
$80,800
$21,900
$102,700
$90,500
$44,600
$85,300
$13,000
$32,400
$46,300
$120,800
$92,300
$102,300
$41,400
$22,400
$102,700
$44,100
$33,700
$39,100
$41,500
$17,900
$14,600
$46,300
$34,500
$76,600
$100,100
$49,300
$63,200
$42,800
$106,600
$74,900
$19,100
2
0
2
0
2
0
2
1
0
0
1
1
0
1
1
1
1
2
0
3
1
1
1
3
0
3
0
3
1
0
1
3
0
3
3
0
3
1
0
0
0
0
0
1
Ex.3
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
47
37
64
42
25
43
75
33
60
51
32
57
24
41
43
39
72
21
36
29
26
67
55
44
27
29
51
43
49
37
23
50
30
35
70
33
27
59
26
55
43
49
68
30
1
0
1
0
0
1
0
1
0
0
1
0
0
1
0
1
0
1
0
1
0
0
0
0
1
1
0
0
0
1
0
0
1
0
0
1
1
1
0
0
1
0
0
0
1
1
1
1
0
1
1
1
1
1
0
1
1
1
1
0
1
0
1
0
0
1
0
1
0
0
1
1
0
0
1
0
0
1
1
1
0
1
0
1
0
0
1
0
0
1
1
1
0
1
0
1
1
1
1
1
0
1
0
0
1
0
1
0
0
0
0
1
0
0
1
0
1
1
0
1
0
1
1
1
1
1
0
1
0
0
1
0
Page 17
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
0
1
0
1
1
1
1
0
0
1
0
1
1
0
1
1
1
1
0
1
1
1
$48,800
$105,300
$90,600
$105,500
$17,900
$99,300
$17,600
$76,700
$65,900
$63,700
$93,000
$33,600
$27,500
$84,100
$48,700
$45,900
$70,700
$13,800
$100,800
$25,700
$27,000
$51,900
$37,800
$74,700
$14,800
$17,400
$59,900
$67,800
$135,700
$63,000
$21,900
$114,100
$22,900
$82,700
$103,300
$113,800
$54,500
$54,600
$18,900
$83,300
$60,200
$53,700
$89,000
$12,500
1
1
0
1
3
1
0
1
0
3
1
2
3
3
2
0
0
1
1
0
1
0
2
1
1
0
1
1
1
0
2
1
1
1
0
0
1
0
1
1
0
2
0
3
Ex.3
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
46
32
49
55
32
56
60
26
72
55
31
35
27
44
58
34
50
29
23
64
23
51
49
49
28
72
26
47
50
33
27
46
30
49
71
46
22
47
37
36
52
68
56
29
1
0
1
0
0
1
1
0
0
0
1
0
0
1
1
1
1
0
0
0
1
1
0
1
0
1
0
0
0
1
0
0
0
1
0
1
1
0
1
1
1
0
0
1
1
1
0
1
1
1
0
0
1
1
1
0
0
0
0
0
0
0
0
1
0
1
1
1
0
1
0
1
0
1
1
1
0
1
1
1
1
1
0
1
0
0
1
1
0
1
1
0
0
1
0
0
1
1
1
0
1
0
1
0
1
0
0
1
0
1
1
1
0
1
0
1
0
1
0
0
1
1
0
0
0
0
0
1
0
1
1
0
Page 18
1
1
1
0
1
0
1
0
0
0
0
1
1
1
0
1
1
1
1
1
1
0
0
0
1
0
1
1
1
1
1
1
1
0
1
1
1
0
1
1
0
1
1
0
$50,600
$67,900
$62,800
$34,600
$43,500
$80,700
$29,000
$27,600
$12,600
$88,600
$61,400
$40,200
$69,700
$53,300
$66,200
$54,400
$68,700
$25,100
$20,300
$118,800
$17,600
$88,700
$84,900
$89,500
$11,900
$65,500
$17,600
$82,400
$40,400
$70,000
$44,700
$47,900
$63,200
$86,100
$14,600
$62,900
$23,200
$52,600
$53,900
$100,100
$50,000
$97,000
$35,000
$39,600
3
3
3
2
1
0
0
1
2
1
1
1
2
0
0
0
0
1
2
0
0
2
1
0
1
0
2
2
1
0
1
1
0
1
0
0
0
2
1
2
1
0
0
0
Ex.3
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
69
74
34
51
29
26
45
21
23
43
31
41
31
65
29
21
51
28
47
21
74
40
21
23
24
38
26
52
29
62
24
26
55
68
59
42
21
36
45
49
26
34
32
32
0
1
1
0
0
0
1
1
1
1
0
0
1
0
0
0
1
0
1
1
0
1
0
0
1
1
1
1
0
1
0
1
0
1
0
0
1
0
1
1
0
1
0
1
0
0
1
0
0
0
0
0
0
1
1
0
1
1
0
0
0
1
0
0
1
1
1
1
0
1
0
0
0
1
1
0
0
1
1
0
0
1
1
1
0
0
0
1
1
1
1
1
0
0
0
0
1
0
1
0
1
1
0
0
1
0
1
0
0
1
0
0
0
0
1
0
1
0
1
0
1
1
0
0
0
1
1
0
0
1
0
1
Page 19
1
1
1
0
1
0
1
1
0
1
1
1
0
0
1
1
1
0
0
1
0
1
1
1
1
1
1
0
1
0
0
1
0
1
0
0
1
1
1
0
1
1
0
1
$46,900
$81,800
$99,200
$75,800
$14,500
$19,700
$43,200
$14,400
$43,500
$55,500
$108,100
$33,200
$98,900
$81,400
$20,100
$12,000
$79,500
$27,900
$70,500
$21,200
$42,600
$118,500
$15,600
$27,200
$26,100
$55,900
$27,400
$59,000
$37,100
$62,000
$68,000
$15,000
$45,400
$56,600
$16,300
$45,600
$14,200
$72,200
$126,500
$70,200
$13,500
$118,800
$39,000
$140,700
0
0
3
1
1
2
0
0
1
3
1
1
0
0
1
0
0
1
1
0
0
1
1
2
1
0
1
0
2
0
0
3
3
0
0
0
0
2
2
0
0
0
3
3
Ex.3
748
749
750
21
58
72
1
0
0
0
0
1
1
1
1
Page 20
0
1
1
$51,600
$39,700
$90,500
0
0
0
Ex.3
Previous Customer
1
1
0
1
0
1
0
1
0
1
1
1
1
0
0
1
1
1
0
1
1
0
1
0
1
0
1
1
0
1
1
1
0
0
1
0
1
1
0
1
1
1
1
Previous Spent
$246
$1,622
$0
$536
$0
$856
$0
$2,400
$0
$1,869
$1,413
$2,214
$459
$0
$0
$767
$397
$1,338
$0
$789
$849
$0
$578
$0
$254
$0
$1,026
$1,488
$0
$1,975
$1,656
$479
$0
$0
$1,635
$0
$996
$1,106
$0
$732
$1,024
$1,188
$1,073
Catalogs
12
18
12
12
6
12
18
6
24
24
18
24
12
18
12
6
6
12
12
12
24
12
12
18
6
18
24
18
24
18
18
12
24
18
12
12
12
12
6
6
12
18
18
Amount Spent
$218
$2,632
$3,048
$435
$106
$759
$1,615
$1,985
$2,091
$2,644
$1,211
$3,120
$416
$1,773
$1,517
$534
$200
$1,220
$229
$1,052
$933
$1,186
$830
$406
$157
$589
$1,424
$2,479
$2,749
$2,279
$1,714
$678
$414
$932
$2,290
$774
$827
$1,274
$619
$833
$1,293
$1,699
$1,566
Page 21
Ex.3
1
1
1
0
1
1
0
1
1
1
1
1
1
0
1
1
1
0
1
1
1
1
1
0
1
1
0
1
1
0
1
1
1
1
0
1
1
1
0
1
1
1
1
1
$1,361
$2,232
$462
$0
$409
$722
$0
$423
$567
$378
$430
$1,936
$660
$0
$1,306
$633
$764
$0
$600
$714
$1,740
$1,766
$903
$0
$1,264
$1,248
$0
$1,498
$1,083
$0
$1,095
$453
$495
$320
$0
$1,640
$953
$590
$0
$1,128
$918
$439
$3,300
$1,260
24
6
6
18
24
12
6
6
18
6
18
18
12
6
18
24
6
18
6
12
24
12
12
12
24
24
18
12
18
18
6
6
24
12
6
18
18
12
6
12
24
6
24
24
Page 22
$2,265
$1,893
$297
$1,594
$879
$438
$963
$224
$536
$241
$445
$2,299
$736
$1,006
$1,443
$679
$526
$393
$357
$801
$1,594
$2,104
$530
$230
$1,932
$1,690
$2,450
$1,474
$1,811
$747
$490
$348
$991
$410
$1,175
$1,800
$1,023
$581
$236
$794
$1,645
$358
$5,564
$1,910
Ex.3
1
1
1
0
1
0
1
1
1
1
1
0
1
0
1
1
0
0
0
1
0
1
1
0
1
1
0
1
0
1
1
1
1
1
1
1
0
1
0
1
0
1
1
1
$1,236
$1,066
$210
$0
$505
$0
$374
$914
$163
$1,922
$360
$0
$2,418
$0
$606
$2,498
$0
$0
$0
$3,861
$0
$730
$268
$0
$1,152
$438
$0
$1,282
$0
$1,164
$1,800
$1,368
$836
$201
$1,094
$1,239
$0
$790
$0
$831
$0
$1,068
$1,156
$591
24
24
6
12
24
12
12
18
12
6
6
18
24
18
18
18
6
6
12
24
18
24
18
6
18
12
6
24
24
18
18
18
6
12
24
24
6
12
24
6
24
12
24
18
Page 23
$1,156
$1,598
$105
$449
$500
$546
$289
$724
$172
$1,588
$390
$1,405
$2,840
$915
$1,062
$4,109
$163
$1,252
$1,224
$3,995
$2,681
$1,140
$424
$941
$1,061
$276
$202
$1,595
$3,168
$981
$1,926
$1,155
$538
$143
$1,404
$1,985
$2,070
$1,006
$3,079
$586
$2,555
$638
$1,149
$580
Ex.3
1
1
1
0
0
1
1
1
0
1
1
0
1
0
0
0
1
1
0
1
1
0
0
0
1
0
0
0
0
1
1
1
1
1
1
1
0
1
0
0
1
1
1
1
$462
$327
$1,425
$0
$0
$1,575
$650
$1,332
$0
$106
$1,126
$0
$513
$0
$0
$0
$182
$115
$0
$1,110
$912
$0
$0
$0
$1,674
$0
$0
$0
$0
$1,696
$855
$2,103
$266
$850
$459
$1,014
$0
$840
$0
$0
$2,652
$1,744
$1,067
$407
6
24
6
24
24
24
24
18
6
12
6
18
12
6
12
18
6
6
6
18
18
24
12
6
24
18
18
6
12
18
18
24
24
24
24
18
12
6
12
24
18
18
6
12
Page 24
$466
$407
$847
$2,437
$400
$2,038
$716
$1,177
$826
$114
$873
$1,215
$548
$964
$1,694
$2,101
$90
$79
$412
$858
$1,388
$571
$1,127
$199
$3,344
$1,999
$1,073
$633
$436
$2,624
$895
$2,362
$245
$918
$645
$1,172
$324
$530
$1,826
$517
$3,632
$1,274
$607
$268
Ex.3
0
1
1
0
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
1
1
0
1
0
1
1
1
1
1
0
0
1
1
0
1
1
1
1
0
1
$0
$491
$704
$0
$2,523
$0
$497
$198
$73
$1,099
$1,895
$1,509
$351
$364
$222
$0
$2,256
$1,918
$880
$890
$872
$0
$468
$932
$470
$0
$2,112
$0
$393
$2,178
$346
$1,557
$672
$0
$0
$813
$1,986
$0
$199
$738
$481
$234
$0
$1,656
18
6
12
12
18
6
18
12
6
12
6
24
18
18
18
12
12
24
6
24
12
6
6
24
6
24
18
18
12
12
6
18
12
18
18
6
24
18
12
18
12
12
12
24
Page 25
$1,153
$474
$607
$827
$2,710
$451
$613
$227
$47
$870
$1,888
$2,838
$540
$506
$275
$1,757
$1,861
$2,585
$524
$1,175
$1,047
$260
$348
$906
$357
$1,639
$2,610
$581
$381
$1,841
$166
$1,492
$573
$1,611
$982
$486
$2,057
$3,278
$238
$721
$316
$193
$476
$3,010
Ex.3
1
1
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
0
0
1
1
1
1
1
1
1
1
0
1
1
1
1
0
0
1
1
0
1
0
1
1
1
1
$614
$658
$794
$0
$405
$962
$210
$650
$1,372
$906
$3,918
$1,462
$476
$0
$804
$1,112
$1,560
$1,590
$0
$0
$1,500
$962
$1,073
$1,712
$627
$1,668
$1,094
$698
$0
$531
$246
$23
$633
$0
$0
$2,019
$1,064
$0
$353
$0
$602
$884
$1,962
$1,416
18
18
18
12
18
18
18
24
18
6
18
6
6
24
24
6
18
12
24
18
24
18
24
24
12
18
24
24
12
12
12
6
18
24
12
12
12
12
12
6
6
24
18
12
Page 26
$962
$578
$1,011
$2,047
$622
$1,332
$232
$883
$1,342
$791
$3,442
$1,582
$438
$2,316
$973
$984
$2,545
$1,651
$2,935
$458
$2,247
$961
$1,194
$3,380
$704
$1,786
$1,355
$829
$962
$472
$210
$123
$699
$513
$2,581
$2,136
$1,078
$1,647
$229
$1,544
$167
$704
$2,075
$929
Ex.3
0
0
0
0
1
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
0
0
1
1
0
1
0
1
1
1
1
0
1
1
0
1
1
0
0
1
1
1
0
1
$0
$0
$0
$0
$340
$0
$0
$0
$94
$619
$975
$501
$166
$1,057
$1,773
$801
$438
$1,533
$726
$14
$0
$0
$318
$2,326
$0
$131
$0
$374
$1,163
$1,877
$720
$0
$1,153
$1,442
$0
$1,251
$1,013
$0
$0
$1,796
$117
$2,576
$0
$904
18
18
6
12
18
6
6
18
6
6
6
24
6
18
12
6
6
18
6
6
6
24
6
24
12
12
6
18
6
12
6
18
6
6
6
6
12
6
12
12
24
24
6
24
Page 27
$1,422
$1,197
$707
$865
$342
$617
$1,408
$2,729
$183
$193
$450
$576
$143
$1,640
$1,512
$624
$202
$1,634
$264
$158
$192
$570
$173
$3,069
$2,216
$304
$186
$659
$966
$1,485
$673
$2,784
$726
$880
$2,191
$666
$642
$836
$2,766
$927
$326
$2,666
$521
$1,417
Ex.3
0
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
0
1
0
0
1
1
1
1
0
1
0
0
1
0
0
0
0
0
1
1
0
1
0
1
0
$0
$1,069
$258
$886
$2,428
$1,165
$123
$1,715
$0
$169
$1,335
$1,828
$57
$1,573
$0
$2,121
$0
$606
$951
$0
$275
$0
$0
$115
$1,327
$568
$1,784
$0
$1,295
$0
$0
$846
$0
$0
$0
$0
$0
$794
$898
$0
$1,029
$0
$1,022
$0
18
12
6
18
24
18
12
18
18
12
12
6
24
18
12
24
12
6
12
12
12
18
6
12
24
18
18
6
18
12
12
18
12
12
12
6
6
24
12
24
24
6
18
6
Page 28
$902
$950
$161
$867
$3,671
$966
$216
$1,546
$3,916
$515
$1,365
$753
$308
$1,968
$1,297
$2,723
$312
$495
$841
$414
$307
$3,505
$1,351
$147
$1,857
$503
$1,578
$798
$2,837
$583
$952
$705
$1,500
$1,162
$329
$780
$1,583
$968
$794
$2,595
$1,037
$989
$848
$1,552
Ex.3
0
0
1
0
1
1
0
1
1
1
0
0
1
0
1
0
0
1
0
0
1
1
1
1
1
1
1
1
1
1
0
0
0
1
1
0
1
1
0
1
0
1
1
1
$0
$0
$306
$0
$1,624
$1,880
$0
$1,609
$1,201
$2,963
$0
$0
$1,345
$0
$1,603
$0
$0
$1,352
$0
$0
$1,673
$935
$930
$1,395
$330
$928
$105
$2,410
$1,347
$461
$0
$0
$0
$1,767
$461
$0
$1,755
$1,607
$0
$168
$0
$1,129
$57
$1,930
12
18
24
24
18
24
24
18
18
12
18
18
12
18
24
6
24
24
6
24
6
18
6
6
6
24
18
18
18
18
12
24
6
24
12
12
18
18
18
18
12
18
6
18
Page 29
$422
$4,984
$504
$1,634
$2,419
$2,258
$2,098
$1,688
$2,444
$2,408
$384
$1,021
$979
$2,243
$1,909
$821
$2,321
$2,035
$192
$1,213
$859
$2,436
$319
$565
$127
$1,263
$269
$2,510
$1,418
$737
$1,557
$2,705
$1,212
$1,984
$371
$329
$1,956
$1,648
$512
$280
$1,081
$1,009
$233
$5,151
Ex.3
1
1
0
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
0
0
1
1
1
1
0
1
1
0
1
1
1
0
1
0
1
1
1
0
1
1
1
1
1
$1,046
$1,782
$0
$313
$85
$408
$2,324
$1,311
$632
$0
$655
$1,239
$741
$380
$0
$1,882
$1,004
$466
$747
$0
$0
$35
$1,027
$2,247
$1,591
$0
$1,571
$1,307
$0
$879
$1,518
$58
$0
$1,551
$0
$1,059
$1,718
$285
$0
$2,763
$234
$1,697
$2,586
$1,634
6
12
12
24
12
12
24
24
24
24
6
18
12
12
12
6
12
6
12
18
6
6
24
24
12
12
24
6
18
12
18
6
24
18
24
24
12
12
6
18
12
24
18
18
Page 30
$304
$1,699
$1,748
$344
$108
$418
$2,339
$1,622
$938
$1,631
$661
$1,217
$448
$586
$567
$871
$829
$421
$886
$1,666
$326
$182
$1,252
$5,503
$2,318
$452
$3,230
$213
$1,344
$844
$1,543
$93
$1,355
$1,790
$788
$1,104
$1,420
$472
$1,014
$3,596
$295
$1,821
$3,398
$2,537
Ex.3
0
0
1
1
1
1
1
1
0
1
1
1
0
1
1
1
1
0
1
0
0
0
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
0
0
0
0
0
1
$0
$0
$1,369
$225
$1,880
$696
$309
$1,700
$0
$509
$269
$90
$0
$1,585
$946
$1,123
$976
$0
$927
$0
$0
$0
$1,893
$442
$452
$714
$2,146
$185
$0
$1,584
$1,281
$0
$929
$766
$383
$48
$794
$1,769
$0
$0
$0
$0
$0
$250
18
24
12
24
24
18
6
24
24
12
6
6
18
12
12
12
24
12
24
18
12
6
18
12
6
12
18
6
6
24
24
24
24
12
12
6
6
18
6
12
18
24
12
12
Page 31
$1,480
$365
$869
$550
$2,844
$636
$201
$2,842
$1,087
$940
$210
$107
$857
$1,162
$1,029
$909
$905
$2,224
$983
$2,381
$468
$643
$2,328
$345
$371
$574
$1,513
$172
$521
$2,163
$1,348
$1,608
$646
$769
$286
$183
$757
$1,237
$856
$275
$3,537
$1,479
$341
$328
Ex.3
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
0
1
1
1
0
1
1
1
0
$677
$2,137
$1,052
$1,246
$1,262
$36
$1,184
$1,356
$1,146
$1,122
$1,460
$2,191
$2,011
$1,221
$378
$1,538
$50
$1,457
$0
$0
$130
$2,001
$1,391
$924
$0
$2,219
$390
$947
$1,719
$2,030
$645
$1,453
$455
$0
$1,138
$0
$2,191
$1,273
$1,358
$0
$2,103
$1,077
$525
$0
18
18
12
24
24
6
6
6
18
24
24
24
18
18
6
24
6
12
18
24
12
24
12
18
18
18
18
12
12
18
6
12
12
18
12
6
24
12
12
24
18
24
18
12
Page 32
$381
$1,813
$777
$2,177
$1,078
$158
$755
$1,481
$1,184
$1,472
$1,856
$2,636
$3,604
$881
$239
$2,090
$321
$1,084
$1,310
$2,452
$268
$2,149
$979
$1,587
$774
$1,779
$865
$922
$1,475
$2,924
$247
$2,104
$392
$1,850
$850
$510
$2,491
$782
$1,081
$2,702
$3,655
$2,098
$862
$1,541
Ex.3
1
1
1
0
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
0
0
0
1
1
0
1
1
1
1
1
1
1
1
1
1
0
1
0
1
1
1
1
0
0
$916
$892
$984
$0
$717
$1,362
$1,731
$0
$1,739
$392
$1,814
$977
$0
$489
$715
$64
$49
$1,373
$82
$0
$0
$0
$972
$67
$0
$1,703
$781
$1,195
$2,563
$367
$1,663
$169
$1,436
$2,210
$1,245
$0
$1,486
$0
$760
$1,708
$1,552
$749
$0
$0
12
18
24
18
18
24
12
12
24
12
12
18
18
18
12
6
12
12
6
12
12
6
24
24
6
12
18
24
24
6
6
18
24
12
18
6
6
6
24
24
24
12
24
6
Page 33
$592
$1,398
$1,093
$1,369
$886
$2,524
$1,693
$1,473
$1,822
$457
$2,226
$2,177
$1,166
$855
$584
$209
$87
$1,457
$274
$927
$1,584
$529
$621
$405
$1,705
$1,384
$498
$2,492
$2,925
$470
$1,046
$576
$1,241
$2,458
$1,838
$176
$647
$921
$1,583
$2,764
$1,944
$824
$1,320
$818
Ex.3
0
1
1
1
1
1
1
1
1
1
1
1
1
0
0
1
1
1
0
1
1
1
1
1
1
1
0
0
1
0
1
0
1
0
0
1
0
1
0
1
1
1
0
1
$0
$1,595
$1,104
$894
$526
$1,349
$223
$1,634
$1,062
$2,402
$18
$1,023
$1,319
$0
$0
$2,025
$1,590
$144
$0
$43
$1,003
$1,338
$2,375
$669
$2,002
$80
$0
$0
$1,428
$0
$1,145
$0
$988
$0
$0
$878
$0
$2,050
$0
$1,106
$857
$1,765
$0
$36
12
24
6
6
12
24
6
24
18
24
6
18
12
18
12
18
6
6
12
6
24
18
24
18
24
6
24
12
18
6
12
24
6
6
6
24
24
24
24
24
6
12
12
18
Page 34
$491
$1,476
$708
$264
$322
$3,052
$188
$3,384
$742
$6,217
$216
$2,034
$1,955
$1,598
$576
$3,785
$1,116
$236
$2,523
$43
$920
$1,357
$5,830
$655
$2,438
$223
$947
$1,473
$1,659
$614
$1,001
$1,314
$446
$307
$1,138
$639
$2,904
$3,491
$1,692
$1,507
$685
$1,877
$1,804
$403
Ex.3
1
0
1
1
1
1
1
1
1
1
1
1
0
0
1
1
1
1
1
1
0
1
0
1
0
0
0
1
1
1
1
0
0
1
1
0
1
1
1
1
1
0
1
0
$751
$0
$2,081
$1,624
$39
$1,510
$254
$1,271
$1,195
$580
$1,486
$628
$0
$0
$356
$783
$1,486
$695
$1,661
$1,030
$0
$1,420
$0
$1,469
$0
$0
$0
$999
$2,069
$1,567
$545
$0
$0
$1,224
$2,140
$0
$277
$1,027
$456
$926
$2,096
$0
$1,627
$0
24
24
24
6
6
12
6
24
24
12
24
12
12
6
12
12
24
12
24
18
24
12
12
6
12
12
6
6
24
18
24
24
12
18
24
12
18
24
6
24
24
12
12
12
Page 35
$1,271
$3,360
$3,167
$1,781
$62
$1,504
$224
$1,431
$1,436
$364
$2,644
$805
$571
$1,352
$528
$716
$2,150
$368
$1,789
$907
$1,012
$1,148
$1,185
$704
$376
$332
$613
$680
$2,746
$2,107
$486
$1,976
$814
$1,753
$3,378
$3,273
$1,001
$1,246
$184
$2,574
$2,304
$1,194
$1,487
$206
Ex.3
0
1
1
1
1
0
1
1
1
1
1
0
1
1
0
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0
0
1
1
0
0
0
1
0
$0
$842
$22
$579
$446
$0
$289
$841
$496
$1,838
$1,144
$0
$797
$1,148
$0
$1,156
$1,490
$0
$89
$2,340
$0
$1,510
$1,824
$2,333
$120
$1,958
$103
$660
$462
$1,162
$920
$722
$1,355
$0
$404
$0
$0
$714
$727
$0
$0
$0
$935
$0
6
12
6
18
12
18
6
24
12
18
24
12
6
18
6
6
24
6
12
18
6
24
24
24
6
24
18
18
24
24
6
24
24
12
24
24
24
12
6
6
6
24
6
12
Page 36
$713
$356
$177
$748
$500
$3,034
$482
$893
$164
$2,563
$1,575
$881
$584
$1,720
$1,024
$1,150
$2,763
$421
$180
$2,176
$273
$2,693
$3,072
$5,209
$143
$1,931
$163
$657
$630
$1,974
$502
$662
$1,512
$1,255
$468
$2,561
$534
$1,307
$735
$1,597
$1,079
$2,599
$473
$1,085
Ex.3
1
1
0
1
1
1
0
0
1
1
1
0
0
1
1
1
1
0
0
0
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
$780
$1,703
$0
$1,887
$19
$396
$0
$0
$1,218
$184
$2,219
$0
$0
$2,354
$2
$12
$910
$0
$0
$0
$1,311
$1,450
$111
$73
$0
$815
$56
$1,870
$48
$1,613
$1,901
$32
$781
$0
$482
$2,009
$123
$851
$1,875
$2,095
$293
$2,348
$508
$2,059
6
6
12
12
6
6
24
24
12
18
12
6
18
24
12
6
18
12
24
12
24
24
6
18
6
12
6
24
24
24
24
6
24
24
6
12
6
18
18
12
18
12
6
12
Page 37
$703
$919
$2,796
$1,830
$183
$330
$917
$615
$808
$427
$1,133
$320
$3,126
$3,001
$271
$140
$1,763
$576
$2,145
$417
$1,790
$3,063
$136
$446
$494
$964
$278
$3,044
$653
$3,293
$3,688
$38
$1,203
$1,607
$317
$1,322
$250
$715
$2,000
$1,702
$296
$2,631
$292
$1,001
Ex.3
0
1
1
$0
$480
$2,093
12
12
6
Page 38
$1,082
$573
$863
Employee
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Education
3
1
1
2
3
3
3
3
1
3
3
2
2
2
3
3
3
2
3
2
3
2
1
2
3
3
2
1
1
2
1
1
3
2
2
1
3
2
1
3
3
1
5
3
1
Grade
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Years1
3
14
12
8
3
3
4
8
4
9
9
8
9
10
4
3
6
8
5
4
4
3
5
3
3
3
16
13
12
4
7
11
3
18
14
19
3
2
11
3
5
15
7
12
18
Years2
1
1
0
7
0
0
0
2
0
0
2
8
0
6
0
0
0
9
6
3
2
3
0
4
1
1
6
0
6
7
4
0
8
2
0
0
2
4
0
2
1
0
0
1
0
Age
26
38
35
40
28
24
27
33
62
31
34
37
37
58
33
27
30
37
44
29
36
28
45
33
24
27
60
48
40
33
35
44
43
46
42
47
25
30
40
26
32
51
35
37
44
Gender
Male
Female
Female
Female
Male
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Male
Male
Male
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
PC Job
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
Yes
No
No
Salary
$32,000
$39,100
$33,200
$30,600
$29,000
$30,500
$30,000
$27,000
$34,000
$29,500
$26,800
$31,300
$31,200
$34,700
$30,000
$31,000
$27,000
$29,600
$32,600
$29,600
$29,500
$31,000
$28,500
$26,700
$30,750
$29,500
$42,200
$37,600
$34,000
$33,000
$28,760
$35,400
$31,000
$38,800
$34,300
$35,000
$34,600
$28,500
$29,500
$30,500
$34,200
$43,600
$33,500
$33,000
$45,300
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
1
1
3
1
2
1
1
2
1
3
3
2
1
1
3
2
2
3
5
3
2
1
3
1
3
1
1
5
3
2
2
5
3
2
5
3
5
1
2
5
1
2
5
5
5
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
17
10
5
15
2
3
4
7
8
15
9
16
8
9
18
3
6
4
5
4
7
11
5
17
3
5
9
3
4
16
9
3
4
8
8
6
4
3
12
3
8
6
3
4
3
15
15
3
0
10
0
0
3
10
0
0
1
0
0
0
0
0
8
3
0
1
4
4
8
4
5
1
9
0
3
0
0
10
0
0
0
0
0
4
9
18
5
0
7
1
0
2
1
0
53
40
51
42
53
58
44
31
64
47
37
46
55
39
51
37
30
26
41
34
57
53
32
44
25
31
50
47
35
43
46
35
22
58
40
30
29
31
52
33
49
34
26
28
35
47
51
Male
Female
Male
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Male
Female
Female
Female
Male
Female
Female
Female
Male
Female
Female
Male
Male
Female
Female
Female
Female
Female
Male
Male
Female
Female
Male
Male
Female
Female
Female
No
No
No
No
No
No
Yes
No
No
No
Yes
No
No
No
No
No
No
No
Yes
Yes
No
No
Yes
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
$38,800
$29,900
$31,200
$34,000
$30,450
$35,500
$34,000
$29,100
$29,650
$29,200
$29,800
$33,500
$34,000
$29,600
$34,000
$37,250
$33,000
$28,600
$36,000
$37,300
$29,900
$31,500
$41,400
$32,740
$33,500
$32,000
$30,800
$42,000
$34,000
$32,500
$31,700
$36,500
$33,000
$31,200
$34,000
$33,000
$33,900
$39,000
$34,920
$39,000
$34,000
$31,900
$37,000
$34,000
$36,400
$38,200
$35,300
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
3
3
4
5
4
3
1
3
1
2
3
2
5
3
5
3
3
2
3
4
3
3
5
5
3
4
3
3
2
2
3
5
2
3
2
5
3
5
5
3
1
1
5
2
5
3
4
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
12
2
8
5
5
11
4
9
14
4
15
7
5
7
7
4
10
5
11
9
4
5
4
5
6
6
5
9
5
3
4
7
8
12
3
4
3
3
8
21
16
5
25
6
21
6
2
0
2
0
0
0
0
3
0
0
5
5
3
0
2
0
12
0
5
4
7
8
6
0
0
0
0
0
0
4
2
0
5
2
6
1
0
0
5
0
0
6
0
10
1
9
5
26
33
27
34
29
27
43
36
38
60
43
48
32
31
29
35
37
43
33
58
44
37
48
26
25
38
41
29
59
29
27
30
34
35
50
33
26
36
33
47
51
42
31
62
46
60
43
Male
Female
Male
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Male
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Male
Female
Male
No
No
No
Yes
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
Yes
No
Yes
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
$34,500
$30,500
$30,000
$37,300
$40,200
$35,500
$35,000
$38,000
$35,300
$34,100
$43,200
$36,100
$34,600
$36,000
$36,200
$37,500
$41,000
$35,600
$39,800
$41,300
$42,500
$45,800
$34,900
$41,500
$38,000
$35,000
$40,000
$36,000
$33,700
$36,300
$38,000
$39,500
$36,300
$32,500
$37,000
$32,600
$36,000
$35,000
$43,600
$33,800
$35,300
$42,400
$39,500
$43,500
$42,000
$40,300
$44,000
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
1
3
5
5
4
5
5
5
5
5
5
5
5
1
5
5
5
2
3
5
1
3
5
3
3
3
5
1
5
3
3
2
3
2
5
5
5
5
3
5
5
3
5
5
5
5
5
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
5
5
5
5
5
5
5
5
5
5
5
5
5
25
13
6
7
8
5
5
4
6
6
5
7
5
13
6
7
6
15
17
4
23
5
3
19
26
6
15
12
9
14
16
16
11
13
7
8
8
6
17
8
8
8
16
6
7
8
12
2
1
5
0
3
3
3
1
3
0
4
3
1
9
0
0
2
4
0
0
0
4
12
8
0
4
0
4
0
1
0
1
0
2
0
0
0
10
4
2
0
5
5
2
0
4
2
53
38
39
35
40
32
33
30
37
30
32
37
29
50
29
32
31
47
44
27
55
52
50
59
47
43
41
39
39
40
49
53
37
40
34
37
31
41
46
37
33
35
49
33
31
49
40
Female
Female
Female
Female
Female
Female
Male
Male
Male
Male
Female
Female
Male
Female
Male
Female
Male
Female
Female
Male
Male
Male
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Male
Male
Female
Male
Male
Female
Female
Male
Male
Male
Female
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
Yes
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
$40,660
$39,700
$45,000
$43,900
$38,000
$39,020
$44,500
$41,000
$44,000
$44,000
$42,500
$40,260
$44,500
$35,500
$42,500
$44,000
$45,000
$44,400
$38,000
$41,800
$45,500
$42,500
$44,000
$54,300
$44,800
$47,000
$43,800
$48,000
$42,700
$48,500
$42,000
$45,500
$44,500
$51,200
$47,500
$44,500
$47,000
$47,000
$43,100
$49,000
$48,500
$45,000
$52,500
$47,500
$48,000
$46,500
$61,500
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
5
5
4
5
5
5
3
5
5
3
5
5
5
5
5
4
5
3
5
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
6
6
9
12
16
11
9
16
24
17
14
13
19
12
20
20
22
21
39
34
36
32
35
33
2
2
0
1
6
7
3
1
0
0
4
0
0
1
0
0
0
0
0
0
0
0
37
46
43
36
37
40
54
57
49
41
59
51
45
56
57
53
65
60
61
62
59
62
Female
Female
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
$50,000
$61,800
$43,000
$47,000
$58,500
$55,000
$57,000
$57,000
$60,000
$60,000
$59,000
$60,000
$65,000
$52,000
$58,000
$60,000
$74,000
$95,000
$97,000
$88,000
$94,000
$30,000
PUAD 630
Analytical Techniques in Public Administration
Regression Part 2.
Statistical Inference.
Class Examples
Replicate the class examples exactly as demonstrated in the class lecture.
Pay equal attention to the accuracy of the analytical techniques you use to solve the problem and
your interpretation of the results. Be sure to include textboxes/comments of your interpretation
and conclusions for every piece of output generated.
Submit your worked data in a single MS Excel Workbook. Create separate (appropriately
labeled) worksheets within a single workbook for each example.
Regression Part 2
PUAD 630
Class Examples
Page | 2
Example 1.
Bendrix has collected data for overhead costs, machine hours and the number of production runs
corresponding to 36 months of production.
Estimate the regression for overhead costs at Bendrix as a function of both machine hours and
production runs.
A. Interpret the point estimates and comment on the accuracy of the point estimates.
B. Comment on if and why each explanatory variable should/should not be included in the
regression equation.
C. Run the usual multiple regression and check the graph of residuals versus fitted values. Check
for lag 1 autocorrelation in two ways: with the DW statistic and by examining the time series
graph of the residuals.
D. Suppose Bendrix expects the values of Machine Hours and Production Runs for the next three
months to be 1430, 1560, 1520, and 35, 45, 40, respectively. Predict Overhead at Bendrix for
the next three months, given the anticipated values of Machine Hours and Production Runs.
Example 2.
Simulation is used to generate a hypothetical data set of heights and left and right foot lengths where
height is approximately 31.8 plus 3.2 times foot length (all expressed in inches).
Estimate a regression when both Right and Left are entered in the equation for Height and check
for multicollinearity in your model.
Regression Part 2
PUAD 630
Class Examples
Page | 3
Example 3.
The data include 750 customers who purchased mail-order products from a HyTex catalog.
For each customer, data is available for:
Age of the customer
Gender
Whether they own their home
Whether they are married
Whether they live reasonably close to a shopping area that sells similar merchandise
Combined annual salary of customer and spouse (if any)
Number of children living with customer
Whether they purchased from HyTex during the previous year
Total amount of purchases made from HyTex during the previous year
Number of catalogs sent to the customer this year
Total amount of purchases made from HyTex this year
A. Estimate a regression equation for Amount Spent based on all of these variables.
B. Choose either the forward, backward, or stepwise procedure and interpret a regression equation
for Amount Spent based on the included variables.
Example 4.
The data set includes the following variables for each of the 208 bank employees:
Education (categorical)
Grade (categorical)
Years1 (numerical. years with this bank)
Years2 (numerical. years of previous work experience)
Age (numerical)
Gender (categorical with two values)
PCJob (categorical yes/no for if employee's current job is primarily computer-related)
Salary (numerical)
A. Run a regression analysis with Salary as the dependent variable, and Education, Years1, and
Gender as explanatory variables. Also include an interaction variable to see whether the effect of
Years1 is different across the two genders.
Examine the data for any outliers using boxplots and scatterplots of the residuals versus the
fitted values.
B. If outliers are identified, rerun the regression without the outlier(s) and interpret the results.
Comment on the effect of including/excluding the outlier(s).
Regression Part 2
PUAD 630
Class Examples
Page | 4
Purchase answer to see full
attachment