Calculating the Daily Inpatient Census
Part I. Calculate the average daily inpatient census data for the 20-bed orthopedic unit based on the following information. Plot your results in a bar graph using Excel with month on the x-axis and average daily inpatient census on the y-axis. Make sure the graph is clearly labeled. Your submission must include an APA-formatted cover sheet. Submit a final draft within the assignment submission folder.
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
