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

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

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
 
 
 
 
 
 
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
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
A
Ready
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
>
(++)
#2 Vaccination
# 3 - Pizza
+
T
T
T
I
H
圓
Y
+ 50%
Transcribed Image Text: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 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 A Ready 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 > (++) #2 Vaccination # 3 - Pizza + T T T I H 圓 Y + 50%
A1
3
1 Deliver Time
2
4
5
6
8
9
10
11
12
13
14
16
17
18
20
21
22
23
24
25
26
28
30
31
33
34
35
37
38
39
41
42
43
45
46
47
49
50
51
53
54
55
56
57
58
59
60
61
File
62
63
66
67
68
69
AU
20.58
19.2
26.79
27.86
20.95
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
Home
Ready (+
B
Insert Page Layout
С
X
D
E
# 2 Vaccination
F
fx
G
Formulas Data
Delivery Time
H
# 3 - Pizza
I
+
J
K
Review
L
M
View
N
Help
0
P
Tell me what you want to do
Q
R
T
U
V
Y
z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AK
AL
AM
AN
B
II
AP
AQ
AR
AT
[
➤
V
4
50%
Transcribed Image Text:A1 3 1 Deliver Time 2 4 5 6 8 9 10 11 12 13 14 16 17 18 20 21 22 23 24 25 26 28 30 31 33 34 35 37 38 39 41 42 43 45 46 47 49 50 51 53 54 55 56 57 58 59 60 61 File 62 63 66 67 68 69 AU 20.58 19.2 26.79 27.86 20.95 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 Home Ready (+ B Insert Page Layout С X D E # 2 Vaccination F fx G Formulas Data Delivery Time H # 3 - Pizza I + J K Review L M View N Help 0 P Tell me what you want to do Q R T U V Y z AA AB AC AD AE AF AG AH AI AK AL AM AN B II AP AQ AR AT [ ➤ V 4 50%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON