St. Marie's hospital has been faced with financial challenges over the past ten years. Management is...

Transcribed Image Text:

St. Marie's hospital has been faced with financial challenges over the past ten years. Management is interested in restructuring the hospital's operations and has hired you as a consultant to address some issues that have arisen. An Excel spreadsheet was prepared with the following variable headings: Name Description ID: Identification Number (1-113) Length_stay: Average length of stay for all patients in hospital (days) Age_years: Average age of patients (years) Infection_pct: Average estimated probability of acquiring infection in hospital Culture_ratio: Number of cultures performed to number of patients without signs or symptoms of hospital-acquired infection in hospital X_ray_ratio: Number of X-rays performed to number of patients without signs or symptoms of pneumonia Num_Beds: Average number of beds in hospital during study period Region_num: Geographic region : 1 = North East, 2 = North Central, 3 = South, 4 = West Num_Patients: Average number of patients in hospital during study period Num_Nurses: Number of full-time nurses during study period Num_Services: Number of potential facilities and services that are provided by the hospital Use Excel where necessary to assist you in answering the following questions: Question 4 Carry out the ANOVA test at the 5% level of significance to provide answers for each of the following: i. ii. Determine if there is a difference in the average number of potential facilities and services that are provided by the hospital by region. [5 marks] Which region(s) showed difference in the average number of potential facilities and services that are provided by the hospital by region? Explain. [3 marks] St. Marie's hospital has been faced with financial challenges over the past ten years. Management is interested in restructuring the hospital's operations and has hired you as a consultant to address some issues that have arisen. An Excel spreadsheet was prepared with the following variable headings: Name Description ID: Identification Number (1-113) Length_stay: Average length of stay for all patients in hospital (days) Age_years: Average age of patients (years) Infection_pct: Average estimated probability of acquiring infection in hospital Culture_ratio: Number of cultures performed to number of patients without signs or symptoms of hospital-acquired infection in hospital X_ray_ratio: Number of X-rays performed to number of patients without signs or symptoms of pneumonia Num_Beds: Average number of beds in hospital during study period Region_num: Geographic region : 1 = North East, 2 = North Central, 3 = South, 4 = West Num_Patients: Average number of patients in hospital during study period Num_Nurses: Number of full-time nurses during study period Num_Services: Number of potential facilities and services that are provided by the hospital Use Excel where necessary to assist you in answering the following questions: Question 4 Carry out the ANOVA test at the 5% level of significance to provide answers for each of the following: i. ii. Determine if there is a difference in the average number of potential facilities and services that are provided by the hospital by region. [5 marks] Which region(s) showed difference in the average number of potential facilities and services that are provided by the hospital by region? Explain. [3 marks]