1. You are part of an executive guest house where in-house executive development program are conducted. You have received complaints from executives who have attended the programme this year. You want to improve the service but are not sure of where to begin or where to concentrate efforts. The data relating to complaints from executives are given in the table attached in excel sheet.

Make a Pareto diagram and explain the significance of the results obtained.

Complaints From Executives
Category	Number of Complaints	Percentage	Cumulative Percentage
Cockroaches	962	43.2	43.2
Room temperature	505	22.7	65.9
Lighting	350	15.7	81.6
Storage space	127	5.7	87.3
Stereo noise	97	4.4	91.7
Television broadcasting	83	3.7	95.4
Water	54	2.4	97.8
Towels	32	1.4	99.2
Furniture	15	0.8	100
TOTAL	2225