spicy wings case word document and excel data set
Currently I am in a challenging graduate master’s level statistics course and being that statistics is not a strong area in math for me, would greatly appreciate the help on the following:
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.
Resources: Microsoft ExcelÂ®, Spicy Wings Case Study, Spicy Wings Data Set (both the case study and data set are attached)
Develop a 700-770-word statistical analysis. (Do not exceed word count of 10%, excluding cover and reference page wording).
Use descriptive statistics to compute a measure of performance John can use to analyze his delivery performance. Find the following for your measures: (Excel data set is attached) Also, please help explain step-by-step instructions on how to obtain those following statistical data as I am not all that familiar with statistical functions on Excel.
- 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 (To use for the 700-770 word statistical analysis):
- 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, include APA citations and references with “direct web links”.
No Plagiarism and will be checked!
Click the Assignment Files tab to submit your assignment.