Spicy Wings Case, statistics homework help

Anonymous

Question Description

Purpose of Assignment

The purpose of this assignment is to develop students' abilities to combine the knowledge of descriptive statistics covered in Weeks 1 and 2 and one-sample hypothesis testing to make managerial decisions. In this assignment, students will develop the ability to use statistical analysis and verify whether or not a claim is valid before advertising it.

Assignment Steps

Resources: Microsoft Excel®, Spicy Wings Case Study, Spicy Wings Data Set

Develop a minimum of 700-word (no more than 750 words) statistical analysis.

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.

Submit 2 files:

1. word document paper,

2. Excel file showing all the word and calculations done

At least 2 references and in text citation

NOTE: Attached files are the resources to start and finish this assignemnt.

Unformatted Attachment Preview

Purchase answer to see full attachment

bassi
School: Purdue University

Attached.

1

Spicy Wings Case
Name
Institution Affiliation

2

Descriptive Statistics
N

Minimum

Maximum

Mean

Std. Deviation Skewness

Kurtosis

Statistic

Statistic

Statistic

Statistic

Statistic

Statistic

Std. Error Statistic

Std. Error

PickupTime

200

.00

7.63

3.6109

1.97170

-.713

.172

-.383

.342

DriveTime

200

3.30

28.15

18.9117

4.35610

-.494

.172

.251

.342

200

8.75000000000 31.9000000000 22.5226000000 4.87412935041 -.523

.172

.025

.342

TotalTime
0100

00100

00107

9835

Valid N (listwise) 200

Interpretation of output from the descriptive statistics
The population size N is 200 for all the factors considered.
The range of the pickup Time is from 0.00 minutes to 7.63 minutes with a mean of 3.6109 minutes and a standard deviation of
1.97170. The variable is negatively skewed (-0.713) indicating the presence of pickup Times above mean (3.6109). The distribution among
the sample is negatively peaked (-0.383) indicating that the pickup Time does not cluster around the center, (Samuels et al, 20...

flag Report DMCA
Review

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors