Question: 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

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 ii of patients with issues reported. (LE. is there a relationship between # of Patients with issues vs. Total # 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 variables? Why or why not? Regression Analysis: Perform one additional regression analysis between the ii 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? Pareto: Develop a Pareto chart for the type of issues that have occurred. Fishbone: For the issue with the highest frequency (from 0.3), develop an Ishikawa (shbone) diagram to generate ideas as to why this issue may occur. Your diagram must contain at least two (2) ideas per cause category. Recommendation: Based on your analysis developed from Questions 1, 2, 3 and 4, develop two (2) specific recommendations for the improvement team
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
