Assignment Question: 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, Spicy Wings Dataset, Final Quiz, One Sample t-Test Tutorial.
Assignment Steps -
Spicy Wings
Word Document - Respond to the following questions.
A. Provide an average total time required to deliver customer orders on football Saturdays.
B. Find the percent of the Saturday deliveries that exceeded 30 minutes that would result in a free order.
C. The probability that the total time to make a delivery takes more than 30 minutes.
D. Provide your recommendations that could help John improve his Saturday delivery times.
E. Use a t test, and the formal hypothesis testing process, to help John decide whether to offer the delivery guarantee. Use the one-sample t-test tutorial.
Excel Document - Show the cell calculations.
Attachment:- Data Set.rar