Fiscal Year 2017 Fiscal Year 2018 Fiscal Year 2019 Race/Ethnicity Discharges '17 ER visits* '17 Outpt. procedures '17 Discharges '18 ER visits* '18 Outpt. procedures '18 Discharges '19 ER visits* '19 Outpt. Procedures '19 Asian 1,426 1,208 2,600 1,206 1,094 2,689 1,156 956 2,700 African American 2,312 2,896 3,114 2,211 3,002 3,220 1,800 3,200 3,224 Hispanic 3,500 2,865 5,365 3,800 2,988 5,150 4,008 3,120 4,985 Native American 268 404 980 147 414 1,600 142 100 3,200 Other/Unknown 976 708 1,245 965 687 1,368 967 690 1,400 Caucasian 4,005 6,432 6,762 3,887 5,056 7,580 3,750 4,987 7,690 Totals 12,487 14,513 20,066 12,216 13,241 21,607 11,823 13,053 23,199 Reason for encounter Discharges '17 ER visits* '17 Outpt. procedures '17 Discharges '18 ER visits* '18 Outpt. procedures '18 Discharges '19 ER visits* '19 Outpt. Procedures '19 Heart conditions 3,450 3,050 3,602 3,402 2,970 3,558 3,115 2,900 3,417 Respiratory conditions 2,645 2,760 2,890 2,441 2,905 2,714 2,006 3,295 2,997 Diabetes 1,014 1,001 897 1,112 1,002 906 885 1,056 1,024 Pregnancy/Delivery 2,859 16 3,564 3,314 20 3,754 4,216 18 4,056 Orthopedic care/surgery 1,208 564 5,213 1,008 552 5,540 887 502 5,978 Trauma 268 3,874 - 212 3,902 - 187 4,012 - Other 1,043 3,248 3,900 727 1,890 5,135 527 1,270 5,727 Totals 12,487 14,513 20,066 12,216 13,241 21,607 11,823 13,053 23,199 Requirements with point allocation Question Point Value Points scored Requirements 1 8 Create the appropriate graphs to show the composition of the hospital inpatients (discharges only) by race/ethnicity in 2017, 2018, and 2019. Create the graph in the 1. Inpatient Composition tab 2 8 Create the appropriate graphs to show the composition of the hospital outpatients (outpatient procedures) by race/ethnicity in 2017, 2018, & 2019. Create the graph in the 2. Outpatient Composition tab 3 8 Identify two trends related to questions 1 and 2 by observing the graphs you have created. Write your answer here. 4 8 Show in one graph the volume (number) of ER visits by reason for encounter in 2019. Create the graph in the 4. ER 2019 tab 5 8 Identify the top three reasons for ER visits in 2019. Write your answer here. 6 8 Show in one graph the ER encounters for heart conditions in 2017, 2018, and 2019. Create the graph in the 6. ER Heart Cases tab 7 8 Identify the trend of ER encounters related to heart conditions. Write your answer here. 8 8 Show in one graph the volume (number) of discharges related to all 7 conditions in 2017, 2018, and 2019. Create the graph in the 8. DCs by Condition tab 9 8 Identify two trends of the hospital discharges in relation to those conditions. Write your answer here. 10 8 After looking at the overall hospital data and the trends identified, provide at least one suggestion for the hospital administrator. Write your answer here. Total points 80 0 Hints: For full credit, make sure to include titles, axes and legends in all graphs. It may help to place graphs in separate sheets. Adding labels to some of the graphs, may also help. When responding the last question (suggestions for the hospital administrator), think about what resources they may need to reallocate, expand, etc