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 (1) single document at the conclusion of Week Two no later than Sunday, by 11:59 PM EST.

*PLEASE USE MICROSOFT EXCEL*

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

*ATTACHED IS A EXAMPLE OF THE ASSIGNMENT. *