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?

Answer rating: 100% (QA)

ATwo Age Groups Visiting ER More In the context of emergency room ER visits at ABC Medical Center the most significant number of visits is seen in the age group Over the age of 65 This category had th... View the full answer