Signature Assignment Data Driven Decision Making

User Generated

Nevrynw5

Business Finance

Description

Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics

Scenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases:

  • Manufacturing
  • Hospital
  • Consumer Food
  • Financial

Select one of the databases based on the information in the Signature Assignment Options.

Provide a 1,600-word detailed, statistical report including the following:

  • Explain the context of the case
  • Provide a research foundation for the topic
  • Present graphs
  • Explain outliers
  • Prepare calculations
  • Conduct hypotheses tests
  • Discuss inferences you have made from the results

This assignment is broken down into four parts:

  • Part 1 - Preliminary Analysis
  • Part 2 - Examination of Descriptive Statistics
  • Part 3 - Examination of Inferential Statistics
  • Part 4 - Conclusion/Recommendations

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Signature Assignment
I.

Preliminary Analysis

II.

Descriptive Statistics

III.

Inference Statistics

IV.

Conclusion and Recommendations


SIC Code No. Emp. No. Prod. Wkrs. Value Added by Mfg.
Cost of Materials End Yr. Inven.
201
433
370
23518
78713
3630
202
131
83
15724
42774
3157
203
204
169
24506
27222
8732
204
100
70
21667
37040
3407
205
220
137
20712
12030
1155
206
89
69
12640
13674
3613
207
26
18
4258
19130
1946
208
143
72
35210
33521
7199
209
171
126
20548
19612
3135
211
21
15
23442
5557
5506
212
3
2
287
163
42
213
2
2
1508
314
155
214
6
4
624
2622
554
221
52
47
2471
4219
929
222
74
63
4307
5357
1427
223
13
12
673
1061
325
224
17
13
817
707
267
225
169
147
8986
10421
2083
226
51
41
3145
4140
697
227
55
44
4076
7125
1446
228
84
76
3806
8994
1014
229
61
47
4276
5504
1291
231
27
22
1239
716
356
232
200
178
9423
8926
2314
233
294
250
11045
11121
2727
234
38
32
1916
2283
682
235
17
14
599
364
197
236
34
28
2063
1813
450
237
1
1
34
71
17
238
31
25
1445
1321
526
239
224
179
10603
12376
2747
241
83
68
5775
9661
578
242
172
147
10404
19285
3979
243
257
209
13274
18632
3329
244
51
43
1909
2170
355
245
82
68
4606
7290
580
249
94
78
5518
8135
1604
251
273
233
12464
12980
3535
252
70
53
5447
4011
829
253
37
29
2290
5101
447
254
81
61
4182
3755
956
259
54
39
2818
2694
718
261
15
11
2201
3279
725
262
116
90
18848
20596
4257
263
55
42
9655
10604
1502
265
212
163
15668
24634
3976

267
271
272
273
274
275
276
277
278
279
281
282
283
284
285
286
287
289
291
295
299
301
302
305
306
308
311
313
314
315
316
317
319
321
322
323
324
325
326
327
328
329
331
332
333
334
335

232
403
121
136
69
604
41
21
65
55
80
115
213
126
51
126
37
76
67
25
14
65
8
61
122
763
15
3
37
2
6
8
7
12
60
64
17
31
45
205
17
72
221
128
35
15
162

182
136
16
57
25
437
28
12
50
39
45
79
106
75
28
75
24
45
43
18
8
54
7
46
95
598
12
2
31
2
4
7
6
9
51
50
13
25
36
152
13
53
174
106
26
11
123

25918
30692
17982
17857
9699
38407
3878
3989
4388
4055
16567
25025
59813
31801
8497
28886
12277
11547
26006
3464
2187
7079
442
4528
7275
55621
1313
162
1907
53
747
328
233
1717
6532
4850
3509
2176
2696
15739
999
7838
29180
9061
4200
1410
16670

28963
8483
6940
8863
2823
29572
3811
1047
2055
1098
11298
34596
27187
19932
9849
46935
11130
13085
132880
6182
4446
7091
496
3805
7195
57264
1865
163
1682
85
395
255
177
943
3527
4254
2282
1387
1183
17010
565
5432
45696
6913
11184
5735
31892

5427
894
1216
3736
874
4300
688
577
504
236
2644
6192
11533
4535
2178
8577
2354
2749
10718
658
670
1067
175
1057
1411
11874
404
35
716
62
199
75
40
282
1505
883
828
700
600
1966
263
1652
12198
1543
1834
694
6377

336
339
341
342
343
344
345
346
347
348
349
351
352
353
354
355
356
357
358
359
361
362
363
364
365
366
367
369
371
372
373
374
375
376
379
381
382
384
385
386
387
391
393
394
395
396
399

94
32
33
140
45
432
104
259
129
40
300
79
94
205
295
192
265
259
201
392
74
171
108
157
49
258
588
151
772
377
141
31
18
81
47
186
272
268
27
61
6
43
13
103
35
24
179

79
23
27
107
32
315
81
211
99
24
219
55
70
133
211
110
172
96
147
293
51
120
87
117
37
120
368
106
634
190
108
23
14
29
35
68
141
157
17
36
4
30
10
76
26
19
123

5856
3164
3999
11750
4412
27974
6936
19880
7793
3528
21718
10513
9545
18178
22673
19221
23110
41135
17521
25322
6700
14278
9466
13428
3459
38705
84059
13920
105899
45220
7903
2590
1435
9986
3564
21071
29028
31051
2390
14032
415
2761
685
8327
2643
1406
11199

