HIMS 650 UMDC Calculating Daily inpatient Census Health Informatics & Data Analytics
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
The table has three columns: column 1 is for the “Month”, column 2 is for the ” Number of inpatient Service Days”, and column 2 is for the “Average Daily inpatient Census.
So the figures you see are under the column where there is the ” Number of Inpatient Service Days”.
