Please show me step by step how to calculate in Excel.

Perform a Pareto analysis on the following information:

Provide a Pareto chart for the information below. (A Pareto chart includes a bar graph with reasons in descending order and a line graph showing the cumulative percentage)

1. What is the fewest number of reasons that if addressed would eliminate at least 80% of the unsatisfied stays at the hotel?
2. Identify the reasons, from part b, to be eliminated to address at least 80% of the reasons for unsatisfying stays.

Reason for unsatisfying stay at hotel	Frequency
Pool water is too cold	3
Elevator too slow or not working	3
No blanket for pull-out sofa	3
Room not ready at check-in	23
Breakfast of poor quality	33
No towels at the pool	5
Bill incorrect	4
Room not clean	4
Unfriendly staff	6
Took too long to register	16
Total	100