Lakeside Hospital Food Service Analysis Report

A large Ontario Regional hospital conducted a survey from each patient that received meals with each lunch
and dinner meal served from Sept 2nd till Sept. 27th 2019.
Patients were asked to comment on the meal quality by filling out the questionnaire at the end of each meal. A
member of the Kitchen staff was responsible to record the patient responses. The data is below.
Use EXCEL to do an analysis on this data.
1.Complete a Pareto Chart and Graph for the total number of complaints from each category.
2.Complete a Fishbone Diagram to suggest possible causes for these complaints.
3.Insert a Text box with two paragraphs giving your top two recommendations on how to improve the service of
food to the patients at City Hospital.

Sample Solution