AutoSave of H2 Basic: Tools Exercise - Excel Search A simran rajbhandari SK Formulas Data Review View Help Share Comments Data Analysis File Home Insert Draw Page Layout 9 h From Text/csv Recent Sources La From Web Existing Connections Get Data From Table/Range Get B. Transform Data TI Steck: Queries & Connections E Properties Refresh AllFdit links Queries & Connections 21 ALY Z - Group Ungroup Subtotal Geography Sort Reapply Artvanced Filter Text to Columns What-it Forecast Analysis Sheet Data Types Sort Filter Data Tools Forecast Cutline Anstais A K20 fi 1 M N P R 5. T V - B C EF H 1 You are the manager for the restaurant and you have been collecting customer complaints and have decided it is time to take action 2 Make a Pareto chart to determine which problems are meeting the 80/20 rule (80% of problems come from 20% of cases) 3 Count 27 789 55 9 15 30 12 109 45 621 4 5 Complaint 6 too noisy 7 overpriced 8 taste 9 food not fresh 10 food too salty 11 not clean 12 unfriendly staff 13 wait time 14 lack of atmosphere 15 small portions 16 17 18 19 20 21 22 23 24 25 26 27 28 79 Pareto Scatterplot Check Sheet Control Chart I listogram Cause and Cllect Diagam Flow Chart + Reed 1005