Assignment2, Chapter 8, Exercise 2

Chapter 8, Exercise 2

Create a Pareto Diagram based on the information in the table below। First, create a spreadsheet in the Excel, using the data in the table below। List the most frequent customer problem first। Add a column called “% of Total” and another one called “cumulative %”। Then enter formulas to calculate those items। Next, use the Excel Chart Wizard to create a Pareto diagram based on this data। Use the line-Column on 2 Axis custom type chart so your resulting chart looks similar to the one in figure 8-1.

Ans:According to the given information,Pareto Diagram is constructed. A table with a % of Total and cumulative % column is also included. Pareto Diagram is a way to identify the quality problem in the system. It is also sometimes reffered as 80-20 rule, that means 80% of the problem is due to the 20% of the causes. This pareto diagram will help to identify and priotize the problems