Week Five: Healthcare Statistics Assessment Directions: Please answer all five questions in the following tabs. All answers are to be contained in one excel file. You can save this file u complete the work within this file. Please do not delete this tab, the instructions tab. Be sure your name is on your document . Good luck! Name: xcel file. You can save this file under your name and In October, Peace & Prosperity Hospital reported 735 discharge days for adults and children and 103 discharge days for n During the month, 149 adults and children and 31 newborns were discharged. a) Calculate (round to one decimal place) the average length of stay (ALOS) for adults and children for the month of Octo b) Calculate (round to one decimal place) the average length of stay (ALOS) for newborns for the month of October. c) Would you expect more variance in length of stay for the adult and children population or the newborn population. Ex d 103 discharge days for newborns. ren for the month of October. he month of October. he newborn population. Explain why. Using the information in the tabel below, calculate (round to two decimal places) the postoperative dath rate for ea surgeon at Peace & Prosperity Hospital between January and March. Comment on the findings. Peace & Prosperity Hospital January - March 20XX Number of Surgery Patgients and Deaths, by Cardiac Surgeon Number of Surgery Patients Physician # 1 2 3 Number of Deaths within Post30 Days Post- Operative Operatively Death Rate 79 2 112 1 65 4 toperative dath rate for each cardiac Based on the information below, calculate (round to two decimal places) the annual postoperative surgical site infectio Comment on this rate. Cite a published benchmark to compare your findings to. Number of Surgical Operations Number of Patients Operated On Number of Post-Operative Surgical Site Infections Number of Post-Operative Deaths 3,114 3,089 65 43 ostoperative surgical site infection rate for Peace & Prosperity Hospital. a) It costs $0.75 to scan 1 page into the Electronic Health Record. On average, 29,353 scans are made per month. How much is spent on scanning these documents per year? b) The full-time clerk makes $10.50 per hour. Benefits account for 35% of wages. What is her annual pay? scans are t is her annual Please provide answers to the following multiple choice questions next to the question. Provide the letter of the correct answer. 1) Medical diagnosis is what type of variable: a) numerical b) categorical c) ordinal 2) White blood cell count is what type of variable: a) numerical b) categorical 3) True or False: Data shown in a histogram represents frequencies. a) True b) False Use the following information to calculate percents for letters a & b in the table below. Round to one decimal place. Table1. Patient Characteristics All Patients (n = 173) All Patients (%) History of Stroke a) calculate % history of stroke 87 for all patients History of Type 2 Diabetes b) calculate % history of type 2 diabetes for all 91 patients the letter of