WGU D547 APN1-TASK 1: DATA ANALYSIS |New 2026 Update with complete solution.

WGU D547 APN1-TASK 1: DATA ANALYSIS |New 2026 Update with complete
kj kj kj kj kj kj kj kj kj kj



solution.
kj




Evidence-Based Healthcare Administration – D547 kj kj kj kj




APN1-TASK 1: DATA ANALYSIS kj kj kj




Name
ID
kj




Date: 02/20/25 kj




A1 (The data I chose to use)
kj kj kj kj kj kj




Selected Data:
kj kj




1. Subgroup: Age kj




2. Primary diagnosis: Symptoms, signs, and abnormal clinical and laboratory findings
kj kj kj kj kj kj kj kj kj




and Mental, behavior, and neurodevelopmental disorders (but you still have to
kj kj kj kj kj kj kj kj kj kj kj




include the rest of the diagnosis but remember to remove any that are missing data)
kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj




3. Most commo reason for visit: Other symptoms/problems related to psychological
kj kj kj kj kj kj kj kj kj




and mental disorders and Shortness of breath
kj kj kj kj k j kj kj




A2. (Recap of what you will have in your Spreadsheet; these are the 3 notable variables I
kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj



selected)
kj



• 545,881,908 more ED visits for primary diagnosis of Symptoms, signs, and abnormal
kj k j kj kj kj kj kj kj kj kj kj



clinical and laboratory finds in age group 18-44 then there were for Mental, behavior,
kj kj k j kj kj kj kj kj kj kj kj kj kj kj



and neurodevelopmental disorders for the same age group
kj kj kj kj kj kj kj kj




• 40,413,144 less females are seen for Other symptoms/problems related to psychological
kj kj kj kj kj kj kj kj kj kj


and mental disorders then Stomach and abdominal pain, cramps, and spasms
kj kj kj k j k j kj kj k j k j k j k j




• 254,903,381 more Females visited the Emergency Dept in general then kj kj kj kj kj kj kj kj kj


malesA3. See excel spreadsheet
kj kj kj kj

, Instructions on what is needed in the spreadsheet and how to create your pivot table and chart –
kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj




Hope this helps
kj kj kj




• Download the Estimates_of_Emergency_Dept and save it to your laptop/desktop
kj kj kj kj kj kj kj kj



o KeyPoints
▪ Leave the main ED estimates as your main tap (reason why I had to resubmit
kj kj kj kj kj kj kj k j kj kj kj kj kj kj




a 2nd time) kj kj kj



▪ Add filters by highlighting your sections (A-L), from the toolbar click “Sort &
kj kj kj kj kj kj kj kj kj kj kj kj



Filter. This gives you the dropdown options next to each data row
kj kj kj kj kj kj kj kj kj kj kj kj



▪ For each pivot table I renamed the Measure to either Primary diagnosis or Most
kj kj kj kj kj kj kj kj kj kj kj kj kj



common Reason for visit
kj kj kj kj




• Changed it back once I created the pivot table in a new tab kj kj kj kj kj kj kj kj kj kj kj kj



o KeyPoints for Pivot table chart kj kj kj kj




▪ When filtering make sure to have 2016-2021 checked kj kj kj kj kj kj kj




▪ Filter “Measure Type” by primary diagnosis kj kj k j k j kj



▪ For Measure (or if you changed the name to Primary Diagnosis) select all
kj kj kj kj kj kj kj kj kj kj kj kj



with the exception of “All Diagnosis” (this is generalized and not needed)
kj kj kj kj kj kj kj kj kj kj kj kj



▪ Group: filter by either Sex, Age, Race/ethnicity, Region, or type of
kj kj kj kj kj kj kj kj kj kj



payment/insurance used (only leave what you need checked)
kj kj kj kj kj kj kj kj



▪ Filter your subgroups (or if you renamed this by whatever you chose to focus
kj kj kj kj kj kj kj kj kj kj kj kj kj



on): either by gender, age group, insurance, or region
kj kj kj kj kj kj kj kj kj




▪ Estimate Type: filter by Visit Count (filter and unselect rate) kj kj kj kj kj kj kj kj kj




▪ Estimate: (I changed it to Visit Count) kj kj kj kj kj kj




• Make sure to unselect any blanks in this column kj kj kj kj kj kj kj kj




▪ Other three columns are not needed buy you can leave it on the main ED tab
kj kj kj kj kj kj kj kj kj kj kj kj kj kj kj



o Undo your filters and change names for your next pivot table
kj kj kj kj kj kj kj kj kj kj




o Once Pivot tables are complete, I changed the names back on the main Estimates of
kj kj kj kj kj kj kj kj kj kj kj kj kj kj



ED kj




o Pivot time kj




▪ Click on Insert kj kj




▪ Highlight your columns A-H kj kj kj