Business Finance Homework Help

Read the case: Herzog Memorial Hospital carefully to understand the issues involved. The file Herzog Exhibit-1 Supplement.xls contains the data referred to in the case.Study this worksheet too to understand its structure.

Patients’ comments in the Herzog Exhibit-1 Supplement spreadsheet are sorted into 10 groups:

• Admissions
• Room
• Meals
• Nurses
• Tests & Treatment
• Visitors & Family
• Physician
• Discharge
• Personal Issues
• Overall Assessment

Negative comments from patients about the Room are extracted for your convenience and provided in sheet labeled Room – Negative Comments.

Questions:

• Create a Pareto diagram of negative comments for all 10 categories.In this diagram, the ten categories will be on the horizontal axis and the frequencies of negative comments will be on the vertical axis. (20 pts)
• Create a Pareto diagram of positive comments for all 10 categories.Again the ten categories will be on the horizontal axis and the frequencies of positive comments will be on the vertical axis. (20 pts)
• The one outlier from the HCAHPs report was “The area round my room was quiet at night,” which was 14 points below the Colorado average.Do patients’ comments support or refute that score? (10 pts)
• Create a Pareto diagram based on the negative comments about Room. You may make use of the template provided (on this same shate) to keep track of which comment falls into which category.You will have to create these categories based on the comments. (20 pts)
• From your answers to questions 1-4, what items (if any) need immediate attention?What next steps would you recommend for the near term (4-8 weeks)?Consider what activities Tinsley can control or influence. (30 pts)

By any chance, would you know how to complete this assignment? If not, I will share it to see if anyone else can. It’s a quicker assignment nothing like the length of the case reports.