Assignment Overview: Construct a pie graph to display the discharges of your hospital by service type.

(Hospital XYZ, Percent of Discharges by Service Type, 2017)

Service Type Discharges % Medical 24 Surgery 31 Pediatrics 17 Newborn 13 Obstetrics 15

Scenario 2: Construct a bar/column graph to display the deaths by gender and by age group. (Hospital XYZ, Deaths by Gender and by Age Group, 2017)

Deaths

Age Group Male Female <10 78 65 10-19 64 59

20-29 56 51

30-39 50 40

40-49 45 32

50-59 47 35

60-69 54 49 70-79 64 55 >79 89 68

Directions:

1. Enter the raw data from the scenarios provided above into an Excel spreadsheet. Show the data displays/graphs requested.