NU-590 (Week 8) DESCRIPTIVE STATISTICS (100 Points)
Using the Data Analysis Tool Pak to provide descriptive statistics
Go to File, Options, Add-ins, Analysis ToolPak. Under Manage, select Go. Select Analysis
ToolPak. When you select “Data” tab, at the extreme right you will see “Data Analysis” appear.
Provide your answers in an Excel file. Any questions that ask for explanation can be included in
a separate tab within the same Excel file.
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, mode, minimum, maximum, age, skewness,
variance and standard deviation. Describe your results in 3-4 sentences.
2. Perform a descriptive summary of the “Pain variable” including mean, median, mode,
minimum, maximum, age, skewness, variance and standard deviation. Describe your
results in 3-4 sentences.
3. Using the IF function (nested IF), classify the pain variable into three categories
a. Mild if pain score is between 0 and 3
b. Moderate if pain score is between 4 and 7
c. Severe if pain score is between 8 and 10.
4. Using the COUNTIFS function, create a cross-tabulation with gender and pain categories
[Mild, Moderate and Severe].
Cross Tabulation between gender and pain categories. Present the frequencies and the
percentages.
Mild (0-3) Moderate (4-7) Severe (8-10
Male N % N % N %
Female
5. Describe your cross-tab in 4-5 sentences.
6. Using the Analysis Toolpak, present the correlation coefficient between Age and Pain
Score. Is it high or low? Is it positive or negative? Is it what you were expecting to be?
Explain your answer.
7. Present a scatter plot to show the correlation between Age and Pain.
8. Provide two sets of variables in the dataset might you be interested in seeing a
relationship? Explain why?
