Assignment task: Statistics Project
Hypothetically I am a HIM tech for Portland Community Hospital.
Every day at midnight, the nursing staff counts the census on their unit and sends the tally to HIM. You are responsible for calculating the daily census and verifying the tally with the EHR count.
The following was submitted by the nursing units for the midnight count on November 20th at 12:01 a.m., excluding obstetrics and pediatrics:
Unit Count
ICU 22
Med/Surg POD 1 17
Med/Surg POD 2 13
Med/Surg POD 3 15
What is the total count for the midnight census that you will compare to the electronic health record?
Eight (8) patients were admitted, and three (3) patients were discharged on November 20. One of the eight patients that had been admitted subsequently died the same day of admission (November 20).
1. Calculate the total inpatient service days for the hospital for November 20.
2. What is the difference between the total inpatient service days from the total length of stay.
3. Give an example of when the inpatient service days would be used and when the total LOS would be used.
The ICU manager reports the inpatient service days to the director of nursing each day. Looking at the chart above, for the midnight census, the ICU received one new direct admission, one transfer in from POD 2 and one transfer in from POD 3. The ICE transferred three patients out to POD 2, discharged one to a hospice center, and had one patient die on November 20.
4. Calculate the inpatient service days for the ICU on November 20th.
You have been provided the following data for Portland Community Hospital for last year, which was not a leap year. The hospital has 90 adult beds, 10 pediatric beds, and 15 bassinets.
Type of Service Inpatient Service Days
Adult 30,860
Newborn 4,100
Pediatric 2,800
5. Calculate the average daily census of adults and children for this year. Round to a whole number.
6. Calculate the average percentage of occupancy for adults and pediatrics. Round to a whole number. Need Assignment Help?
7. What was the average daily census of newborns for the year? Round to a whole number.
8. Calculate the average percentage of occupancy for newborns. Round to a whole number.
9. Develop a graph reflecting both the adult and children daily census and the newborn daily census on an Excel graph for display. Remember to title and label axes appropriately.
10. Create a dashboard showing all your results in a professional format to provide administration.