4696
2790
9364
8720
3527
31527
4909
21531
6232
1689
19273
12954
11858
23474
14343
16515
18543
60857
21819
13897
5523
12657
12578
11065
7621
29591
44486
13398
223639
42367
7760
4363
1674
8120
5476
8760
18028
16787
1020
8114
382
3646
506
6604
1789
997
8530

938
800
1453
3124
1121
7204
1768
3997
1181
1077
6460
3679
3339
7344
6730
6823
7898
10277
4857
4964
1495
3887
2299
3076
1070
9467
13145
3514
15852
36814
2165
1233
412
4770
1102
6183
7681
7761
426
2290
177
1451
328
2608
799
415
2861

Indus. Grp.
1
1
1
1
1
1
1
1
1
2
2
2
2
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
5
5
5
5
5
5
6
6
6
6
6
7
7
7
7

7
8
8
8
8
8
8
8
8
8
9
9
9
9
9
9
9
9
10
10
10
11
11
11
11
11
12
12
12
12
12
12
12
13
13
13
13
13
13
13
13
13
14
14
14
14
14

14
14
15
15
15
15
15
15
15
15
15
16
16
16
16
16
16
16
16
16
17
17
17
17
17
17
17
17
18
18
18
18
18
18
18
19
19
19
19
19
19
20
20
20
20
20
20

Hospital Geog. Region Control Service Census Births Personnel
1
1
2
1
107
312
792
2
1
1
1
198 1077
1762
3
1
2
1
356 1027
2310
4
1
1
1
100
355
328
5
7
1
1
9
168
181
6
4
2
1
159 3810
1077
7
4
4
1
65
735
742
8
4
2
1
48
1
131
9
1
2
1
253 1733
1594
10
1
1
1
21
257
233
11
1
1
1
27
169
241
12
6
3
1
30
430
203
13
6
3
1
43
0
325
14
6
2
1
233 2049
676
15
6
4
1
2
211
347
16
6
1
1
11
16
79
17
6
3
1
84 2648
505
18
6
2
1
219 2450
1543
19
6
3
1
112 1465
755
20
6
3
1
124
0
959
21
6
3
1
50 1993
325
22
6
2
1
142 2275
954
23
6
2
1
111 1494
1091
24
6
1
1
140 1313
671
25
6
3
1
28
451
300
26
6
2
1
154 1689
753
27
6
2
1
150 1583
607
28
6
3
1
144 2017
929
29
6
3
1
42
995
354
30
6
2
1
77 2045
408
31
5
2
1
119 1686
1251
32
5
2
1
27
503
386
33
5
2
1
15
126
144
34
2
2
1
179 2026
2047
35
2
2
1
175 1412
1343
36
2
2
1
461 1517
1723
37
1
3
2
32
0
96
38
1
2
1
74
0
529
39
1
1
1
414 2719
3694
40
1
2
1
253 1074
1042
41
1
3
1
180 1421
1071
42
1
1
1
184
762
1525
43
1
2
1
243 3194
1983
44
1
2
1
115
496
670
45
1
1
1
215 1442
1653
46
1
3
2
48
0
167

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

1
1
1
1
1
1
1
1
7
7
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
1
1
1
1
1
1
1
1
2

3
2
1
1
3
2
1
2
2
3
1
3
2
2
2
2
2
3
2
2
2
4
2
2
1
3
1
2
2
2
1
2
2
1
3
1
1
3
4
1
2
3
3
2
1
3
2

1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
2
2
1
1
1
1
2
1
1
1
1

124
189
181
9
28
288
108
154
76
165
295
101
69
12
185
378
114
49
106
460
43
29
125
17
10
14
173
207
223
82
64
139
109
298
52
34
168
21
390
47
80
50
113
45
76
129
60

1107
2989
113
0
0
173
1064
759
1317
1751
0
0
714
99
2243
3966
1308
0
2514
3714
126
556
1327
415
216
339
1217
2641
790
520
35
1168
793
0
0
14
0
0
0
0
776
451
0
145
1284
1
319

793
841
316
93
373
263
943
605
596
1165
568
507
479
136
1456
3486
885
243
1001
3301
337
1193
1161
322
185
205
1224
1704
815
712
156
1769
875
790
308
70
494
111
1618
244
525
472
94
297
847
234
401

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
140

2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
1
1
1
3
3
3
3
3
5
5
5
5
3
3
3
5
5
5
2
2
2
2
2
2
5
5
5
2

2
2
2
2
2
1
2
4
2
1
3
3
4
1
3
2
1
2
2
3
1
1
1
4
3
1
4
2
1
4
2
3
1
2
3
3
1
4
3
3
2
2
1
1
2
2
2

1
1
1
1
1
1
1
2
2
1
1
2
1
2
2
1
1
1
1
1
2
1
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1

418
17
138
64
62
131
265
456
40
310
72
19
112
375
15
78
123
54
96
82
1106
30
56
36
127
180
59
127
37
13
100
47
194
172
516
120
179
140
78
68
186
91
340
254
108
61
174

2154
295
496
589
806
701
3968
0
0
3655
0
0
0
0
0
3063
169
66
827
570
0
0
0
342
494
0
0
0
0
286
235
339
398
1275
5699
1364
714
0
0
0
779
0
2202
3346
1071
352
254

3928
198
1231
545
66...


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags