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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!