Emergency Room Visits for ABC Medical Center 2017 2018 2019 2020 2021 Total Characteristics Male 5500 7050
Question:
Emergency Room Visits for ABC Medical Center | ||||||||||||||||
2017 | 2018 | 2019 | 2020 | 2021 | Total | |||||||||||
Characteristics | ||||||||||||||||
Male | 5500 | 7050 | 6350 | 8500 | 5500 | 32900 | ||||||||||
Female | 4300 | 3300 | 4100 | 6800 | 4800 | 23300 | ||||||||||
Under the age of 18 | 250 | 160 | 195 | 500 | 215 | 1320 | ||||||||||
18-21 | 345 | 195 | 265 | 350 | 400 | 1555 | ||||||||||
21-30 | 565 | 430 | 385 | 175 | 95 | 1650 | ||||||||||
31-40 | 480 | 420 | 310 | 520 | 685 | 2415 | ||||||||||
41-50 | 460 | 470 | 515 | 1030 | 755 | 3230 | ||||||||||
51-60 | 790 | 1000 | 805 | 1875 | 765 | 5235 | ||||||||||
61-64 | 2010 | 2500 | 2750 | 3600 | 2235 | 13095 | ||||||||||
Over the age of 65 | 4900 | 5175 | 5225 | 7250 | 5150 | 27700 | ||||||||||
You are the head of the Emergency Room Department. | ||||||||||||||||
You have been tracking the ER visits for the last five years. | ||||||||||||||||
It is your hope that this data will be sufficient enough | ||||||||||||||||
to request an increase in staff and equipment. | ||||||||||||||||
Use this worksheet to perform the following : | ||||||||||||||||
Use the worksheet in Tableau and Power BI to create a data visualization | ||||||||||||||||
for the Board. You many use any type of chart, graph or dashboard. | ||||||||||||||||
Write an analysis describing your interpretation and visualization. Requirements : | ||||||||||||||||
a. What two age groups visits the ER more? | ||||||||||||||||
b. How would you explain the lack of use of 18-21 years compared to other groups? | ||||||||||||||||
c. How would explain the sudden increase in ER use in 2020? | ||||||||||||||||
Accounting Business Reporting For Decision Making
ISBN: 9780730369325
7th Edition
Authors: Jacqueline Birt, Keryn Chalmers, Suzanne Maloney, Albie Brooks, Judy Oliver, David Bond