Calculating the Daily Inpatient Census

  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. 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 Request order