Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are asked to analyze the Customer Complaints at Drive Thru Restaurants. The data provides the # of Complaints by day by type. You are
You are asked to analyze the Customer Complaints at Drive Thru Restaurants. The data provides the # of Complaints by day by type. You are going to analyze this data using basic quality tools to begin to understand what is going on, what we should try to correct first, and if there are any relationships between the types of complaints.
Develop and provide a histogram for the number of complaints by category.
-
- The X axis will show the range of complaints per day and the Y axis will show the # of days that the complaints fell in that range for that category.
- Please use bin sizes of 0 to 3; 4 to 7; 8 to 11; etc. Please develop a histogram for each complaint category.
- Which categories appear to follow a normal distribution?
- Hint: You can use the "Data Analysis..." functions under your "Tools" menu. If you do not see this option, please click under "Add-In's" under your "Tools" menu.
Day | Long Line | Under Cooked | Over Cooked | Wrong Order |
Day 01 | 3 | 6 | 6 | 33 |
Day 02 | 8 | 9 | 10 | 38 |
Day 03 | 16 | 13 | 5 | 43 |
Day 04 | 15 | 15 | 6 | 45 |
Day 05 | 11 | 11 | 14 | 40 |
Day 06 | 13 | 11 | 13 | 41 |
Day 07 | 3 | 5 | 13 | 37 |
Day 08 | 10 | 10 | 20 | 38 |
Day 09 | 12 | 12 | 12 | 39 |
Day 10 | 15 | 14 | 12 | 42 |
Day 11 | 6 | 9 | 7 | 36 |
Day 12 | 10 | 9 | 8 | 36 |
Day 13 | 6 | 8 | 3 | 37 |
Day 14 | 14 | 14 | 6 | 45 |
Day 15 | 10 | 10 | 16 | 38 |
Day 16 | 11 | 11 | 16 | 40 |
Day 17 | 7 | 7 | 8 | 37 |
Day 18 | 15 | 13 | 7 | 45 |
Day 19 | 7 | 10 | 13 | 39 |
Day 20 | 12 | 12 | 7 | 42 |
Day 21 | 13 | 12 | 48 | 41 |
Day 22 | 7 | 8 | 54 | 36 |
Day 23 | 16 | 14 | 50 | 46 |
Day 24 | 16 | 15 | 45 | 48 |
Day 25 | 6 | 8 | 44 | 37 |
Day 26 | 12 | 13 | 43 | 38 |
Day 27 | 15 | 17 | 45 | 43 |
Day 28 | 14 | 16 | 45 | 43 |
Day 29 | 20 | 17 | 42 | 50 |
Day 30 | 2 | 5 | 53 | 31 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started