Book: Information Technology Management by Kathy Schwalbe

2. Create a Pareto chart based on the information in the following table. First, create a spread- sheet in Excel using the data in the table. List the most frequent customer problems first. Use the Excel template called pareto_chart.xls on the text's companion website and check your entries so your resulting chart looks similar to the one in Figure 8-7. If you need assis- tance creating the chart, search for videos describing how to create Pareto charts using Excel. 337 Customer Complaints Customer is on hold too long Customer gets transferred to wrong area or cut off Service rep cannot answer customer's questions Service rep does not follow through as promised Frequency/Week 90 20 120 40