AutoSave OFF Home Insert Draw Page Layout G X Calibri (Body) Paste B I U A2 fx Complaint Type A B 5690S 7 Chain Defect Label Position Glass Chip 8 Dented Cover 9 Sharp Edge 10 Paint Scratch 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 36 37 38 39 40 vlasialava (version 1).xlsb - Auto Recovered Formulas Data Review View Tell me Share Comments 12 ab Wrap Text General > A Merge & Center $ % 9 .00 .00 0 Conditional Format Formatting as Table Cell Styles Insert Delete Format Sort & Filter Find & Select Analyze Data C D E F G H K L M N P Q 1 1. Perform a Pareto Analysis for the monthly Reject Log of the Assembly Process based on the total number of rejects from each category. Include a text box that explains the course of action that should be taken by Jen Davis. Ensure that you provide the Pareto Table and Chart. 2 Complaint Type Number of complaints Cumulative Number Cumulative percent 3 Plug Defect 4 Hose Length Complaint Type Sheet3 Sheet1 Sheet2 Ready 57 57 28% 52 109 54% 31 140 69% 19 159 79% 15 174 86% 13 187 93% 10 5 197 202 98% 100% 60 60 57 50 40 40 30 30 20 20 10 10 0 Plug Defect Hose Length 52 Chain Defect 31 100% 90% 80% 70% 60% 50% 40% 30% 19 15 20% 13 10 10% 5 0 0 0% Label Position Glass Chip Dented Cover Sharp Edge Paint Scratch 2. Draw a Run Chart... 35 2. Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Pareto Chart, using the monthly reject data. These charts should plot each day's rejects by department. In summary, one chart for the highest defect, and one chart for the second highest defect. Plot each department's daily rejects. Count: 4 |B + 90% R S T