WGU D547 task 1 |Passed on First Attempt |Latest Update with Complete Solution
k k k k k k k k k k k k
A. Analyze a specific section of the “Estimates of
k k k k k k k
kEmergency Department Visits in the United States from
k k k k k k k
k2016–2021” dataset by doing the following: k k k k k
1. Select data from one of the groups (sex, age,
k k k k k k k k
race/ethnicity, region, metropolitan statistical area
k k k k k
(MSA), or primary payment source) and provide the
k k k k k k k k
top two primary diagnoses and the most common
k k k k k k k k
reason for visits within the subcategories.
k k k k k k
• Group: By sex k k
• Subgroup: Male and Female k k k
• Year: 2016-2021 k
• Female Top Two Primary Diagnoses: Symptoms, signs, and
k k k k k k k
abnormal clinical and laboratory findings and Injury and
k k k k k k k k
poisoning
k
• Male Top Two Primary Diagnoses: Symptoms, signs, and
k k k k k k k
abnormal clinical and laboratory findings and Injury and
k k k k k k k k
poisoning
k
• Female Two most common reasons for visit: Stomach and
k k k k k k k k
abdominal pain, cramps and spasms, and Chest pain and
k k k k k k k k k
related symptoms (not referable to body systems)
k k k k k k k
• Male Two most common reasons for visit: Stomach and
k k k k k k k k
abdominal pain, cramps and spasms, and Chest pain and
k k k k k k k k k
related symptoms (not referable to body systems)
k k k k k k k
2. Describe three notable variations within the k k k k k
selected subcategories using pivot tables and
k k k k k k
charts.
k
• Most ED visits for both males and females were for symptoms of
k k k k k k k k k k k
stomach and abdominal pain, cramps, and spasms. However,
k k k k k k k k
females in this category visit the Emergency Department more
k k k k k k k k k
frequently than males.
k k k
o Between 2016 and 2021, females had 21,362,620 k k k k k k
more visits than males. (46,899,205-25,536,585
k k k k k
=21,362,620) k
• Males had a higher frequency of being diagnosed with
k k k k k k k k
injury and poisoning than females.
k k k k k
o Between 2016 and 2021, males received k k k k k
6,472,075 more diagnoses for injury and
k k k k k k
poisoning compared to females. (79,323,987-
k k k k k
72,851,912)
• The top primary diagnosis for visits for Males and Females was
k k k k k k k k k k
Symptoms, signs, and abnormal clinical and laboratory findings.
k k k k k k k k
However, females had a higher frequency in this category than
k k k k k k k k k k
Males.
k
o Between 2016 and 2021, females were diagnosed with k k k k k k k
symptoms, signs, and abnormal clinical and laboratory
k k k k k k k
findings 31,387,302 times more often than males.
k k k k k k k
, k (119,399,088- 88,011,786=31,387,302)
k
3. Provide an Excel sheet that includes the data and
k k k k k k k k
calculations used to respond to prompts A1 and A2.
k k k k k k k k k
See Excel Workbook
k k
k k k k k k k k k k k k
A. Analyze a specific section of the “Estimates of
k k k k k k k
kEmergency Department Visits in the United States from
k k k k k k k
k2016–2021” dataset by doing the following: k k k k k
1. Select data from one of the groups (sex, age,
k k k k k k k k
race/ethnicity, region, metropolitan statistical area
k k k k k
(MSA), or primary payment source) and provide the
k k k k k k k k
top two primary diagnoses and the most common
k k k k k k k k
reason for visits within the subcategories.
k k k k k k
• Group: By sex k k
• Subgroup: Male and Female k k k
• Year: 2016-2021 k
• Female Top Two Primary Diagnoses: Symptoms, signs, and
k k k k k k k
abnormal clinical and laboratory findings and Injury and
k k k k k k k k
poisoning
k
• Male Top Two Primary Diagnoses: Symptoms, signs, and
k k k k k k k
abnormal clinical and laboratory findings and Injury and
k k k k k k k k
poisoning
k
• Female Two most common reasons for visit: Stomach and
k k k k k k k k
abdominal pain, cramps and spasms, and Chest pain and
k k k k k k k k k
related symptoms (not referable to body systems)
k k k k k k k
• Male Two most common reasons for visit: Stomach and
k k k k k k k k
abdominal pain, cramps and spasms, and Chest pain and
k k k k k k k k k
related symptoms (not referable to body systems)
k k k k k k k
2. Describe three notable variations within the k k k k k
selected subcategories using pivot tables and
k k k k k k
charts.
k
• Most ED visits for both males and females were for symptoms of
k k k k k k k k k k k
stomach and abdominal pain, cramps, and spasms. However,
k k k k k k k k
females in this category visit the Emergency Department more
k k k k k k k k k
frequently than males.
k k k
o Between 2016 and 2021, females had 21,362,620 k k k k k k
more visits than males. (46,899,205-25,536,585
k k k k k
=21,362,620) k
• Males had a higher frequency of being diagnosed with
k k k k k k k k
injury and poisoning than females.
k k k k k
o Between 2016 and 2021, males received k k k k k
6,472,075 more diagnoses for injury and
k k k k k k
poisoning compared to females. (79,323,987-
k k k k k
72,851,912)
• The top primary diagnosis for visits for Males and Females was
k k k k k k k k k k
Symptoms, signs, and abnormal clinical and laboratory findings.
k k k k k k k k
However, females had a higher frequency in this category than
k k k k k k k k k k
Males.
k
o Between 2016 and 2021, females were diagnosed with k k k k k k k
symptoms, signs, and abnormal clinical and laboratory
k k k k k k k
findings 31,387,302 times more often than males.
k k k k k k k
, k (119,399,088- 88,011,786=31,387,302)
k
3. Provide an Excel sheet that includes the data and
k k k k k k k k
calculations used to respond to prompts A1 and A2.
k k k k k k k k k
See Excel Workbook
k k
