Create a Pareto chart based on the information in the following table. First, cr
ID: 2456346 • Letter: C
Question
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 Web site and check your entries so your resulting chart looks similar to the one in Figure 8-7. See the companion Web site for help in creating Pareto charts.
Figure 8-7
Customer Complaints Frequency/Week
Customer is on hold too long 90
Customer gets transferred to wrong area or cut off 20
Service rep cannot answer customer's quesiton 120
Service rep does not follow through as promised 40
Explanation / Answer
Customer Complaints Complaint Frequency/week Cumulative Count Cumulative % Service rep cannot answer customer's quesiton 120 120 44.44 Customer is on hold too long 90 210 77.78 Service rep does not follow through as promised 40 250 92.59 Customer gets transferred to wrong area or cut off 20 270 100.00