2.) Create a Pareto chart based on the information in the following table. First, create a spreadsheet in excel using the data in the table. List the most frequent customer problems first. Use the excel template called pareto_chat.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 assistance creating the chart, search for videos describing how to create Pareto charts using Excel.

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 questions	120
Service rep does not follow through as promised	40