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

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




Evidence-Based Healthcare Administration – D547 k k k k




APN1-TASK 1: DATA ANALYSIS k k k




Name
ID
k




Date: 02/20/25
k




A1 (The data I chose to use) Selected
k k k k k k k




Data:
k




1. Subgroup: Age k




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




behavior, and neurodevelopmental disorders (but you still have to include the rest of the diagnosis
k k k k k k k k k k k k k k k




but remember to remove any that are missing data)
k k k k k k k k k




3. Most commo reason for visit: Other symptoms/problems related to psychological and mental
k k k k k k k k k k k




disorders and Shortness of breath
k k k k k




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




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



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



disorders for the same age group
k k k k k k




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


disorders then Stomach and abdominal pain, cramps, and spasms
k k k k k k k k k




• 254,903,381 more Females visited the Emergency Dept in general then malesA3. See excel
k k k k k k k k k k k k


spreadsheet
k

, Instructions on what is needed in the spreadsheet and how to create your pivot table and chart – Hope this helps
k k k k k k k k k k k k k k k k k k k k




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



o KeyPoints
▪ Leave the main ED estimates as your main tap (reason why I had to resubmit a 2nd time)
k k k k k k k k k k k k k k k k k



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



gives you the dropdown options next to each data row
k k k k k k k k k k



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



Reason for visit
k k k




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



o KeyPoints for Pivot table chart
k k k k




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




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



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



exception of “All Diagnosis” (this is generalized and not needed)
k k k k k k k k k k



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



used (only leave what you need checked)
k k k k k k k




▪ Filter your subgroups (or if you renamed this by whatever you chose to focus on): either by
k k k k k k k k k k k k k k k k



gender, age group, insurance, or region
k k k k k k




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




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




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




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



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



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




o Pivot time k




▪ Click on Insert k k




▪ Highlight your columns A-H k k k