Case 2 - Gage St. Retirement Home Gage St. Retirement Home is trying to improve the patient experience by improving food services with tasty, Inviting patient meals. A questionnaire accompanies each meal served, asking the patient, among other things, to specify any Issues with the meals. A 100 patient sample of the survey results over the past 7 days produced the following data. Case Data Reason for Issue # of Food Patients Incorrect Day Temperature of Meal W 12 12 9 To identify the root cause of the issues, the Improvement team collected additional data from the same seven day period to analyze and determine patterns. Additional Data Total # # of Meals # of Kitchen Day of Meals with Dietary Staff on Served Restrictions Duty 1 478 147 24 2 710 154 34 3 687 182 32 754 187 33 738 125 32 6 704 200 35 7 765 185 3 OPER3215-Lean Concepts and Continuous Improvement / Statistics Assignment Based on the sample data from the previous page, prepare the following: 1. Regression Analysis: What could be the possible cause of the issues? With the additional data collected, develop three (3) sets of analysis to determine whether there is a relationship between the additional data collected and the total # of patients with issues reported. (LE. Is there a relationship between # of Patients with Issues vs. Totol # of Meals Served). For each analysis you must include: a. a scatter diagram (with trend line), b. a regression analysis (using Excel Data Analysis tool) c. a conclusion on whether or not there is a relationship. d. Does the scatter diagram and regression analysis depict a relationship between the warlables? Why or why not?' 2. Regression Analysis: Perform one additional regression analysis between the # of Patients with Issues and a calculation, using the additional data, which determines the amount of work of Kitchen staff per day. The analysis must include: a. a scatter diagram (with trend line), b. a regression analysis (using Excel Data Analysis tool) c. a conclusion on whether or not there is a relationship. d. Does the scatter diagram and regression analysis depict a relationship between the variables? Why or why not? 3. Pareto: Develop a Pareto chart for the type of issues that have occurred. 4. Fishbone: For the Issue with the highest frequency (from Q3), develop an Ishikawa (fishbone] diagram to generate ideas as to why this issue may occur. Your diagram must contain at least two [2) ideas per cause category.Case 2 - Gage St. Retirement Home Gage St. Retirement Home is trying to improve the patient experience by Improving food services with tasty, Inviting patient meals. A questionnaire accompanies each meal served, asking the patient, among other things, to specify any losues with the meals. A 100 patient sample of the survey results over the past 7 days produced the following data. Case Data Reason for Issue # of Food Incorrect of Meal To Identify the root cause of the issues, the Improvement team collected add tional data from the Hme seven day period to analyze and determine patterns. Additional Data Total # # of Meals # of Kitchen Day of Meals with Dietary Staff on Served Restrictions Duty 1 478 147 710 154 34 3 687 182 32 4 754 187 33 738 125 32 6 704 200 35 7 765 185 28