Spicy Wings QNT 561

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.