Chapter8 - exercise2

Questions:

Create a Pareto diagram based on the information in the table below. First, create a spreadsheet in Excel, using the data in the table below. List the most frequent customer problems 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.

Answers:

See the Figure 1. Pareto Diagram.

Figure 1. Pareto Diagram

References

1. Schwalbe, K. (2006). Information technology project management (4^th ed.). Boston Massachusetts: Thomson Course Technology.