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 as attached, and check your entries so your resulting chart looks similar to the figure in the SoftChalk lesson.

Submit the completed Excel file through this assignment.

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$