Analytics Module 1 Comprehensive Assignment

aujam253
2-7Distribution.xlsx
Home>Business & Finance homework help>Operations Management homework help>Analytics Module 1 Comprehensive Assignment

Chart1

Total 60-70 70-80 80-90 90-100 100-110 110-120 120-130 130-140 140-150 150-160 50 50 51 61 43 51 61 44 43 46

Chart2

Total 60-70 70-80 80-90 90-100 100-110 110-120 120-130 130-140 140-150 150-160 50 50 51 61 43 51 61 44 43 46

Sheet2

Row Labels Count of Normal
60-70 50
70-80 50
80-90 51
90-100 61
100-110 43
110-120 51
120-130 61
130-140 44
140-150 43
150-160 46
Grand Total 500

Sheet1

Normal Uniform
135.2745109922 135.8751182592 -1.8333333333
136.6177573596 87.4391918699 x 34
151.2232918481 129.8812829981 mean 45
127.7209824162 71.6519669179 st.Dev.p 6 -3.5333333333
86.3755635943 107.5417340617 p smaller than 34 0.0333765076 0.00058747
125.7749934462 60.7232886746
99.4281711224 135.1792962432 x 678
47.3932439287 110.1632740257 mean 890
87.8901485317 139.1650135807 St.Dev.S 60
125.2271752288 93.371990112 n 36
68.3234113945 147.8902554399 degree freedom 35
112.7548753426 60.5859553819 P smaller than 678 (
141.7838009525 60.6866664632 -3.5333333333
109.3938706414 94.9742118595
11.8664709385 90.8297982727
28.1321925082 149.6450697348
103.3087815154 156.4659566027
95.0499773149 68.9938047426
88.2700797116 134.1355632191
53.9598593401 75.3904843287
147.5652677778 156.9847712638
101.7869183466 99.9822992645
93.6408892154 146.0896633808
147.0852046419 117.1886349071
97.6262461132 121.4703817866
71.7071887062 68.3162938322
140.2215323447 61.3580736717
127.2887155006 93.5367900632
136.4361017091 76.9011505478
102.8701367683 95.6547746208
111.7863828564 157.2411267434
77.5934770696 95.8684041871
88.2458814682 129.1122165593
106.1663126871 74.1148106326
115.26091296 78.4911648915
96.0842364999 76.4494766076
92.9218074612 111.5732291635
102.492756721 82.4280526139
57.0890486211 101.4899136326
92.4172459487 118.5192419202
116.5911785643 87.5185399945
144.1336942458 142.0856349376
89.3689800956 78.2195501572
70.6949142819 66.7598498489
162.3950018053 70.9897152623
145.9934699393 116.6637165441
124.5494743467 150.7895138401
134.963197777 146.2636188849
166.3288483338 82.4677266762
52.7956424572 107.465437788
61.3257296005 77.0751060518
78.2157283335 148.0794701987
116.5482219927 104.7035126804
95.1546487864 148.528092288
124.2144506046 158.1414227729
80.4639514878 109.5162816248
63.6936308889 154.3449201941
87.6251308706 154.2014831996
165.3140978102 108.0056154057
127.7389904113 67.2634052553
71.6086699664 135.0358592486
57.8021652269 122.3889889218
103.6006986193 156.4568010498
150.0677788295 111.5182958464
99.6200688201 87.5734733116
92.821037722 146.5627002777
152.472146308 125.4591509751
122.460621949 119.1845454268
136.7160509995 102.7686391797
72.700629769 139.7112949004
122.3843130698 69.8605304117
61.2705050822 94.3333231605
93.8619373552 112.6078066347
94.5387753542 123.3014923551
111.4506838145 122.9535813471
133.4300420946 93.9823603015
128.9695367428 125.3736991485
103.798824082 84.4331186865
119.0359514818 137.5414288766
120.4092111744 67.3732718894
107.5775767527 120.3442487869
86.1249898458 154.2777794733
104.5036870233 63.1586657308
123.1756143876 86.8410290841
92.0564857803 67.6754051332
117.7561082637 110.8865627003
103.2453408494 150.0479140599
174.3316013541 98.4136478774
130.7525533572 89.1055024873
66.0641583432 159.6154667806
15.8834543778 120.4846339305
91.1438180789 70.2542191839
100.3622608347 125.0990325633
97.573085011 94.1410565508
128.0130871033 98.1542405469
78.3035548262 67.1016571551
111.6761589197 124.0797143468
100.3471041055 91.3272499771
111.1588792606 136.1406292917
79.0407946421 128.7887203589
77.6061576995 119.3371379742
91.251040683 142.9432050539
149.5083304486 134.1630298776
21.2162219919 80.9875789666
87.2451246574 109.272133549
75.4572036181 77.471846675
106.3230947944 85.7240516373
20.4070627457 156.3408307138
100.6046184353 106.5712454604
97.3907915773 75.0669881283
68.7133595216 145.7417523728
144.1152360509 154.0214239937
132.0548315358 71.9663075655
58.9596291116 128.7856685079
78.762120918 159.3102816858
45.8137926922 115.9221167638
152.7782822246 98.1725516526
145.8339491161 155.2452162236
67.9492202631 142.2443311869
29.2778011295 147.5789666433
143.5781475971 159.6704000977
120.3909030461 107.8194524979
127.8938591691 153.9970091861
87.8172161516 61.9074068422
118.6526062862 93.8999603259
63.5453650626 95.5082857753
71.8418735029 153.5544907987
60.2778893859 73.9744254891
84.826125683 129.5699942015
99.55947942 60.57985168
43.6816460729 79.0160832545
85.6575323065 124.8121585742
124.3070792294 127.6107058931
119.8981592803 118.1286049989
35.7771866926 141.3959166234
69.1068342145 62.4903103732
92.484588347 150.4934842982
117.2678664967 110.6851405377
74.7424362795 73.3030182806
133.5060508405 158.5473189489
129.0847879114 125.4560991241
116.5024516718 80.9723197119
88.7742660576 123.1702627644
149.6801567351 87.8664510025
84.5562683731 117.3412274545
127.8613697446 115.9831537828
76.8825364299 135.5638294626
88.7662374931 150.1913510544
134.2025100508 76.5868099002
119.0508455944 65.413983581
171.000722528 108.2894375439
108.6235036179 61.3275551622
143.9308041678 78.0669576098
123.9738938035 87.7077547533
107.8084542565 66.8605609302
77.0017643641 92.2519608142
91.6609101547 116.3646351512
109.4938150141 126.7104098636
92.9476189209 146.9899594104
117.1984231656 84.1157261879
76.5685220154 73.1138035218
105.5021928347 72.1189001129
139.8212296204 125.694143498
55.3169118371 117.4449903867
82.1563278601 122.0502334666
134.397521631 106.8947416608
84.4152807782 91.6721091342
-5.8197813109 63.4791100803
118.3630527317 87.3628955962
126.1810737356 94.6354564043
20.1267382887 95.5693227943
83.084339874 95.935544908
62.0928701916 121.0126041444
77.8534299821 110.1815851314
95.4198915475 70.7272560808
111.201648249 91.1990722373
129.62855433 114.6006653035
88.6484727085 66.4729758599
144.3071712652 65.0935392315
119.9253963729 95.1329081088
83.9281645109 111.4450514237
124.9877439273 140.840479751
76.3960204291 74.8625141148
79.9320403326 84.6162297433
100.9455322925 134.4682149724
96.6785378547 153.8047425764
32.1983978007 120.5334635456
91.135939581 101.93243202
127.2638044407 95.5418561357
96.5440406413 103.5865352336
46.3130643562 155.9318826869
98.0942288857 90.1248207038
75.861483108 101.9019135105
94.2621650462 109.3728446303
80.032134772 150.9024323252
95.009121676 107.4837488937
86.8853024054 125.2333140049
96.201175918 66.4912869655
17.8703365033 138.2494582965
65.8061187802 149.2117069002
101.0718133581 149.107943968
157.1594773646 66.6560869167
124.7396087616 65.5421613208
60.3818855576 154.4761497848
100.9455322925 60.3540147099
73.9535360277 86.3466292306
96.0588002068 142.4518570513
60.3715309604 126.9423505356
77.1912234792 99.9975585192
80.6321761753 96.4970854823
54.066556711 124.1956846828
148.9551848659 146.8770409253
70.3337039136 139.384746849
126.647105642 96.576433607
52.0897290495 121.7847224342
130.9087727146 103.0097354045
104.4654575504 97.1471297342
104.0073041419 126.2404248177
61.8081938024 79.5867793817
148.6912176711 122.2241889706
126.5109201791 62.6093325602
78.0742905386 157.6165044099
108.9190223207 110.9659108249
71.9833112977 125.2333140049
83.1907371117 141.2524796289
85.6991757952 121.3818781091
119.5149641513 132.5028229621
53.3370828431 86.3649403363
57.859265578 87.8695028535
77.8755648094 69.7933896908
71.2413818997 87.4941251869
105.5969223922 125.5659657582
75.8251669846 143.0774864956
74.2112754575 129.7042756432
123.8229267779 99.3566698202
126.4551704277 110.7461775567
116.003705241 138.7255470443
115.6242617777 148.76003296
86.6773850954 145.4823450423
124.3766726271 98.6242255928
116.2169499163 87.9122287667
104.0962936509 87.9122287667
167.6770468999 92.2855311747
104.9883271913 92.1604052858
161.9631100562 125.1783806879
99.5089820004 63.320413831
103.9309952626 81.9794305246
87.2913451782 142.70516068
37.9189375759 112.5223548082
82.5349834737 90.7901242103
87.6196909554 111.7258217109
122.4637733481 75.024262215
147.7156345369 76.8706320383
109.4306744813 135.8842738121
98.8246031535 95.8134708701
140.8876030633 63.2837916196
109.7572194591 94.6079897458
44.0782721649 122.8254036073
67.5953631595 151.4731284524
98.0284997037 136.1436811426
91.1673785391 88.7972655416
176.7194615037 105.3077791681
139.1855473936 98.9080477309
98.2055032888 139.0551469466
95.0550795802 154.7447126682
56.8231305602 152.3520615253
111.3944088298 116.2730796228
109.8442956187 131.9626453444
34.0289105021 79.4830164495
125.7544343185 152.3184911649
165.6757583783 140.1049836726
79.6854433498 150.4202398755
90.1768262589 70.8493301187
119.0389152976 88.2021546068
75.9405682198 151.9125949889
165.7309828966 108.3535264138
131.7206331601 61.7242957854
112.6950362755 87.3812067019
110.1455918866 141.5149388104
73.5865480943 70.5227820673
55.8600779892 105.1307718131
100.6626942195 98.8409070101
105.5072951 87.7687917722
103.5702350942 72.8635517441
92.266841673 125.755180517
70.0146622672 101.1145359661
6.9827026688 147.3165074618
137.4613568965 118.766441847
98.3470536336 143.5352641377
137.9609286938 93.9945677053
147.6224431623 91.91625721
139.7116809836 129.4967497787
118.9376578419 134.9687185278
95.7510135573 77.1514023255
180.7514516055 85.104525895
90.7926246578 76.8126468703
136.7489155906 147.7071443831
113.2924515128 68.8076418348
95.2515918267 138.682821131
114.9189861531 75.958128605
104.2286524149 134.1264076663
115.1963467943 67.5563829463
61.0129907524 139.7235023041
105.3793633015 67.1108127079
119.3498533463 119.4409009064
135.0651680492 110.4837183752
138.2609118788 88.7362285226
85.0194865303 63.4455397198
107.4195565958 70.0405896176
46.2275263795 130.6991790521
67.2790977456 139.5678579058
48.187546579 93.9121677297
43.1212972922 77.6274910733
100.5541210157 67.4098941008
34.1585680668 81.6711935789
124.1022758019 118.8885158849
55.9894354206 124.8060548723
111.6680928386 131.6544083987
89.5230610036 155.4344309824
120.1774332709 146.779381695
88.8250636104 147.7285073397
113.5447510274 80.8136234626
122.1212462748 141.072420423
86.4991809773 129.7347941527
73.9604390925 61.4648884548
94.8098707137 105.0819421979
86.6883399591 111.8417920469
55.9587467957 66.5981017487
91.4209161034 63.6866359447
99.6200688201 78.9001129185
112.9973454932 92.0963164159
129.5530708172 91.2021240883
156.4595666219 82.2571489608
104.9602272156 80.6335642567
95.1418931232 110.8651997436
140.5739638154 74.1209143345
77.9608401695 82.4372081668
105.4970905694 133.4855189673
87.5546745898 91.5591906491
102.4471739835 116.0594500565
118.8573346804 99.2773216956
102.0751963348 70.834070864
151.6056616107 68.4505752739
130.0158762911 60.9399700919
87.1661896123 110.8072145756
66.4939491595 79.1381572924
90.9788198238 70.5044709616
114.542468989 106.8703268532
99.2766788637 117.7043977172
116.3509594131 121.4673299356
120.2261298909 63.2563249611
86.3590937821 143.0439161351
143.3977675129 145.0001525925
123.9837231675 94.8368785669
125.1899587056 89.2886135441
113.5090726872 90.7840205084
116.5167080013 131.5048677023
127.4596413874 124.473403119
113.6959431529 97.9833368938
112.7711950881 76.7973876156
51.8275626542 122.5385296182
121.0797838918 148.0855739006
63.9652514816 105.1521347697
114.9106199387 116.7766350291
106.7633527578 131.6238898892
113.0027854084 93.3353679006
101.9310573407 73.1778923917
123.4575145441 137.4864955596
115.5395866841 86.7220068972
169.5855942467 101.5692617573
100.7839105365 152.2971282083
82.4041628926 115.4368724631
86.7868586989 126.6982024598
147.9248274132 100.9802545244
111.9749415717 73.5990478225
117.5580203177 60.3082369457
110.8439644464 63.5737174596
133.4722858497 82.2968230232
122.1023378799 134.4743186743
80.6021628501 121.214026307
125.237304726 76.251106296
52.8167268181 80.1544236579
57.2823344351 67.0101016266
135.3237328454 143.9197973571
138.5091971111 151.2991729484
56.9001897726 113.233436079
105.1977826843 130.0552385022
94.6334298784 157.204504532
108.8744900495 136.412244026
91.6765546004 86.322214423
106.5417793849 115.5284279916
93.319108853 116.4134647664
55.5556678388 122.2333445235
43.4200799442 107.4379711295
68.9303558625 109.6139408551
114.5452827383 82.3914304025
93.6383005661 118.0889309366
73.7254347565 123.0634479812
134.0430642609 99.4512771996
163.8248366158 63.8666951506
137.1409646505 137.3003326518
124.4164777996 124.7236548967
108.3860231825 65.9907834101
60.3299625051 101.4410840175
78.8923787492 157.7050080874
65.036802223 129.945371868
134.0173278346 153.5758537553
72.4939880252 121.3361003449
113.4596632506 72.9642628254
99.923015821 90.7718131046
106.017371561 156.9023712882
91.5879402579 136.9402142399
125.1696997111 100.3790398877
105.6942781157 132.9331339457
93.0250908164 116.025879696
119.2929405785 126.3838618122
75.0693564238 60.6866664632
53.3096206505 78.7963499863
49.1356675207 159.9755851924
45.4014096045 64.1718802454
52.1620611631 95.642567217
65.8578917661 157.265541551
111.44265525 89.6029541917
38.1836551038 135.0877407147
127.9805226455 138.8659321879
108.2114206634 153.6674092837
95.3841756906 140.3674428541
-0.0092015602 108.3901486251
64.0658711542 105.6373790704
102.1055473098 102.8540910062
128.8436308438 115.5803094577
108.7097168944 100.5590990936
132.265900245 117.3015533921
62.2195264237 78.5552537614
81.3444298979 130.8151493881
77.8976621201 104.5753349406
144.2637269771 125.810113834
57.3290051558 82.1716971343
47.1399314643 60.0549333171
55.7548812845 113.9658803064
88.9773437189 154.1465498825
106.0148204284 84.0821558275
122.3461961468 124.2353587451
110.3098022919 119.7003082369
163.1030161458 118.1316568499
161.2139774603 120.6463820307
102.4598170967 112.7756584368
112.3775703287 108.0330820643
42.8291175718 145.3633228553
115.145811858 99.954832606
111.6546618756 78.7749870296
113.5310199312 137.4987029633
136.5850428352 156.7894528031
169.3313813827 119.5416119877
80.5301308697 98.4472182379
91.3190208645 123.0695516831
119.2659661025 126.6615802484
61.8032416038 149.0987884152
42.6013164339 135.4264961699
112.4344830965 105.7289345988
40.4549134852 86.3893551439
143.8757297161 81.3568529313
117.3721628016 100.595721305
25.4108843161 135.478377636
122.6263705372 87.9763176366
125.237304726 104.3006683554
111.2150041787 148.061159093
123.0497835219 145.9492782373
90.85824129 92.6670125431
120.9437484955 97.7208777123
113.4404547225 97.858211005
93.3242861516 148.7752922147
134.1377563018 100.3973509934
45.7261537827 107.3708304086
106.4234143338 126.0512100589
84.4152807782 125.7643360698
100.114876002 85.6904812769
59.2966787532 99.7656178472
70.8070890847 112.8458510086
111.2819338938 147.1028778954
106.6937593601 155.6358531449
90.2717809164 150.7559434797
49.1026528631 89.3191320536
72.9698492956 93.606982635
92.6373936887 95.5510116886
135.9021646545 71.0324411756
135.1095877704 73.4403515732
118.4073223863 111.249732963
100.9101540854 117.9729606006
137.2315298591 121.6840113529
96.6353936998 135.9269997253
88.8811885285 75.9947508164
54.3047124462 80.5786309397
118.2718122232 122.8650776696
119.9769442588 86.6487624744
132.3963831761 97.159337138
155.2849951418 88.7087618641
170.9749110683 108.8235114597
60.2935713483 122.1478926969
97.0208773448 137.3094882046