solved Hi, Healthcare Statistics Directions: Please answer all five questions in

Hi, Healthcare Statistics 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 under your name and complete the work within this file. Please do not delete this tab, the instructions tab. Question #1: In October, Peace & Prosperity Hospital reported 735 discharge days for adults and children and 103 discharge days for newborns. 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 October. 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. Explain why. Question #2: Using the information in the table below, calculate (round to two decimal places) the postoperative death rate for each cardiac surgeon at Peace & Prosperity Hospital between January and March. Comment on the findings. Peace & Prospective Hospital January – March 20xx Number of Surgery Patients and Deaths, by Cardiac Surgeon Number of Number of Surgery Deaths within post-operative Patients 30 Days posts- Death Rate operatively Physician # 1 79 2 2 112 1 3 65 4 Question #3: Based on the following below, (calculate round to decimal places) the annual postoperative surgical infection rate for peace & prosperity Hospital. Comment on this rate. Cite a published benchmark to compare your findings to. Number of Surgical Operations 3,114 Number of Patients Operated On 3,089 Number of Post-Operative Surgical Site Infections 65 Number of Post-Operative Deaths 43 Question #4: 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? Question #5: 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. Table 1. Patient Characteristics All Patients (n=173) All Patients (%) a)Calculate % of History for all patients History of Stroke 87 History of b) calculate % Type 2 history of type 2 diabetes Diabetes 91 for all patients