(a) Use Excel to prepare a Pareto chart of the following data.
(b) Which three complaint categories account for approximately 80 percent of all complaints?
(c) Which category should the telephone company focus on first?

Transcribed Image Text:

Telephone Company Service Complaints, n Customer Complaints 791 Frequency Percent Wait too long Service person rude Difficult to reach a real person Service person not helpful Automated instructions confusing Customer service phone number hard to find Automated voice annoying 350 187 90 85 45 21 13 44.2% 23.6% 1 1.4% 10.7% 5.7% 27% 1.6%