USA: +1 (725) 712-1730 
Sign in
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 is 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 on your graph. Your submission must include an APA-formatted cover sheet. Submit one (1) single document at the conclusion of Week Two no later than Sunday, by 11: 59 PM EST. 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
Expert Answer
Answer
| N | TP | ||
| Month | No of Inpatient Service days | Total Patients | Average daily inpatients (TP/N) |
| January | 31 | 502 | 16.19 |
| February | 28 | 433 | 15.46 |
| March | 31 | 578 | 18.65 |
| April | 30 | 394 | 13.13 |
| May | 31 | 407 | 13.13 |
| June | 30 | 206 | 6.87 |
| July | 31 | 386 | 12.45 |
| August | 31 | 291 | 9.39 |
| September | 30 | 511 | 17.03 |
| October | 31 | 605 | 19.52 |
| November | 30 | 523 | 17.43 |
| December | 31 | 417 | 13.45 |
