Exercise 8

Schwalbe P.330 - Chapter 8, Ex 2

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.

Pareto Diagram

Reference

Schwalbe, K. (2006). Information Technology Project Management (4th ed.). Boston, Massachusetts: Thomson Course Technology.