WGU D547 TASK 1: EVIDENCE-BASED HEALTHCARE ADMINISTRATION – DATA ANALYSIS REPORT COMPLETE STUDY GUIDE & PRACTICE QUESTIONS

WGU D547 TASK 1: EVIDENCE-BASED HEALTHCARE
ADMINISTRATION – DATA ANALYSIS REPORT
COMPLETE STUDY GUIDE & PRACTICE QUESTIONS (QUESTIONS 1–
100)
VERIFIED SOLUTIONS WITH RATIONALES | LATEST 2026 UPDATE


ASSESSMENT OVERVIEW

Component Details

Course D547 – Evidence-Based Healthcare Administration

Task Performance Assessment (PA) Task 1 – Data Analysis Report


Quality Improvement Analyst at a hospital with ED performance
Scenario
issues


CDC: Estimates of Emergency Department Visits in the United State
Dataset
from 2016–2021

Required A1: Data Selection, A2: Pivot Tables/Charts, A3: Notable Variatio
Sections A4: Research Question, A5: Variables Justification

Submission Excel workbook + PowerPoint presentation



SECTION A: DATA PREPARATION AND SETUP (Questions 1–20)
Questions 1–10: Dataset Familiarization
Question 1

,What is the name of the dataset used for WGU D547 Task 1?
A. National Hospital Ambulatory Medical Care Survey
B. Estimates of Emergency Department Visits in the United States from
2016–2021
C. Healthcare Cost and Utilization Project Database
D. National Health Interview Survey

B

RATIONALE: The CDC dataset titled "Estimates of Emergency
Department Visits in the United States from 2016–2021" is the official
dataset provided in the course materials for the D547 Task 1
performance assessment.


Question 2
Which file format is used for the D547 Task 1 dataset?
A. CSV (.csv)
B. Microsoft Excel (.xlsx)
C. PDF (.pdf)
D. SPSS (.sav)

B

RATIONALE: The dataset is provided as a Microsoft Excel workbook
(.xlsx), which allows students to perform data analysis using Excel's
PivotTable and PivotChart features.


Question 3
What are the available groups for data selection in the CDC dataset?

,A. Age, Gender, Diagnosis, Region, and Payment Method
B. Sex, Age, Race/Ethnicity, Region, Metropolitan Statistical Area (MSA),
and Primary Payment Source
C. Patient Name, Date of Visit, Diagnosis, and Treatment
D. Hospital Type, Bed Size, Location, and Ownership

B

RATIONALE: The dataset organizes data by six demographic and
geographic groups: Sex, Age, Race/Ethnicity, Region, Metropolitan
Statistical Area (MSA), and Primary Payment Source.


Question 4
What year range does the CDC dataset cover for ED visits?
A. 2015 through 2020
B. 2016 through 2021
C. 2017 through 2022
D. 2018 through 2023

B

RATIONALE: The dataset provides estimates of emergency
department visits across a six-year period from 2016 through 2021,
enabling trend analysis and multiple-year comparisons.


Question 5
What is the first step recommended before creating pivot tables in
Excel?
A. Delete all columns except Estimate

, B. Add filters to the dataset by highlighting columns and selecting Sort &
Filter → Filter
C. Create a chart immediately
D. Rename all columns

B

RATIONALE: Adding filters allows users to easily select specific data
criteria before creating pivot tables, ensuring the analysis includes only
relevant data.


Question 6
Which columns should be highlighted when adding filters to the
dataset?
A. Columns A through D
B. Columns A through L
C. Columns A through F
D. Columns B through M

B

RATIONALE: The dataset contains data in columns A through L;
highlighting these columns and applying filters enables dropdown
menus for filtering each column.


Question 7
What is the primary role of a Quality Improvement Analyst in the D547
scenario?
A. To directly treat patients in the emergency department