HIT 229 Week 5 Excel Assignment # 3

Show in one graph the volume (number) of discharges related to all 7 8 8 condi琀椀ons in 2017, 2018, and 2019. Iden琀椀fy two trends of the hospital discharges in rela琀椀on to those 9 8 condi琀椀ons. A昀琀er looking at the overall hospital data and the trends iden琀椀昀椀ed, 10 8 provide at least one sugges琀椀on for the hospital administrator. Total points 80 0 Hints: For full credit, make sure to include 琀椀tles, 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 ques琀椀on (sugges琀椀ons for the hospital administrator), think about what resources they may need to reallocate, expand, etc. Show in one graph the volume (number) of discharges related to all 7 Trend 1 — Pregnancy/Delivery discharges increased sharply. condi琀椀ons in 2017, 2018, and 2019. Create the graph in the 8. DCs by Condi琀椀on tab They rose from 2,859 (2017) to 4,216 (2019), the largest growth of any category. Trend 2 — Respiratory and heart-condi琀椀on discharges declined. Iden琀椀fy two trends of the hospital discharges in rela琀椀on to those Respiratory discharges dropped from 2,645 → 2,006, and heart-condi琀椀on discharges dropped from 3,450 → 3,115 condi琀椀ons. between 2017 and 2019. A昀琀er looking at the overall hospital data and the trends iden琀椀昀椀ed, The hospital should consider expanding outpa琀椀ent and maternity resources while realloca琀椀ng sta昀昀 from declining provide at least one sugges琀椀on for the hospital administrator. inpa琀椀ent areas (heart and respiratory). make sure to include 琀椀tles, 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 ques琀椀on (sugges琀椀ons for the hospital administrator), think about what resources they may need to reallocate, expand, etc. Trend 1 — Pregnancy/Delivery discharges increased sharply. Create the graph in the 8. DCs by Condi琀椀on tab They rose from 2,859 (2017) to 4,216 (2019), the largest growth of any category. Trend 2 — Respiratory and heart-condi琀椀on discharges declined. Respiratory discharges dropped from 2,645 → 2,006, and heart-condi琀椀on discharges dropped from 3,450 → 3,115 The hospital should consider expanding outpa琀椀ent and maternity resources while realloca琀椀ng sta昀昀 from declining Outpa琀椀ent Procedure by Race/Ethnicity, 2017- 2019 8,000 7,000 6,000 5,000 4,000 3,000 2,000 1,000 - an an ic an n an i c n c w i s i a i o s r r a A e p e n c m is m k u A H A n a /U C n e r a v e ic 琀椀 h fr a t A N O Outpt. procedures '17 Outpt. procedures '18 Outpt. Procedures '19 ER Encounters for Heart Condi琀椀ons 2017-2019 4,500 4,000 3,500 3,000 2,500 2,000 1,500 1,000 500 - Heart con- Respiratory Diabetes Pregnancy/ Orthopedic Trauma Other di琀椀ons condi琀椀ons Delivery care/surgery ER visits* '17 ER visits* '18 ER visits* '19