Provide the frequency distribution of the following age categories. Calculate the percentage and cumulative percentages associated with each of the categories.

 DESCRIPTIVE STATISTICS (100 Points)

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 COUNTIF 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 COUNTIF 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 ToolPak. If you haven’t, follow these steps: go to File, Options, Add-ins, Analysis ToolPak. Under Manage, select Go. Select Analysis ToolPak 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 ToolPak, 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