Need help with parts (a) to (g) on this homework problem. Make sure the answers are lengthy. Also, make sure your handwriting is neat and readable. Below the homework problem is a screenshot of an excel spreadsheet with data for this problem. If there is one thing engineers like, it is a good pizza that is delivered in a timely manner. A particular pizza chain is thinking about offering a guarantee of “less than 30 minutes, or it’s free” on all of its deliveries. If the pizza business can pull this off, they will impress customers across the nation, but having to walk this promise back would be devastating to the reputation of the business. However, the CEO will not green light this policy if it means taking a substantial hit to profits. Accounting has run some numbers, and they have determined that the business can only miss 5% of all deliveries before the costs of the missed deliveries begin to impact profitability. The CEO agrees to a pilot test. 120 drivers time their deliveries with a stopwatch and log them in a spreadsheet. The CEO then sends this spreadsheet to you for analysis. Using all of the technical terms and symbols that you want: (a) Should the pizza chain implement this policy? (b) Create a graphic that visually represents the shape of the distribution well. (c) Describe the level of information contained by the data (e.g., nominal, discrete, etc.). (d) Describe the distribution of the data in detail (shape, center, spread, skew, kurtosis, etc.). We have not covered how to formally calculate all of these numbers, and that is fine – a verbal description will be sufficient in these cases. (e) Now that you have the details of the distribution, how did the distribution impact your analysis? (f) Would the analysis have been better/easier/different if the data followed a different shape? (g) In your professional opinion, should any of the data points be removed? Give a bit of color regarding the ethics of your decision. Are we throwing out the data just because we want to see better symmetry and make the math cleaner, or can we actually provide some justification for why the data should be removed? Would such a removal change your decision of the business case? Here is the data from the Excel spreadsheet Delivery Time 20.58 19.2 26.79 27.86 20.95 18.12 20.41 20.68 18.47 18.73 30.01 19.8 18.34 18.15 21.49 21.28 19.57 19.59 20.94 21.09 25.94 21.07 20.16 20.38 18.42 19.77 20.35 20.72 23.88 20.98 18.94 20.41 20.17 20.68 18.91 21.34 19.99 20.03 18.77 20.04 21.33 31.04 20.77 32.01 20.41 21 20.55 22.69 29.55 20.97 19.38 18.88 19.26 21.51 20.26 20.84 20.1 21.86 21.66 20.24 20.22 20.27 18.24 20.85 18.55 21.31 19.14 29.85 19.1 18.72 20.36 18.66 20.72 21.95 18.22 21.28 20.27 18.94 18.31 20.62 19.15 18.77 32.67 19.51 19.23 20.2 20.53 20.4 20.03 20.77 33.44 22.02 22.1 19.47 18.9 18.86 19.08 20.46 21.21 21.12 21.69 50.03 23.86 20.49 27.46 21.9 20.11 18.01 29.08 24.13 23.49 24.15 23.94 26.32 28.62 25.56 23.92 24.65 23.54 19.37
Need help with parts (a) to (g) on this homework problem. Make sure the answers are lengthy. Also, make sure your handwriting is neat and readable. Below the homework problem is a screenshot of an excel spreadsheet with data for this problem.
If there is one thing engineers like, it is a good pizza that is delivered in a timely
manner. A particular pizza chain is thinking about offering a guarantee of “less
than 30 minutes, or it’s free” on all of its deliveries. If the pizza business can pull
this off, they will impress customers across the nation, but having to walk this
promise back would be devastating to the reputation of the business. However,
the CEO will not green light this policy if it means taking a substantial hit
to profits. Accounting has run some numbers, and they have determined that
the business can only miss 5% of all deliveries before the costs of the missed
deliveries begin to impact profitability. The CEO agrees to a pilot test. 120
drivers time their deliveries with a stopwatch and log them in a spreadsheet.
The CEO then sends this spreadsheet to you for analysis.
Using all of the technical terms and symbols that you want:
(a) Should the pizza chain implement this policy?
(b) Create a graphic that visually represents the shape of the distribution
well.
(c) Describe the level of information contained by the data (e.g., nominal,
discrete, etc.).
(d) Describe the distribution of the data in detail (shape, center, spread, skew,
kurtosis, etc.). We have not covered how to formally calculate all of these
numbers, and that is fine – a verbal description will be sufficient in these
cases.
(e) Now that you have the details of the distribution, how did the distribution
impact your analysis?
(f) Would the analysis have been better/easier/different if the data followed a different shape?
Give a bit of color regarding the ethics of your decision. Are we throwing
out the data just because we want to see better symmetry and make the
math cleaner, or can we actually provide some justification for why the
data should be removed? Would such a removal change your decision of
the business case?
Delivery Time |
20.58 |
19.2 |
26.79 |
27.86 |
20.95 |
18.12 |
20.41 |
20.68 |
18.47 |
18.73 |
30.01 |
19.8 |
18.34 |
18.15 |
21.49 |
21.28 |
19.57 |
19.59 |
20.94 |
21.09 |
25.94 |
21.07 |
20.16 |
20.38 |
18.42 |
19.77 |
20.35 |
20.72 |
23.88 |
20.98 |
18.94 |
20.41 |
20.17 |
20.68 |
18.91 |
21.34 |
19.99 |
20.03 |
18.77 |
20.04 |
21.33 |
31.04 |
20.77 |
32.01 |
20.41 |
21 |
20.55 |
22.69 |
29.55 |
20.97 |
19.38 |
18.88 |
19.26 |
21.51 |
20.26 |
20.84 |
20.1 |
21.86 |
21.66 |
20.24 |
20.22 |
20.27 |
18.24 |
20.85 |
18.55 |
21.31 |
19.14 |
29.85 |
19.1 |
18.72 |
20.36 |
18.66 |
20.72 |
21.95 |
18.22 |
21.28 |
20.27 |
18.94 |
18.31 |
20.62 |
19.15 |
18.77 |
32.67 |
19.51 |
19.23 |
20.2 |
20.53 |
20.4 |
20.03 |
20.77 |
33.44 |
22.02 |
22.1 |
19.47 |
18.9 |
18.86 |
19.08 |
20.46 |
21.21 |
21.12 |
21.69 |
50.03 |
23.86 |
20.49 |
27.46 |
21.9 |
20.11 |
18.01 |
29.08 |
24.13 |
23.49 |
24.15 |
23.94 |
26.32 |
28.62 |
25.56 |
23.92 |
24.65 |
23.54 |
19.37 |
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 2 images