$$

Chapter $4$ inpatient Bed Occupancy

Exercise $4\mathrm{.}2$

ch $4.$ Percentage of Occupancy

Use the information in the following table to calculate the percentage of occupancy for each day of the month and for the entire month using a Microsoft Excel spreadsheet. Round to one decimal place. Express the occupancy rates as percents.

$\backslash$table$[[\backslash$table$[[$Community Hospital$],[$April $20$XX$],[80$ beds$]]],[$Date$,\backslash$table$[[$Inpatient service$],[$days$]],\backslash$table$[[$Percentage of$],[$occupancy$]],$Date,$\backslash$table$[[$Inpatient service$],[$days$]],\backslash$table$[[$Percentage of$],[$occupancy$]]],[1,75,,16,56,],[2,77,,17,71,],[3,72,,18,78,],[4,79,,19,57,],[5,73,,20,52,],[6,74,,21,53,],[7,76,,22,50,],[8,60,,23,55,],[9,69,,24,58,],[10,54,,25,68,],[11,59,,26,64,],[2,63,,27,80,],[,65,,28,70,],[,66,,29,62,],[,67,,30,61,]]$he information in the following table to calculate the percentage of occupancy for each day of the mont and for the entire month using a Microsoft Excel spreadsheet. Round to one decimal place. Express the occupancy rates as percents. Please use excel and complete the table and and questions in these exercise $.$ You are encouraged to use excel formulas in excel to assist you with the calculation.