lOMoARcPSD|64026470
Annette Suchy - #000773241
APN1 Task 1: Data Analysis
Evidence-Based Healthcare Administration -D547
A. Analyze a specific section of the “Estimates of Emergency Department Visits in the
United States from 2016–2021” dataset by doing the following:
1. Select data from one of the groups (sex, age, race/ethnicity, region, metropolitan
statistical area (MSA), or primary payment source) and provide the top two
primary diagnoses and the most common reason for visits within the
subcategories.
Group: Race/ethnicity
The top primary diagnosis code when the data is filtered by race/ethnicity is
“symptoms, signs, and abnormal clinical and laboratory findings”. This diagnosis
is almost double the second top diagnosis code of injury and poisoning. These 2
diagnosis codes together comprise over 40% of all diagnosis codes by
race/ethnicity.
Subcatagory: Hispanic, Non-Hispanic Black, Non-Hispanic White
The most common reasons for visits for all subcategories is “symptoms, signs and
abnormal clinical and laboratory findings”. However, Non-Hispanic White’s visit
for this reason at a rate significantly higher than the others followed by Non-
Hispanic Blacks. These 2 subcategories make up roughly 80% of all the visits
with this diagnosis code.
2. Describe three notable variations within the selected subcategories using pivot
tables and pivot charts.
The data from the attached excel spreadsheet clearly shows that Non-Hispanic
Whites visit the Emergency Room more than any other race or ethnicity. In fact,
Non-Hispanic Whites visit at a rate of nearly double the others combined.
Hispanic patients have a disproportionately high rate of visits related to “Fever” than
other race/ethnicities based on total visits by their subcategory.
When compared to other race/ethnicities, Hispanic patients are seen the least. In
fact they are seen less than half as often as White patients.
3. Provide an Excel sheet that includes the data and calculations used to respond to
prompts A1 and A2.
The following elements in the screen capture below are also reflected in the attached
Excel spreadseet.
Downloaded by Collins ()
Annette Suchy - #000773241
APN1 Task 1: Data Analysis
Evidence-Based Healthcare Administration -D547
A. Analyze a specific section of the “Estimates of Emergency Department Visits in the
United States from 2016–2021” dataset by doing the following:
1. Select data from one of the groups (sex, age, race/ethnicity, region, metropolitan
statistical area (MSA), or primary payment source) and provide the top two
primary diagnoses and the most common reason for visits within the
subcategories.
Group: Race/ethnicity
The top primary diagnosis code when the data is filtered by race/ethnicity is
“symptoms, signs, and abnormal clinical and laboratory findings”. This diagnosis
is almost double the second top diagnosis code of injury and poisoning. These 2
diagnosis codes together comprise over 40% of all diagnosis codes by
race/ethnicity.
Subcatagory: Hispanic, Non-Hispanic Black, Non-Hispanic White
The most common reasons for visits for all subcategories is “symptoms, signs and
abnormal clinical and laboratory findings”. However, Non-Hispanic White’s visit
for this reason at a rate significantly higher than the others followed by Non-
Hispanic Blacks. These 2 subcategories make up roughly 80% of all the visits
with this diagnosis code.
2. Describe three notable variations within the selected subcategories using pivot
tables and pivot charts.
The data from the attached excel spreadsheet clearly shows that Non-Hispanic
Whites visit the Emergency Room more than any other race or ethnicity. In fact,
Non-Hispanic Whites visit at a rate of nearly double the others combined.
Hispanic patients have a disproportionately high rate of visits related to “Fever” than
other race/ethnicities based on total visits by their subcategory.
When compared to other race/ethnicities, Hispanic patients are seen the least. In
fact they are seen less than half as often as White patients.
3. Provide an Excel sheet that includes the data and calculations used to respond to
prompts A1 and A2.
The following elements in the screen capture below are also reflected in the attached
Excel spreadseet.
Downloaded by Collins ()
