i need only 22 task to be done

this is the answer for 21

Exercise 21 Assume you work for a restaurant in Almaty, Kazakhstan. As a manager you need to deal with customer complaints to increase customer satisfaction. Over the past several months you have collected data from customers. This data is presented below: Comments Frequency Long wait Cold food Bad food Wrong food Bad server Bad table Room temperature Too expensive No parking Wrong change 18 Other Use the data to construct a Pareto chart and identify "vital few" and "useful many" causes in Excel. 48 9 11 19 24 8 15 11 14 4 Exercise 22 Using the information from exercise 21 and your own knowledge of meetings, etc. develop the Fishbone diagram Solution: Q21: The Pareto chart for the given data is shown below, Restaurant Complaints 300N SO ON 20 50 ON 20 SON BON Long wat Badserver Wrong food Room Teme No Porting Blue S As we can see that roughly 80% of the total complaints are from three categories that form 55% of the total number of categories. Hence, Vital few categories that cause the most numbers of complaints are Long wait, bad server, wrong food & change. And, Useful many include the other complaint categories. These are useful many because they do not have a huge volume of complaints but are higher in number because of a large base of categories. **I am bound by Chegg policy to solve only the first question in a group of unrelated questions**