Description
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 are to put together a PowerPoint presentation that explains the analysis of your findings which you will submit to your manager. The presentation should contain all components of your findings. For review, the components of the report should include:
- Brief overview of the scenario and variables in the data set
- Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
- Discussion, construction, and interpretation of the 95% confidence interval
- Explanation of the full hypothesis test
- Conclusion
The calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document . Use the questions in the worksheet as your guide for the contents of your presentation.
For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached. Please let me know if you have any questions or need revisions.
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
Mean
Median
Mode
Midrange
Range
Variance
Standard Deviation
61,2923
61,0000
57,0000
62,5000
43,0000
104,3976
10,2175
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
Slide 8: Confidence Interval
n
Mean
standard deviation
alpha
α/2
1 - α/2
t critical
Error, E
Upper boundary
Lower Boundary
65
61
10,2175
5%
0,025
0,975
1,997729654
2,531776051
64
59
std dev
mean
10,217...