CJ Industrial is a car manufacturer who wishes to review its product quality and improve throughput and manufacturing efficiency. The data provided is related to type of quality deviation observed during one month by the quality inspectors during the final inspection. After considering the data, advise the CJ Industrial by answering the following questions: 1) Using the COUNTIF function, provide a frequency table of the defects observed. (2) 2) Using a Pareto Analysis, identify the type of defects that make up 80% of the quality issues observed. (5) 3) Indicate on the graph the 80/20 principle and discuss and motivate where the quality team should focus their efforts to obtain the maximum amount of improvement