DR NAPOLEAN - ADDITIONAL

profileelbsmi
cannot_figure_what_is_wrong.xlsx
Home>Mathematics homework help>DR NAPOLEAN - ADDITIONAL

Sheet1

PERSON WAITING TIME PROBABILITY MEAN STANDARD DEVIATION STANDARD ERROR FREQUENCY DISTRIBUTION
1 35 0.0012019231 34.96 2.9946754095 0.0515766095 0
8 36 0.0012019231 34.9595959596 3.0099128468 0.0520981117 0
11 31 0.0012019231 34.9489795918 3.02352443 0.0526303056 0
15 30 0.0012019231 34.9896907216 3.0121104359 0.0531743819 0
17 32 0.0012019231 35.0416666667 2.9838747916 0.0537250537 0
18 34 0.0012019231 35.0736842105 2.9830803203 0.054275982 0
19 39 0.0012019231 35.085106383 2.9969862083 0.0548283644 0
20 34 0.0012019231 35.0430107527 2.9851588644 0.0553879032 0
21 35 0.0012019231 35.0543478261 2.999502268 0.055973214 0
22 34 0.0012019231 35.0549450549 3.0161146359 0.0565674584 0
24 37 0.0012019231 35.0666666667 3.0309267319 0.0571742273 0
25 36 0.0012019231 35.0449438202 3.0410453958 0.0577899612 0
26 33 0.0012019231 35.0340909091 3.0567387912 0.0584267068 0
30 31 0.0012019231 35.0574712644 3.066534753 0.0590811184 0
36 37 0.0012019231 35.1046511628 3.0525941514 0.0597422688 0
37 33 0.0012019231 35.0823529412 3.06365703 0.0603977455 0
39 34 0.0012019231 35.1071428571 3.0734692816 0.0610782862 0
42 30 0.0012019231 35.1204819277 3.0897059232 0.0617620452 0
44 34 0.0012019231 35.1829268293 3.0555678738 0.0624537706 0
45 38 0.0012019231 35.1975308642 3.0717248944 0.0631197156 0
46 38 0.0012019231 35.1625 3.0747800168 0.0637880941 0
47 35 0.0012019231 35.1265822785 3.0774910219 0.0644970605 0
50 31 0.0012019231 35.1282051282 3.0973762435 0.0652466192 0
54 31 0.0012019231 35.1818181818 3.0810425129 0.0660123948 0
64 36 0.0012019231 35.2368421053 3.0631940674 0.0667549014 0
65 39 0.0012019231 35.2266666667 3.0825285047 0.0674619179 0
67 39 0.0012019231 35.1756756757 3.0715580273 0.068192904 0
71 39 0.0012019231 35.1232876712 3.0593445444 0.068987998 0
74 32 0.0012019231 35.0694444444 3.0457839199 0.0698457128 0
84 39 0.0012019231 35.1126760563 3.045133334 0.0707636251 0
85 38 0.0012019231 35.0571428571 3.0306918629 0.0716741497 0
87 38 0.0012019231 35.0144927536 3.0316601627 0.0726488174 0
96 35 0.0012019231 34.9705882353 3.0320210896 0.0736761285 0
97 30 0.0012019231 34.9701492537 3.054902415 0.0747545012 0
98 30 0.0012019231 35.0454545455 3.0149974776 0.0758650737 0
99 34 0.0012019231 35.1230769231 2.971256533 0.0769660664 0
100 33 0.0012019231 35.140625 2.9913483051 0.0780341255 0
101 33 0.0012019231 35.1746031746 3.0029001173 0.0791134173 0
104 32 0.0012019231 35.2096774194 3.0143759204 0.0801828057 0
108 37 0.0012019231 35.262295082 3.0105461262 0.0812337079 0
109 38 0.0012019231 35.2333333333 3.0273704351 0.082229925 0
110 31 0.0012019231 35.186440678 3.0312998024 0.0832925694 0
111 33 0.0012019231 35.2586206897 3.0061944517 0.0844509242 0
120 35 0.0012019231 35.298245614 3.0175966802 0.0855198664 0
122 39 0.0012019231 35.3035714286 3.0446354781 0.0865328986 0
124 37 0.0012019231 35.2363636364 3.030484843 0.087548842 0
125 30 0.0012019231 35.2037037037 3.0491547213 0.0887167977 0
127 32 0.0012019231 35.3018867925 2.9909151266 0.0899725376 0
130 35 0.0012019231 35.3653846154 2.9838049544 0.0910432778 0
131 34 0.0012019231 35.3725490196 3.0130435398 0.091955681 0
134 32 0.0012019231 35.4 3.0371845179 0.092838052 0
135 39 0.0012019231 35.4693877551 3.028352418 0.0936174271 0
136 36 0.0012019231 35.3958333333 3.0158417429 0.0941159912 0
143 36 0.0012019231 35.3829787234 3.0471168946 0.0948273485 0
146 35 0.0012019231 35.3695652174 3.079384467 0.0955405471 0
152 32 0.0012019231 35.3777777778 3.1136713852 0.0962549673 0
160 38 0.0012019231 35.4545454545 3.1062917805 0.0968773698 0
164 39 0.0012019231 35.3953488372 3.1178406362 0.0970602175 0
166 38 0.0012019231 35.3095238095 3.1037985794 0.0974035602 0
167 31 0.0012019231 35.243902439 3.1127197738 0.098050554 0
169 38 0.0012019231 35.35 3.0763781569 0.0989241402 0
173 37 0.0012019231 35.2820512821 3.0860357636 0.0991608869 0
177 39 0.0012019231 35.2368421053 3.1143452787 0.099625627 0
179 38 0.0012019231 35.1351351351 3.0926630215 0.1002098562 0
183 39 0.0012019231 35.0555555556 3.0978743352 0.1012439313 0
189 32 0.0012019231 34.9428571429 3.0673120743 0.1026320629 0
191 36 0.0012019231 35.0294117647 3.0697477353 0.1045474926 0
192 35 0.0012019231 35 3.1124748995 0.1060405489 2
193 36 0.0012019231 35 3.1622776602 0.1076608198 1
194 34 0.0012019231 34.9677419355 3.2091937821 0.1092382523 0
195 30 0.0012019231 35 3.2589399588 0.1109641004 1
197 39 0.0012019231 35.1724137931 3.1743274374 0.1123923759 0
200 39 0.0012019231 35.0357142857 3.1444500533 0.1120619243 0
203 38 0.0012019231 34.8888888889 3.1050001032 0.1126378415 0
206 39 0.0012019231 34.7692307692 3.1023564245 0.1142844678 0
208 31 0.0012019231 34.6 3.0413812651 0.1168208364 0
211 39 0.0012019231 34.75 3.010849945 0.1206064613 0
226 39 0.0012019231 34.5652173913 2.9360778872 0.1234049673 0
227 33 0.0012019231 34.3636363636 2.8375954701 0.1277644793 0
228 39 0.0012019231 34.4285714286 2.890872335 0.1335786796 0
233 31 0.0012019231 34.2 2.7644357947 0.1396160686 0
234 36 0.0012019231 34.3684210526 2.732734209 0.1471115878 0
235 39 0.0012019231 34.2777777778 2.7824144309 0.1548525938 0
241 32 0.0012019231 34 2.5980762114 0.1639074825 2
247 36 0.0012019231 34.125 2.6299556397 0.1743686693 0
250 30 0.0012019231 34 2.6726124191 0.1864025534 2
253 37 0.0012019231 34.2857142857 2.5246042014 0.2000700867 0
254 37 0.0012019231 34.0769230769 2.4987176198 0.2156133206 2
256 34 0.0012019231 33.8333333333 2.4432963328 0.2343887894 0
258 33 0.0012019231 33.8181818182 2.5619594774 0.2553882227 0
265 31 0.0012019231 33.9 2.6853512081 0.2803147817 0
266 35 0.0012019231 34.2222222222 2.6352313835 0.3118059076 0
277 32 0.0012019231 34.125 2.7998724461 0.3535098263 1
278 31 0.0012019231 34.4285714286 2.8784916685 0.4081060051 1
284 34 0.0012019231 35 2.683281573 0.4804832958 0
287 38 0.0012019231 35.2 2.9495762408 0.5498888777 0
291 37 0.0012019231 34.5 2.8867513459 0.589255651 0
293 32 0.0012019231 33.6666666667 2.8867513459 0.7349309197 0
299 37 0.0012019231 34.5 3.5355339059 1.25 0
300 32 0.0012019231 32 ERROR:#DIV/0! ERROR:#DIV/0!
AVERAGE MEAN= 34.91381132