lOMoARcPSD|64026470
Evidence-Based Healthcare Administration – D547
APN1-TASK 1: DATA ANALYSIS
Name
ID
Date: 02/20/25
A1 (The data I chose to use)
Selected Data:
1. Subgroup: Age
2. Primary diagnosis: Symptoms, signs, and abnormal clinical and laboratory findings and Mental,
behavior, and neurodevelopmental disorders (but you still have to include the rest of the
diagnosis but remember to remove any that are missing data)
3. Most commo reason for visit: Other symptoms/problems related to psychological and mental
disorders and Shortness of breath
A2. (Recap of what you will have in your Spreadsheet; these are the 3 notable variables I selected)
545,881,908 more ED visits for primary diagnosis of Symptoms, signs, and abnormal clinical and
laboratory finds in age group 18-44 then there were for Mental, behavior, and neurodevelopmental
disorders for the same age group
40,413,144 less females are seen for Other symptoms/problems related to psychological and mental
disorders then Stomach and abdominal pain, cramps, and spasms
254,903,381 more Females visited the Emergency Dept in general then malesA3. See excel
spreadsheet
Downloaded by Collins ()
, lOMoARcPSD|64026470
Instructions on what is needed in the spreadsheet and how to create your pivot table and chart – Hope this
helps
Download the Estimates_of_Emergency_Dept and save it to your laptop/desktop
o KeyPoints
Leave the main ED estimates as your main tap (reason why I had to resubmit a 2nd time)
Add filters by highlighting your sections (A-L), from the toolbar click “Sort & Filter. This
gives you the dropdown options next to each data row
For each pivot table I renamed the Measure to either Primary diagnosis or Most common
Reason for visit
Changed it back once I created the pivot table in a new tab
o KeyPoints for Pivot table chart
When filtering make sure to have 2016-2021 checked
Filter “Measure Type” by primary diagnosis
For Measure (or if you changed the name to Primary Diagnosis) select all with the
exception of “All Diagnosis” (this is generalized and not needed)
Group: filter by either Sex, Age, Race/ethnicity, Region, or type of payment/insurance
used (only leave what you need checked)
Filter your subgroups (or if you renamed this by whatever you chose to focus on): either
by gender, age group, insurance, or region
Estimate Type: filter by Visit Count (filter and unselect rate)
Estimate: (I changed it to Visit Count)
Make sure to unselect any blanks in this column
Other three columns are not needed buy you can leave it on the main ED tab
o Undo your filters and change names for your next pivot table
o Once Pivot tables are complete, I changed the names back on the main Estimates of ED
o Pivot time
Click on Insert
Highlight your columns A-H
Downloaded by Collins ()
Evidence-Based Healthcare Administration – D547
APN1-TASK 1: DATA ANALYSIS
Name
ID
Date: 02/20/25
A1 (The data I chose to use)
Selected Data:
1. Subgroup: Age
2. Primary diagnosis: Symptoms, signs, and abnormal clinical and laboratory findings and Mental,
behavior, and neurodevelopmental disorders (but you still have to include the rest of the
diagnosis but remember to remove any that are missing data)
3. Most commo reason for visit: Other symptoms/problems related to psychological and mental
disorders and Shortness of breath
A2. (Recap of what you will have in your Spreadsheet; these are the 3 notable variables I selected)
545,881,908 more ED visits for primary diagnosis of Symptoms, signs, and abnormal clinical and
laboratory finds in age group 18-44 then there were for Mental, behavior, and neurodevelopmental
disorders for the same age group
40,413,144 less females are seen for Other symptoms/problems related to psychological and mental
disorders then Stomach and abdominal pain, cramps, and spasms
254,903,381 more Females visited the Emergency Dept in general then malesA3. See excel
spreadsheet
Downloaded by Collins ()
, lOMoARcPSD|64026470
Instructions on what is needed in the spreadsheet and how to create your pivot table and chart – Hope this
helps
Download the Estimates_of_Emergency_Dept and save it to your laptop/desktop
o KeyPoints
Leave the main ED estimates as your main tap (reason why I had to resubmit a 2nd time)
Add filters by highlighting your sections (A-L), from the toolbar click “Sort & Filter. This
gives you the dropdown options next to each data row
For each pivot table I renamed the Measure to either Primary diagnosis or Most common
Reason for visit
Changed it back once I created the pivot table in a new tab
o KeyPoints for Pivot table chart
When filtering make sure to have 2016-2021 checked
Filter “Measure Type” by primary diagnosis
For Measure (or if you changed the name to Primary Diagnosis) select all with the
exception of “All Diagnosis” (this is generalized and not needed)
Group: filter by either Sex, Age, Race/ethnicity, Region, or type of payment/insurance
used (only leave what you need checked)
Filter your subgroups (or if you renamed this by whatever you chose to focus on): either
by gender, age group, insurance, or region
Estimate Type: filter by Visit Count (filter and unselect rate)
Estimate: (I changed it to Visit Count)
Make sure to unselect any blanks in this column
Other three columns are not needed buy you can leave it on the main ED tab
o Undo your filters and change names for your next pivot table
o Once Pivot tables are complete, I changed the names back on the main Estimates of ED
o Pivot time
Click on Insert
Highlight your columns A-H
Downloaded by Collins ()
