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
On a separate sheet in your Excel file, complete questions 1 and 2.
You should have already downloaded the Excel Analysis Tool bar. Under Manage, select Go. Select Analysis Tool bar and click ok .
In your Excel file, when you select the Data tab, on the far right, you will see “Data Analysis” appear.
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
