23 Jan Develop a 700-word statistical analysis. Use descriptive statistics to compute a measure of performance John can use to anal
NO PLAGIARISM, MUST BE ORIGINAL WORK!!!!
THIS IS A 2 PART ASSIGHNMENT
PART 1 EXCEL SHEET, MUST COMPUTE ALL PROBLEMS USING EXCEL WITH APPROPRIATE FORMULAS IN CELLS TO SHOW HOW ANSWERS WERE RECEIVED.
PART 2 WORD DOCUMENT, DEVELOP A STATISTICAL ANALYSIS 700 MINIMUM
MUST INCLUDE AT LEAST 1 IN TEXT CITATIONS WITH ALL REFERENCES LISTED IN APA FORMAT
DO NOT INCLUDE QUESTIONS IN WORD DOCUMENT
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
|
Title ABC/123 Version X |
1 |
|
Case Study – Spicy Wings Case Study QNT/561 Version 9 |
1 |
University of Phoenix Material
Case Study – Spicy Wings Case Study
Following his graduation from the MBA program at the University of Phoenix, John Tyler wanted to live and work in the little town of Hood. However, the community was small and there were not a lot of readily available opportunities for college graduates. Fortunately, John had some experience working in the food service industry gained in summers and throughout high school at his uncle’s restaurant in Franklin, a few miles away from the town of Hood. When John decided to leverage his experience into a small delivery and take-out restaurant located close to his home, he thought he had hit on a great idea. John would offer a limited fare consisting of the buffalo wings his uncle had perfected at his restaurant. John called his restaurant, Spicy Wings. Although success came slowly, the uniqueness of John’s offering coupled with the growth of the community made Spicy Wings a success.
John’s business was pretty simple. John purchased wings locally. The wings were then seasoned and prepared in John’s restaurant. Once an order was received, John cooked the wings, which were then delivered or picked up by the customer. John’s establishment was small, and there was no place for customers to dine in the restaurant. However, his wings proved so popular that over time, John hired several employees, including three delivery drivers. Business was steady and predictable during the week, with the biggest days being home-game football Saturdays.
A little over a year ago, the little town of Hood began to grow and expand. John noticed his business was beginning to suffer when other fast-food delivery restaurants opened around the town. Some of these restaurants were offering guarantees such as “30 minutes or it’s free.” John’s Spicy Wings now had to compete with fish tacos, specialty pizzas, and gourmet burgers. Most of these new restaurants, however, were dine-in establishments providing carry-out and delivery as a customer convenience. However, John was certain he would need to offer a delivery guarantee to remain competitive with the newer establishments.
John was certain a delivery guarantee of “30 minutes or it’s free” could easily be accomplished every day except on football Saturdays. John thought if he could offer a 30-minute guarantee on his busiest day, he would be able to hold onto and perhaps even recover market share from the competition. However, before he was willing to commit to such a guarantee, John wanted to ensure that it was possible to meet the 30-minute promise.
John knew it would be no problem for customers to pick up orders within 30 minutes of phoning them in. However, he was less confident about delivering orders to customers in 30 minutes or less. Not only would the wings need to be cooked and packaged, but the delivery time might be affected by the availability of drivers. John decided he needed to analyze the opportunity further.
As a part of his analysis, John decided to take a random sample of deliveries over five different football weekends. Cooking time and packaging time were not considered in his analysis because wings were not cooked for individual orders. Rather, large numbers of wings were cooked at a single time and then packaged in boxes of 12. John decided to focus his analysis on the time required to deliver cooked and packaged wings. He collected information on the amount of time an order had to wait for a driver (the pick-up time), as well as the amount of time required to transport the wings to the customer (the drive time). The sampled information is in the Excel® file, Spicy Wings Data Set. John is not willing to offer the guarantee on football Saturdays, unless he can be reasonably sure the total time to deliver a customer’s order is less than 30 minutes, on average. John would also like to have an estimate of the actual time required to deliver a customer’s order on football Saturdays. Finally, John would like to know how likely it is the total time to make a delivery would take more than 30 minutes. 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?
Copyright © XXXX by University of Phoenix. All rights reserved.
Copyright © 2017 by University of Phoenix. All rights reserved.
,
Week 5 LT Collaborative Assign
| Pick-up Time | Drive Time | Total Time |
| 4.94 | 26.96 | 31.9 |
| 0 | 21.73 | 21.73 |
| 4.98 | 19.74 | 24.72 |
| 5.03 | 20.08 | 25.11 |
| 4.15 | 19.04 | 23.19 |
| 4.67 | 16.17 | 20.84 |
| 5.01 | 14.93 | 19.94 |
| 3.88 | 23.92 | 27.8 |
| 2.8 | 17.15 | 19.95 |
| 2.71 | 20.97 | 23.68 |
| 2.79 | 25.83 | 28.62 |
| 4.73 | 15.41 | 20.14 |
| 5.2 | 15.53 | 20.73 |
| 4.18 | 17.02 | 21.2 |
| 5.57 | 23.2 | 28.77 |
| 2.73 | 18.19 | 20.92 |
| 4.4 | 20.94 | 25.34 |
| 0 | 17.46 | 17.46 |
| 3.41 | 16.33 | 19.74 |
| 4.16 | 22.54 | 26.7 |
| 3.6 | 23.52 | 27.12 |
| 5.45 | 3.3 | 8.75 |
| 0 | 22.87 | 22.87 |
| 3.96 | 18.31 | 22.27 |
| 4.54 | 24.82 | 29.36 |
| 0 | 13.22 | 13.22 |
| 4.21 | 19.64 | 23.85 |
| 3.22 | 14.11 | 17.33 |
| 0 | 23.69 | 23.69 |
| 5.55 | 15.04 | 20.59 |
| 6.35 | 21.59 | 27.94 |
| 5.14 | 10.81 | 15.95 |
| 6.11 | 20.46 | 26.57 |
| 3.95 | 15.56 | 19.51 |
| 4.54 | 22.54 | 27.08 |
| 2.23 | 25.29 | 27.52 |
| 4.99 | 22.81 | 27.8 |
| 4.83 | 23.45 | 28.28 |
| 5.03 | 21.01 | 26.04 |
| 3.56 | 21.94 | 25.5 |
| 5.15 | 24.63 | 29.78 |
| 5.69 | 24.13 | 29.82 |
| 3.59 | 15.52 | 19.11 |
| 3.39 | 28.15 | 31.54 |
| 2.77 | 22 | 24.77 |
| 0 | 15.34 | 15.34 |
| 4.25 | 20.36 | 24.61 |
| 3.97 | 13.7 | 17.67 |
| 3.1 | 21.92 | 25.02 |
| 4.13 | 22.73 | 26.86 |
| 3.81 | 16.73 | 20.54 |
| 0 | 21.96 | 21.96 |
| 3.95 | 16.91 | 20.86 |
| 5.97 | 22.25 | 28.22 |
| 4.1 | 18.49 | 22.59 |
| 4.21 | 14.76 | 18.97 |
| 3.83 | 24.01 | 27.84 |
| 3.93 | 8.64 | 12.57 |
| 4.74 | 20.57 | 25.31 |
| 0 | 17.59 | 17.59 |
| 5.61 | 20.93 | 26.54 |
| 3.8 | 17 | 20.8 |
| 4.46 | 23.17 | 27.63 |
| 3.7 | 13.58 | 17.28 |
| 6.06 | 14 | 20.06 |
| 4.83 | 17.44 | 22.27 |
| 3.16 | 21.92 | 25.08 |
| 2.5 | 20.87 | 23.37 |
| 5.63 | 7.43 | 13.06 |
| 4.41 | 13.93 | 18.34 |
| 5.26 | 20.01 | 25.27 |
| 0 | 19.71 | 19.71 |
| 3.26 | 19.72 | 22.98 |
| 5.12 | 17.72 | 22.84 |
| 5.07 | 19.5 | 24.57 |
| 0 | 16.47 | 16.47 |
| 4.14 | 18.78 | 22.92 |
| 4.75 | 15.99 | 20.74 |
| 3.67 | 24.15 | 27.82 |
| 3.02 | 24.52 | 27.54 |
| 3.47 | 18.5 | 21.97 |
| 3.3 | 18.96 | 22.26 |
| 2.77 | 17.92 | 20.69 |
| 3.2 | 11.21 | 14.41 |
| 0 | 22.32 | 22.32 |
| 0 | 15.2 | 15.2 |
| 6.27 | 17.14 | 23.41 |
| 6.4 | 16.06 | 22.46 |
| 4.67 | 24.99 | 29.66 |
| 3.41 | 12.83 | 16.24 |
| 0 | 20.75 | 20.75 |
| 4.25 | 19.33 | 23.58 |
| 4.61 | 17.87 | 22.48 |
| 4.41 | 18.95 | 23.36 |
| 5.31 | 23.54 | 28.85 |
| 2.76 | 15.15 | 17.91 |
| 4.64 | 23.23 | 27.87 |
| 4.31 | 21.95 | 26.26 |
| 4.39 | 22.47 | 26.86 |
| 0 | 11.58 | 11.58 |
| 4.93 | 20.03 | 24.96 |
| 5.14 | 13.06 | 18.2 |
| 0 | 17.48 | 17.48 |
| 6.36 | 19.89 | 26.25 |
| 2.99 | 17.26 | 20.25 |
| 3.11 | 14.13 | 17.24 |
| 3.52 | 21.42 | 24.94 |
| 2.97 | 24.67 | 27.64 |
| 2.62 | 26.47 | 29.09 |
| 5.59 | 21.36 | 26.95 |
| 5.08 | 21.29 | 26.37 |
| 4.02 | 17.99 | 22.01 |
| 0 | 25.58 | 25.58 |
| 4.93 | 14.15 | 19.08 |
| 0 | 16.34 | 16.34 |
| 0 | 12.29 | 12.29 |
| 6.44 | 21.97 | 28.41 |
| 5.01 | 24.75 | 29.76 |
| 4.41 | 13.92 | 18.33 |
| 7.63 | 19.18 | 26.81 |
| 0 | 17.15 | 17.15 |
| 5.53 | 11.83 | 17.36 |
| 4.87 | 21.49 | 26.36 |
| 0 | 10.82 | 10.82 |
| 0 | 18.62 | 18.62 |
| 3.83 | 8.91 | 12.74 |
| 5.63 | 23.38 | 29.01 |
| 0 | 17.37 | 17.37 |
| 0 | 8.9 | 8.9 |
| 4.7 | 12.29 | 16.99 |
| 0 | 27.79 | 27.79 |
| 3.68 | 18.96 | 22.64 |
| 5.36 | 21.22 | 26.58 |
| 0 | 19.49 | 19.49 |
| 0 | 19.52 | 19.52 |
| 5.59 | 21.25 | 26.84 |
| 5.93 | 16.09 | 22.02 |
| 2.86 | 19.37 | 22.23 |
| 3.6 | 17.12 | 20.72 |
| 6.19 | 19.02 | 25.21 |
| 2.51 | 15.97 | 18.48 |
| 0 | 21.74 | 21.74 |
| 3.72 | 22.34 | 26.06 |
| 6.15 | 21.16 | 27.31 |
| 3.45 | 22.01 | 25.46 |
| 4.43 | 22.36 | 26.79 |
| 0 | 22.97 | 22.97 |
| 4.27 | 15 | 19.27 |
| 5.34 | 24.78 | 30.12 |
| 3.31 | 9.4 | 12.71 |
| 4.49 | 15.24 | 19.73 |
| 3.02 | 21.07 | 24.09 |
| 2.64 | 20.98 | 23.62 |
| 0 | 19.67 | 19.67 |
| 0 | 22.96 | 22.96 |
| 2.5 | 18.82 | 21.32 |
| 3.66 | 15.54 | 19.2 |
| 4.11 | 18.02 | 22.13 |
| 5.03 | 17.2 | 22.23 |
| 4.57 | 26.12 | 30.69 |
| 4.76 | 12.22 | 16.98 |
| 3.95 | 23.28 | 27.23 |
| 4.04 | 25.02 | 29.06 |
| 5.4 | 16.38 | 21.78 |
| 2.91 | 16.71 | 19.62 |
| 0 | 9.75 | 9.75 |
| 2.4 | 21.67 | 24.07 |
| 3.09 | 16.68 | 19.77 |
| 6.13 | 25.22 | 31.35 |
| 4.64 | 17.55 | 22.19 |
| 7.14 | 15.86 | 23 |
| 5.57 | 17.02 | 22.59 |
| 2.82 | 25.08 | 27.9 |
| 5.9 | 17.57 | 23.47 |
| 4.77 | 18.85 | 23.62 |
| 6.44 | 17.13 | 23.57 |
| 3.37 | 21.08 | 24.45 |
| 3.82 | 19.51 | 23.33 |
| 4.69 | 26.74 | 31.43 |
| 0 | 18.48 | 18.48 |
| 3.02 | 20.32 | 23.34 |
| 4.64 | 26.25 | 30.89 |
| 0 | 19.1 | 19.1 |
| 4.45 | 21.83 | 26.28 |
| 4.42 | 22.12 | 26.54 |
| 4.46 | 22.43 | 26.89 |
| 4.37 | 21.01 | 25.38 |
| 3.91 | 12.04 | 15.95 |
| 5.76 | 13.02 | 18.78 |
| 0 | 11.39 | 11.39 |
| 0 | 19.78 | 19.78 |
| 2.82 | 17.14 | 19.96 |
| 5.92 | 19.84 | 25.76 |
| 4.94 | 19.92 | 24.86 |
| 5.87 | 19.49 | 25.36 |
| 4.07 | 22.32 | 26.39 |
| 7.22 | 16.59 | 23.81 |
| 5.24 | 15.48 | 20.72 |
| 0 | 10.6 | 10.6 |
| 3.71 | 18.4 | 22.11 |
Column A, Pick-up Time, is the amount of time (in minutes) a packaged order had to wait to be picked up by a delivery driver. Column B, Drive Time, is the amount of time (in minutes) required to deliver the packaged order to the customer after it has been picked up by the driver. Column C, Total Time, is the total amount of time. Pick-upTime + Drive Time.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.