MC 621 UIC NCLEX Memorial Hospital Statistical Quantitative Analysis Report

Patient #Infectious Disease
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Age
69
41
57
55
45
59
71
71
72
67
60
65
73
72
42
45
65
47
44
51
71
66
84
56
61
59
68
73
50
55
77
57
47
71
58
49
65
60
44
61
57
63
61
60
62
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
55
66
50
77
66
66
65
57
69
59
70
53
76
74
68
55
61
81
43
67
Deliverable 07 Worksheet
Scenario
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over
the past few days, you have noticed an increase in patients admitted with a particular
infectious disease. You believe that the ages of these patients play a critical role in the method
used to treat the patients. You decide to speak to your manager, and together you work to use
statistical analysis to look more closely at the ages of these patients.
You do some research and put together a spreadsheet of the data that contains the following
information:
●
●
●
Client number
Infection disease status
Age of the patient
You need the preliminary findings immediately so that you can start treating these patients.
So, let’s get to work!
Background information on the Data:
The data set consists of 65 patients that have the infectious disease with ages ranging from
41 years of age to 84 years of age for NCLEX Memorial Hospital.
Requirements:
1) Answer the questions below in a PowerPoint presentation.
2) Include the summary calculations and the formulas in your slides either symbolically or
from Excel. Do not round your results.
3) Show calculations in your Excel spreadsheet.
Submit both the PowerPoint and Excel files.
PowerPoint Presentation Requirements
Slide 1
Title Slide
Title
Slide 2
Provide a brief overview of the scenario you are given above and the data set
Overview
that you will be analyzing.
Slide 3
Classify the variables in your data set.
Classification • Which variables are quantitative/qualitative?
• Which variables are discrete/continuous?
• Describe the level of measurement for each variable included in the data
set (nominal, ordinal, interval, ratio)
Slide 4
What are the measures of center and why are they important? Describe each
Measures of
Center
Slide 5
Measures of
Variation
individually and list any advantages or disadvantages that each may have.
Slide 6
Calculations
Show your results for the following calculations. Include formulas used in
Excel. Interpret your results in the context of the scenario and include units
of measurement for each.
• Mean
• Median
• Mode
• Mid-range
• Range
• Variance
• Standard Deviation
Slide 7
Confidence
Intervals
Show your responses for the follow questions:
• What are confidence intervals?
• What is a point estimate?
• What is the best point estimate for a population mean? Explain.
• Why do we need confidence intervals?
Slide 8
Confidence
Intervals
Construct a 95% confidence interval for the population mean ages of the
patients. Assume that your data is normally distributed and σ is unknown.
What are the measures of variation and why are they important? Describe
each individually and list any advantages or disadvantages that each may
have.
Show results for the following calculations in constructing the confidence
interval. Include formulas used in Excel. Interpret the confidence interval.
• Critical Value
• Margin of Error
• Upper and Lower Bounds
Slide 9
Hypothesis
Testing
Perform the following hypothesis test based on the claim that the average
age of all patients admitted to the hospital with infectious diseases is less
than 64 years of age.
Write the null and alternative hypothesis symbolically and include the
following additional information:
• Which hypothesis is the claim?
• Is the test two-tailed, left-tailed, or right-tailed? Explain
• Which test statistic will you use for your hypothesis test, z-test or ttest? Explain.
Slide 10
Hypothesis
Testing
Continue the hypothesis test based on the claim that the average age of all
patients admitted to the hospital with infectious diseases is less than 64
years of age.
Show your results and formulas used for the following calculations:
• Test Statistic
• Critical Value
• P-value
Slide 11
Hypothesis
Testing
Complete the hypothesis test by explaining the following:
• Decision to reject the null hypothesis or to not reject the null
hypothesis.
• Explain your decision using the critical value method.
• Explain your reasoning using the P-value method.
• Restate your conclusion in non-technical terms.
Slide 12
Conclusion
Conclude by recapping your ideas by summarizing the information
presented in context of the scenario.
• Include the mean, standard deviation, confidence interval with
interpretation, and result of the hypothesis test.
• What conclusions, if any, do you believe we can draw as a result of
your study?
• What did you learn from the project about the population based on
this sample?
• What did you learn about the specific statistical tests you conducted?