Spicy Wings Case
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 700-word 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.
Click the Assignment Files tab to submit your assignment.
Please follow grading guide.
20171107172759qnt561_r9_spicy_wings_case_study_week_5__1_
20171107172800qnt561_r9_lta_spicy_wings_case_grading_guide_week5
20171107172800qnt561_r9_spicy_wings_dataset_week5_lta
Solution Preview
From the primary descriptive statistical analysis to calculate a degree of performance, the mean and standard deviation were found to be 22.5226, 4.874129. These figures are based on total delivery time (in minutes) to gauge performance. The sample size is 200.
The study also wanted to find out about the minimum, first quartile, median, third quartile, and maximum as far as performance is concerned, this had to be computed from the total delivery time (pick-up time + drive time).
(799 words)