Exercise 8.2

Use the information in the table that follows, create an excel spreadsheet to calculate the gross mortality and HAI rates for each service and in total. In this exercise, the deaths are included in the discharges. Round two or two decimal places.

University Hospital Semiannual Statistics July - December 20XX

Service No. of discharges (include deaths) No. of deaths No of nosocomial infection

Medicine 2469 201 52

Surgery 2890 144 56

Obstetrics 785 2 6

Pscyhiatry 786 1 4

Rehabilitation 847 18 27

Pediatrics 945 3 3

Newborn 791 1 1

Total

How can you calculate the gross mortality and HAI rate for each service and in total?