I-need-help-with-my-QNT-561-Week-5-Team-Assignment
Spicy Wings Case
-
- Due Nov 6, 6:00 PM (PST
- Not Submitted
- POINTS 5
- Team Case Study
- no new messages
Objectives:
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 managerial report.
Note: pay special attention to your reporting, even of an excel sheet. Treat it as a report you are submitting to a coleague or supervisor who is infinitely ignorant and infinitly intelligent. Do not let the reader “pick and choose” the relevant parts. Include only what is relevant, in a crystal clear fashion.
Click the Assignment Files tab to submit your assignment.
Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Not all students may receive the same grade for the team assignment. See instructor’s policies document and week 6 team participation and contribution assignment for details.
Faculty Materials
Materials
- Spicy Wings Case Grading Guide
- Spicy Wings Case Study
- Spicy Wings Data Set
- Spicy Wings Case Grading Guide