use the data in the table below and excel to answer the questions that follow for this group of 15 patients discharged from community hospital on october 20. 20XX

de LOS for a patient whose n acting the first day of the month for rent whose stay spans an entire calendar month, the number of days in the month the first day of the month from the last day and in the union day. For S could be calculated as down Il, the LOS could be www/ // da teles -19 10 22wdy OS LOS 20 days October Insol dan LOS -/ 3 dan 2 /13 /07 days 2 LOS in example 3.1 will work for any situation. The method that uses the month must only be applied in that special situation med to determine de red in the entire me w and Excel to answer the questions that follow for this group of 15 patients Exercise 5.4 munity Hospital on October 20, 20XX the data in the table below discharged from Community 2. Name Schulman Huhhard Miraboto Community Hospital Discharge List October 20, 20XX Clinical Service Surgery Medicine Obstetrics Obstetrics Medicine Medicine Surgery Obstetrics Admission Date LOS 9/18 9/12 10/18 10/18 9/28 9/4 10/5 10/19 (continued on next page) Rankins Lampton Hruska Adman 76 Chapter 5 Length of Stay LOS Community Hospital Discharge List October 20, 20XX Clinical Service Admission Date 9/1 10/1 10/17 Pi. Name Savage Beachton Sanders Pavalchik Walters Harding Clay Total Medicine Medicine Obstetrics Surgery Surgery Medicine Medicine 9/26 9/30 10/1 10/10 Calculate the following: a. LOS for each individual patient b. Total LOS for all patients c. Total LOS for medicine service patients d. Total LOS for surgery service patients e. Total LOS for obstetrics service patients f. Total LOS for patients 25 years of age and younger g. Total LOS for patients age 26 to 40 years old h. Total LOS for patients age 41 to 55 years old i. Total LOS for patients age 56 to 70 years old j. Total LOS for patients over age 70 k. What is the percentage of days from medicine? Round to one decimal place