Analyzing Low Patient Satisfaction at I-lerzog Hospital - HBR Case Number: KEL741 The data to be used in your analysis is presented in the Excel ie "Herzog Exhibit 1, Spreadsheet Supplement", Product #: KEL869-XLS-ENG, that is provided in conjunction with the case study. In late 2012 Adeline Herzog Memorial Hospital in Castle Rock, Colorado, was facing a problem with patient satisfaction. The Press-Ganey scores for the third- floor nursing unitthe primary destination (70 percent) for patients admitted through the emergency departmentwere at the 15th percentile, and the key HCAHPS score for inpatients was well below the Colorado average. Over the past six months Jeri Tinsley, director of medical, surgical, and intensive care services. had made various changes to try to improve the patient satisfaction scores for her 32-bed unit, but the scores seemed stuck at an unacceptably low level. Tinsley worried that if improvements were not made soon, patients would start "voting with their feet" and take their business to competing hospitals. As a registered nurse, Tinsley's expertise was helping people heal: it was not analyzing data. In particular, she was overwhelmed by the patient comments included in the surveys: she had no idea how to analyze them and could not decide which issues to address rst. Your job is to provide an analysis of the given data (see supplementary material that comes with the purchase of the case) and make recommendations. Here are a couple of guideline questions that you should consider in your analysis. Be sure to address these issues in your report. 1. Create a Pareto chart of negative comments for all ten categories. Interpret your chart. 2. Create a Pareto chart of positive comments for all ten categories. Interpret your chart. 3. Create an affinity diagram from the negative patient comments in the Room category. Use the Excel worksheet "Room - Negative" in the spreadsheet supplement as a tool to develop your affinity diagram. 4. Create a Pareto diagram from the results of the affinity diagram you created for Question 3. Interpret your results. 5. From the patient comments, what items (if any) need immediate attention? 6. What next steps would you recommend for the near term (four to eight weeks)