Spicy Wings Case Use descriptive statistics to compute a measure of performance John can use to analyze his delivery performance

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.