Exercises: 9.1, 9.4, and 9.7

Complete Exercises 9.1, 9.4 and 9.7 on pages 232–236 in Quantitative Methods in Health Care Management. Use the Excel document below to record your answers. Note: For 9.7, provide a short response to the following (9.7j): "Use the measures in 9.7h and i for the final comparison among the three sites, and discuss potential problems at each site or overall for the company. What are your recommendations to correct them?"