with steps and calculations please

2. At Plastics and Dashes, the team members working on the instrument panel warranty issue have decided to begin their investigation by creating a Pareto Chart. The subject of the chart or output variable is: Instrument panel warranty claims. They collected the different reasons customer have brought their cars for instrument panel warranty work. Cost information on instrument panel warranty is also available. The team decided to collect information for the preceding six months. The collected information is in the table below. a. Create a Pareto Chart by frequency using Excel and show with a line, arrow or similar the separation between the vital few problems and the trivial many (80-20 rule)) 5 b. Create a Pareto Chart by cost using Excel show with a line, arrow or similar the separation between the vital few problems and the trivial many. c. Analyze the charts and answer: 1. What is the problem that they must attack first? 2. Which Pareto Chart (frequency or cost) do you think is more relevant to this company? Explain