Part 1. [50 Points]
On a separate sheet in your Excel file, complete questions 1-6.
1) Classify each variable into the following types of variables: Categorical, Discrete and
Continuous variables.
2) Classify each variable into the following levels of measurement: Nominal, Ordinal, Ratio,
and Interval.
3) Sort the Data by Reason for Visit [RFV1]
4) Use the Filter and COUNT IF function in EXCEL and report the number of ED visits due
to the following reasons:
a. Abdominal Pain, cramps, spasms, NOS
b. Accident
c. Back pain, ache, soreness, discomfort
d. Chest pain
e. Headache, pain in head
f. Fever
5) Create a frequency distribution table using the COUNT IF function in excel:
Number of visits
Abdominal Pain, cramps, spasms,
NOS
Accident
Back pain, ache, soreness,
discomfort
Chest pain
Headache, pain in head
Fever
6) Using the IMMEDIACY OR TRIAGE LEVEL variable, report how many of the
abdominal pain and chest pain cases were “Emergent”, “Urgent”, “Semi-urgent”.
Abdominal Pain Chest pain
Emergent
Urgent
Semi-urgent

Part 2. [50 Points]
On a separate sheet in your Excel file, complete questions 1 and 2.
You should have already downloaded the Excel Analysis Tool bar.
1. Using this, provide the mean age of those patients visiting the ED in the United States in
2016.
a. Using the Data Analysis Tool bar, provide the descriptive summary of the “Age
Variable” including mean, median, minimum and maximum. Describe your
results in 3-4 sentences.
2. Provide the frequency distribution of the following age categories. Calculate the
percentage and cumulative percentages associated with each of the categories.
Age group Frequency Percentage Cumulative
percentage
Under 15 years
15-24 years
25-44 years
45-64 years
65-74 years
75 years and over
• Complete the assignment in Excel and submit the Excel file