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:MeanStandard deviationSample sizeFive-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. Click the Assignment Files tab to submit your assignment. Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment.Ken ,Black. (2016). Business Statistic For contemporary Decision Making 9th Editionhttps://library.phoenix.edu/Phoenix Feel free to use more than one reference. Cannot accept more than 5% of plagiarismThis professor is super annoying and strict, so please be aware of that.Use grading guide attached and documents to help support the paper.