Assignment:
Calculating the Daily Inpatient Census
Calculate the average daily inpatient census data for the 20-bed orthopedic unit based on the following information. Plot your results as a line or bar graph using Microsoft Excel. The x-axis must reflect the months of January - December and the y-axis must reflect the average daily inpatient census. Be sure that your final draft is clearly labeled and your calculations are accurate to avoid skewed results depicted in your graph. Your submission must include an APA-formatted cover sheet. Submit one MS Word document including the data table and the graph.
|
Month
|
Number of Inpatient Service Days
|
Average Daily Inpatient Census
|
|
January
|
502
|
|
|
February
|
433
|
|
|
March
|
578
|
|
|
April
|
394
|
|
|
May
|
407
|
|
|
June
|
206
|
|
|
July
|
386
|
|
|
August
|
291
|
|
|
September
|
511
|
|
|
October
|
605
|
|
|
November
|
523
|
|
|
December
|
417
|
|