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 1 Construct an appropriate table showing the number of full-time nurses across each region. [4 marks]