lOMoARcPSD|64026470
D547 APN1- Task 1
A. Analyze a specific section of the “Estimates of Emergency Department
Visits in the United States from 2016–2021” dataset by doing the
following
A1. Top two primary diagnoses and most common reason for visits by
age
Top two primary diagnoses:
1. Injury & Poisoning
a. 0-17 years old: 44,266,672 visits
b. 18-44 years old: 54,575,717 visits
c. 45-64 years old: 29,267,373 visits
d. 65+ years old: 24,068,033 visits
2. Symptoms, signs, and abnormal clinical and laboratory
findings
a. 0-17 years old: 41,743,428 visits
b. 18-44 years old: 72,662,197 visits
c. 45-64 years old: 51,284,730 visits
d. 65+ years old: 41,723,145 visits
Most common reason for visits:
1. 0-17 years old: fever
2. 18-44 years old: stomach and abdominal pain, cramps,
and spasms
3. 45-64 years old: stomach and abdominal pain, cramps,
and spasms
4. 65+ years old: stomach and abdominal pain, cramps,
and spasms
A2. Notable variations within subcategories using pivot tables and
pivot charts
Downloaded by Collins ()
D547 APN1- Task 1
A. Analyze a specific section of the “Estimates of Emergency Department
Visits in the United States from 2016–2021” dataset by doing the
following
A1. Top two primary diagnoses and most common reason for visits by
age
Top two primary diagnoses:
1. Injury & Poisoning
a. 0-17 years old: 44,266,672 visits
b. 18-44 years old: 54,575,717 visits
c. 45-64 years old: 29,267,373 visits
d. 65+ years old: 24,068,033 visits
2. Symptoms, signs, and abnormal clinical and laboratory
findings
a. 0-17 years old: 41,743,428 visits
b. 18-44 years old: 72,662,197 visits
c. 45-64 years old: 51,284,730 visits
d. 65+ years old: 41,723,145 visits
Most common reason for visits:
1. 0-17 years old: fever
2. 18-44 years old: stomach and abdominal pain, cramps,
and spasms
3. 45-64 years old: stomach and abdominal pain, cramps,
and spasms
4. 65+ years old: stomach and abdominal pain, cramps,
and spasms
A2. Notable variations within subcategories using pivot tables and
pivot charts
Downloaded by Collins ()
