Calculating the Daily Inpatient Census Calculate the average daily inpatient


 

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

Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!