I’m attaching assignment instructions and grading rubric. Along with the speed sheet to complete the assignment.
I’ve posted a budget if you feel it needs to be changed please talk to me prior to completing the assignment.
Thanks!
>Names
#
1
Yes Yes 71 Yes Yes Yes Yes Yes 72 Yes Yes 45 Yes 65 Yes Yes Yes Yes 71 Yes Yes Yes Yes Yes 59 Yes Yes 73 Yes Yes 55 Yes Yes Yes 47 Yes 71 Yes Yes Yes 65 Yes 60 Yes 44 Yes 61 Yes 57 Yes 61 Yes 55 Yes 50 Yes 65 Yes 57 Yes Yes 43
Deliverable 7 – Statistical Analysis Report
Patient
Infectious Disease
Age
1
Yes
6
9
2 Yes
4
3
5
7
4 Yes
55
5 Yes
45
6 Yes
59
7 Yes
71
8
9 Yes
72
10
67
11
60
12
65
13
73
14
15
42
16
17
18
47
19
44
20
51
21
22
66
23
84
24
56
25
61
26
27
68
28
29
50
30
31
77
32
57
33
34
35
58
36
49
37
38
39
40
41
42 Yes
63
43
44 Yes 60
45 Yes
62
46
47 Yes 66
48
49 Yes 77
50 Yes 66
51 Yes 66
52
53
54
69
55 Yes 59
56 Yes
70
57 Yes 53
58 Yes
76
59 Yes
74
60 Yes 68
61 Yes 55
62 Yes 61
63 Yes
81
64
65 Yes 67
Instructions
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:
1. Brief overview of the scenario and variables in the data set
2. Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
3. Discussion, construction, and interpretation of the 95% confidence interval
4. Explanation of the full hypothesis test
5. 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.