Description
I just need the the bold parts, 175 word each.
This is a team assignment, i have attached what we have so far.
Use descriptive statistics to compute a measure of performance John can use to analyze his delivery performance. Find the following for your measures:
- Mean
- Standard deviation
- Sample size
- Five-number summary on the total time
Conduct a formal hypothesis testing to help John decide whether to offer the delivery guarantee or not.
Estimate the probability of an order taking longer than 30 minutes.
Make a recommendation in a short narrative including the following:
- Based on the sampled data, should John offer the guarantee?
- What percent of the Saturday deliveries would result in a customer receiving a free order?
- What recommendations might help John improve his Saturday delivery times?
Format your assignment consistent with APA format
Unformatted Attachment Preview
Pick-up Time
4.94
0
4.98
5.03
4.15
4.67
5.01
3.88
2.8
2.71
2.79
4.73
5.2
4.18
5.57
2.73
4.4
0
3.41
4.16
3.6
5.45
0
3.96
4.54
0
4.21
3.22
0
5.55
6.35
5.14
6.11
3.95
4.54
2.23
4.99
4.83
5.03
3.56
5.15
5.69
3.59
3.39
2.77
Drive Time Total Time
26.96
31.9
21.73
21.73
19.74
24.72
20.08
25.11
19.04
23.19
16.17
20.84
14.93
19.94
23.92
27.8
17.15
19.95
20.97
23.68
25.83
28.62
15.41
20.14
15.53
20.73
17.02
21.2
23.2
28.77
18.19
20.92
20.94
25.34
17.46
17.46
16.33
19.74
22.54
26.7
23.52
27.12
3.3
8.75
22.87
22.87
18.31
22.27
24.82
29.36
13.22
13.22
19.64
23.85
14.11
17.33
23.69
23.69
15.04
20.59
21.59
27.94
10.81
15.95
20.46
26.57
15.56
19.51
22.54
27.08
25.29
27.52
22.81
27.8
23.45
28.28
21.01
26.04
21.94
25.5
24.63
29.78
24.13
29.82
15.52
19.11
28.15
31.54
22
24.77
Column A, Pick
minutes) a packaged o
up by a delivery driver.
Column B, Drive Time,
minutes) required to de
the customer after it ha
driver.
Column C, Total Time,
Pick
0
4.25
3.97
3.1
4.13
3.81
0
3.95
5.97
4.1
4.21
3.83
3.93
4.74
0
5.61
3.8
4.46
3.7
6.06
4.83
3.16
2.5
5.63
4.41
5.26
0
3.26
5.12
5.07
0
4.14
4.75
3.67
3.02
3.47
3.3
2.77
3.2
0
0
6.27
6.4
4.67
3.41
0
4.25
15.34
20.36
13.7
21.92
22.73
16.73
21.96
16.91
22.25
18.49
14.76
24.01
8.64
20.57
17.59
20.93
17
23.17
13.58
14
17.44
21.92
20.87
7.43
13.93
20.01
19.71
19.72
17.72
19.5
16.47
18.78
15.99
24.15
24.52
18.5
18.96
17.92
11.21
22.32
15.2
17.14
16.06
24.99
12.83
20.75
19.33
15.34
24.61
17.67
25.02
26.86
20.54
21.96
20.86
28.22
22.59
18.97
27.84
12.57
25.31
17.59
26.54
20.8
27.63
17.28
20.06
22.27
25.08
23.37
13.06
18.34
25.27
19.71
22.98
22.84
24.57
16.47
22.92
20.74
27.82
27.54
21.97
22.26
20.69
14.41
22.32
15.2
23.41
22.46
29.66
16.24
20.75
23.58
4.61
4.41
5.31
2.76
4.64
4.31
4.39
0
4.93
5.14
0
6.36
2.99
3.11
3.52
2.97
2.62
5.59
5.08
4.02
0
4.93
0
0
6.44
5.01
4.41
7.63
0
5.53
4.87
0
0
3.83
5.63
0
0
4.7
0
3.68
5.36
0
0
5.59
5.93
2.86
3.6
17.87
18.95
23.54
15.15
23.23
21.95
22.47
11.58
20.03
13.06
17.48
19.89
17.26
14.13
21.42
24.67
26.47
21.36
21.29
17.99
25.58
14.15
16.34
12.29
21.97
24.75
13.92
19.18
17.15
11.83
21.49
10.82
18.62
8.91
23.38
17.37
8.9
12.29
27.79
18.96
21.22
19.49
19.52
21.25
16.09
19.37
17.12
22.48
23.36
28.85
17.91
27.87
26.26
26.86
11.58
24.96
18.2
17.48
26.25
20.25
17.24
24.94
27.64
29.09
26.95
26.37
22.01
25.58
19.08
16.34
12.29
28.41
29.76
18.33
26.81
17.15
17.36
26.36
10.82
18.62
12.74
29.01
17.37
8.9
16.99
27.79
22.64
26.58
19.49
19.52
26.84
22.02
22.23
20.72
6.19
2.51
0
3.72
6.15
3.45
4.43
0
4.27
5.34
3.31
4.49
3.02
2.64
0
0
2.5
3.66
4.11
5.03
4.57
4.76
3.95
4.04
5.4
2.91
0
2.4
3.09
6.13
4.64
7.14
5.57
2.82
5.9
4.77
6.44
3.37
3.82
4.69
0
3.02
4.64
0
4.45
4.42
4.46
19.02
15.97
21.74
22.34
21.16
22.01
22.36
22.97
15
24.78
9.4
15.24
21.07
20.98
19.67
22.96
18.82
15.54
18.02
17.2
26.12
12.22
23.28
25.02
16.38
16.71
9.75
21.67
16.68
25.22
17.55
15.86
17.02
25.08
17.57
18.85
17.13
21.08
19.51
26.74
18.48
20.32
26.25
19.1
21.83
22.12
22.43
25.21
18.48
21.74
26.06
27.31
25.46
26.79
22.97
19.27
30.12
12.71
19.73
24.09
23.62
19.67
22.96
21.32
19.2
22.13
22.23
30.69
16.98
27.23
29.06
21.78
19.62
9.75
24.07
19.77
31.35
22.19
23
22.59
27.9
23.47
23.62
23.57
24.45
23.33
31.43
18.48
23.34
30.89
19.1
26.28
26.54
26.89
4.37
3.91
5.76
0
0
2.82
5.92
4.94
5.87
4.07
7.22
5.24
0
3.71
Mean:
Standard Deviation:
3.6109
1.971698039
21.01
12.04
13.02
11.39
19.78
17.14
19.84
19.92
19.49
22.32
16.59
15.48
10.6
18.4
25.38
15.95
18.78
11.39
19.78
19.96
25.76
24.86
25.36
26.39
23.81
20.72
10.6
22.11
18.9117
22.5226
4.35609803 4.8741294
# of measured attempts
# of actual attempts under a total of 30 minutes
Error rate
Sample Size (assuming 99% confidence level)
Sample Size (assuming 95% confidence level)
Sample Size (assuming 90% confidence level)
Median
Max Value
Minimum Value
First Quartile
Third Quartile
200
193
3.626943
43.465541
25.163179
17.724956
22.895
31.9
8.75
19.595
26.375
Column A, Pick-up Time, is the amount of time (in
minutes) a packaged order had to wait to be picked
up by a delivery driver.
Column B, Drive Time, is the amount of time (in
minutes) required to deliver the packaged order to
the customer after it has been picked up by the
driver.
Column C, Total Time, is the total amount of time.
Pick-upTime + Drive Time.
Pick-up Time
4.94
0
4.98
5.03
4.15
4.67
5.01
3.88
2.8
2.71
2.79
4.73
5.2
4.18
5.57
2.73
4.4
0
3.41
4.16
3.6
5.45
0
3.96
4.54
0
4.21
3.22
0
5.55
6.35
5.14
6.11
3.95
4.54
2.23
4.99
4.83
5.03
3.56
5.15
5.69
3.59
3.39
2.77
Drive Time Total Time
26.96
31.9
21.73
21.73
19.74
24.72
20.08
25.11
19.04
23.19
16.17
20.84
14.93
19.94
23.92
27.8
17.15
19.95
20.97
23.68
25.83
28.62
15.41
20.14
15.53
20.73
17.02
21.2
23.2
28.77
18.19
20.92
20.94
25.34
17.46
17.46
16.33
19.74
22.54
26.7
23.52
27.12
3.3
8.75
22.87
22.87
18.31
22.27
24.82
29.36
13.22
13.22
19.64
23.85
14.11
17.33
23.69
23.69
15.04
20.59
21.59
27.94
10.81
15.95
20.46
26.57
15.56
19.51
22.54
27.08
25.29
27.52
22.81
27.8
23.45
28.28
21.01
26.04
21.94
25.5
24.63
29.78
24.13
29.82
15.52
19.11
28.15
31.54
22
24.77
Column A, Pick
minutes) a packaged o
up by a delivery driver.
Column B, Drive Time,
minutes) required to de
the customer after it ha
driver.
Column C, Total Time,
Pick
0
4.25
3.97
3.1
4.13
3.81
0
3.95
5.97
4.1
4.21
3.83
3.93
4.74
0
5.61
3.8
4.46
3.7
6.06
4.83
3.16
2.5
5.63
4.41
5.26
0
3.26
5.12
5.07
0
4.14
4.75
3.67
3.02
3.47
3.3
2.77
3.2
0
0
6.27
6.4
4.67
3.41
0
4.25
15.34
20.36
13.7
21.92
22.73
16.73
21.96
16.91
22.25
18.49
14.76
24.01
8.64
20.57
17.59
20.93
17
23.17
13.58
14
17.44
21.92
20.87
7.43
13.93
20.01
19.71
19.72
17.72
19.5
16.47
18.78
15.99
24.15
24.52
18.5
18.96
17.92
11.21
22.32
15.2
17.14
16.06
24.99
12.83
20.75
19.33
15.34
24.61
17.67
25.02
26.86
20.54
21.96
20.86
28.22
22.59
18.97
27.84
12.57
25.31
17.59
26.54
20.8
27.63
17.28
20.06
22.27
25.08
23.37
13.06
18.34
25.27
19.71
22.98
22.84
24.57
16.47
22.92
20.74
27.82
27.54
21.97
22.26
20.69
14.41
22.32
15.2
23.41
22.46
29.66
16.24
20.75
23.58
4.61
4.41
5.31
2.76
4.64
4.31
4.39
0
4.93
5.14
0
6.36
2.99
3.11
3.52
2.97
2.62
5.59
5.08
4.02
0
4.93
0
0
6.44
5.01
4.41
7.63
0
5.53
4.87
0
0
3.83
5.63
0
0
4.7
0
3.68
5.36
0
0
5.59
5.93
2.86
3.6
17.87
18.95
23.54
15.15
23.23
21.95
22.47
11.58
20.03
13.06
17.48
19.89
17.26
14.13
21.42
24.67
26.47
21.36
21.29
17.99
25.58
14.15
16.34
12.29
21.97
24.75
13.92
19.18
17.15
11.83
21.49
10.82
18.62
8.91
23.38
17.37
8.9
12.29
27.79
18.96
21.22
19.49
19.52
21.25
16.09
19.37
17.12
22.48
23.36
28.85
17.91
27.87
26.26
26.86
11.58
24.96
18.2
17.48
26.25
20.25
17.24
24.94
27.64
29.09
26.95
26.37
22.01
25.58
19.08
16.34
12.29
28.41
29.76
18.33
26.81
17.15
17.36
26.36
10.82
18.62
12.74
29.01
17.37
8.9
16.99
27.79
22.64
26.58
19.49
19.52
26.84
22.02
22.23
20.72
6.19
2.51
0
3.72
6.15
3.45
4.43
0
4.27
5.34
3.31
4.49
3.02
2.64
0
0
2.5
3.66
4.11
5.03
4.57
4.76
3.95
4.04
5.4
2.91
0
2.4
3.09
6.13
4.64
7.14
5.57
2.82
5.9
4.77
6.44
3.37
3.82
4.69
0
3.02
4.64
0
4.45
4.42
4.46
19.02
15.97
21.74
22.34
21.16
22.01
22.36
22.97
15
24.78
9.4
15.24
21.07
20.98
19.67
22.96
18.82
15.54
18.02
17.2
26.12
12.22
23.28
25.02
16.38
16.71
9.75
21.67
16.68
25.22
17.55
15.86
17.02
25.08
17.57
18.85
17.13
21.08
19.51
26.74
18.48
20.32
26.25
19.1
21.83
22.12
22.43
25.21
18.48
21.74
26.06
27.31
25.46
26.79
22.97
19.27
30.12
12.71
19.73
24.09
23.62
19.67
22.96
21.32
19.2
22.13
22.23
30.69
16.98
27.23
29.06
21.78
19.62
9.75
24.07
19.77
31.35
22.19
23
22.59
27.9
23.47
23.62
23.57
24.45
23.33
31.43
18.48
23.34
30.89
19.1
26.28
26.54
26.89
4.37
3.91
5.76
0
0
2.82
5.92
4.94
5.87
4.07
7.22
5.24
0
3.71
Mean:
Standard Deviation:
3.6109
1.971698039
21.01
12.04
13.02
11.39
19.78
17.14
19.84
19.92
19.49
22.32
16.59
15.48
10.6
18.4
25.38
15.95
18.78
11.39
19.78
19.96
25.76
24.86
25.36
26.39
23.81
20.72
10.6
22.11
18.9117
22.5226
4.35609803 4.8741294
Column A, Pick-up Time, is the amount of time (in
minutes) a packaged order had to wait to be picked
up by a delivery driver.
Column B, Drive Time, is the amount of time (in
minutes) required to deliver the packaged order to
the customer after it has been picked up by the
driver.
Column C, Total Time, is the total amount of time.
Pick-upTime + Drive Time.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
See attached:)
Running head: SPICY WINGS
1
Spicy Wings
Name
Institution
Date
SPICY WINGS
2
Hypothesis test
Hypothesis test attempts to inform the researcher if the hypothesis or research claim is
true or not. In this scenario, the hypothesis test attempts to determine whether John ought to go
ahead and implement the delivery offer to the clients or not. In order to implement the strategy of
recapturing the market share, John should ensure that the average time of delivering the wings is
below or equal to 30 minutes. The hypothesis test can be conducted as follows (Ott &
Longnecker, 2015);
Formulating the null and alternative hypothesis
H0: µ ≤ 30
H1: µ > 30
Notably, the population standard deviation and the mean are not known. As such, the
right-tailed t-test is the most appropriate test to determine if the mean total time for delivering the
wings is less than thirty. The test statistic can be computed as follows;
𝑡=
µ − 30
s
√𝑛
Where s is represents the standard deviation for the sample, n represents the sample size,
and µ represents the sample mean. Using an alpha level of significance of 0.05, the formula
can be evaluated in the Excel to obtain the following results;
Hypothesis Test: Mean vs. Hypothesized Value
30 hypothesized value
22.523 mean Total Time
4.87 std. dev.
0.3447 std. error
SPICY WINGS
3
200 N
199 Df
-21.70
1.0
T
p-value (one-tailed, upper)
Notably, the test results indicate that the t-statistics = -21.7 resulting in a p-value of 1.
The p-value is larger compared to an alpha of 0.05 implying that there is n...
Review
Review
Anonymous
I was having a hard time with this subject, and this was a great help.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
Solve the logarithmic equation for x.
Solve the logarithmic equation for x.log x + log(x − 2) = log(2x)x = ...
Taylor Series
...
West Valley College Statistics Questions
In a random sample of 600 women, 30% favored stricter gun control legislation. In a random sample of 800 men, 25% favored ...
what is answer to this problem
2-63-124-205-30-6-429-????/...
Need help with Algebra Problem
Bob and Peter went for a walk. Bob began walking 20 seconds earlier than Peter. Bob walked at a speed of 5 feet per second...
CSUGC Customer Satisfaction Analysis of data Project
A1 Hotels operates luxury hotels throughout the world. Recently, motivated by some incidents that appeared in the news, th...
Solutions
The sample would be taken from members of my personal gym. I’ll stand by the gym entrance and I believe the sample accur...
W6 Project Assignment
For these project assignments throughout the course you will need to reference the data in the 1. For each of the 2 majors...
R Code Discussion
Firstly, we will see another way to count the crash as “very deadly”. For this, we will be considering the two variabl...
