1 Put the data into a Pareto table that shows the actual numbers of defects, the percentages and cumulative percentages. From this table, compile a Pareto Graphthal includes the cumulative percent line for the monthly Reed Log of the Assembly Process Use formulas for all calculations. Ensure that your tables and graphs are correctly labelled as well as both axes. Ensure they are property formatted (5 marks) 2 Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Parelo Chart using the monthly reject data Arun chart will have the date on the X axis and the number of daily defects on the Y axis. In summary, a chart for each of the top 2 defects (2 charts required) (5 marks) 3. Include one Text box in which you provide your TWO recommendations for Faucot City in order to improve their Quality Problems Consider what you have learned in our unit on Quality Maximum one paragraph each. (5 marks) Chrome Chipped Monthly Records May M Sharp Washer Ayun Won le valve 1 1 1 2 1 1 1 2 3 1 2 1 2 1 1 4 1 2 1 1 1 2 1 3 1 1 1 1 5 11 5 10 11 12 1 2 1 1 2 4 1 2 2 1 2 2 SE 1 2 1 1 10 17 2 3 1 1 2 IH 19 20 1 1 1 2 2 1 1 2 1 1 2 1 2 1 24 T 2 1 2 2 1 26 27 50 2 4 3 2 2 2 4 1 31 2 Description: Hoses are purchased from a supplier, but cut to fit each faucet Chrome Chipped the metal exteriors are purchased from a supplier Washers purchased from a supplier, and installed in each assembly Sharp Edges - sometimes found on the chrome metal exterior of the purchased itemis Valves purchased from an outside supplier Strainer each model has a different strainer, this is purchased item, installed at Faucet ty