Question: Question Three A pizza outlet advertises that its average waiting time is 12 minutes from the time an order is placed. A random sample of
Question Three
A pizza outlet advertises that its average waiting time is 12 minutes from the time an order is placed. A random sample of waiting times (in minutes) for 15 orders was recorded, and is shown here: 19 22 16 18 14 13 11 15 12 10 16 19 14 13 13
a) Assuming that waiting times are normally distributed, use Excel to determine whether this sample provides sufficient evidence to support the pizza outlet's advertisement. Please support your answer with a formal hypothesis test.
b) Use Excel to calculate a confidence interval for waiting time at this pizza outlet.

Degrees of Freedom Degrees of Freedom BIDE 31.821 63.657 29 1.311 2.045 2.462 2.756 1.868 2.920 4.303 6.985 9.925 30 1.310 1.897 2042 2.457 2.750 1.638 2.353 3.182 4.541 5841 35 1.306 1.680 2.030 2.724 1.533 2132 2 776 3747 40 1.303 1.684 2.021 2.423 2.704 1.476 2015 2 571 MEE 4.032 45 1.301 1.679 2.014 2412 2.680 1.440 1943 2.447 3.143 3.707 50 1.299 1.876 2.009 2403 2.878 1.415 1.895 2.980 68DE 55 LEZ'L 2.608 1.397 1.860 2.308 2 896 3.355 1.296 1.871 2.000 2 390 2.860 1.383 1.833 2.262 2.821 3.250 1.069 LEB'L 2 385 2.654 1.372 1.812 2.22B 2.764 70 1.667 1.994 2.381 2.848 11 1.383 2.201 2.718 3.108 75 1.865 286'L 2377 2.643 12 1.358 1.782 2.179 2.681 3.065 BO 1.292 1.864 1.990 2.374 2.839 13 1.350 1.771 2160 2.650 3.012 1.863 1.988 2371 2.836 14 1.345 1.761 2145 2.624 2.977 90 1.291 1.662 1.987 235B 2.632 1.341 1.753 2.131 2 602 2947 95 1861 1.985 2386 2.829 16 1.337 1.746 2.120 2.583 2921 100 1.290 1.660 1.984 2.354 2.626 17 1,333 2110 2.567 2.898 110 1.982 2381 2.621 18 1.330 1.734 2.101 2.502 2.878 120 1.289 1.658 2358 2.617 19 1.328 1.729 2.093 2.539 130 1.857 1.978 2 355 2.614 20 1.325 1.725 2.086 2.528 2.845 140 1.288 1.656 2.611 21 1.323 1.721 2.080 2518 2 831 150 1.855 1.976 2 351 2.809 22 1.321 1.717 2 074 2.819 160 1.287 1.654 1.975 2.350 2.607 23 1,319 1.714 2.089 2500 2.807 170 1.287 1.974 2348 2.805 24 1.318 1.711 2.064 2.482 2.797 180 1.206 1.653 1.973 2347 2.603 25 1.316 1.708 2.080 2.485 190 1 286 1.853 1.973 2 348 2.602 26 1.315 1.708 2.056 2.479 2.779 200 1.653 1.972 2345 2.601 27 1.314 1.703 2.052 2.473 1.282 1.980 2.326 2.576 2B 1.313 1.701 2.048 2.467 2.763
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
