Health Medical Homework Help

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