Health Medical Homework Help

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

The table has three columns: column 1 is for the “Month”, column 2 is for the ” Number of inpatient Service Days”, and column 2 is for the “Average Daily inpatient Census.

So the figures you see are under the column where there is the ” Number of Inpatient Service Days”.