Descriptive Statistics
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.
Using this, provide the mean age of those patients visiting the ED in the United States in
2016.
Using the Data Analysis ToolPak, provide the descriptive summary of the “Age Variable” including mean, median, mode, minimum, maximum, age, skewness,Dariance and standard deviation. Describe your results in 3-4 sentences.
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.
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.
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. Describe your cross-tab in 4-5 sentences.
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.
Present a scatter plot to show the correlation between Age and Pain.
Provide two sets of variables in the dataset might you be interested in seeing a relationship? Explain why?
