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 Excel, using the data in the table below. List the most frequent customer problems first. Add a column called “%” of Total and another 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 (Schwalbe, p. 330).

Reference

Schwalbe, K., (2006) – Information Technology Project Management – Fourth Edition – Cambridge, MA: Course Technology/Thompson Learning