Advanced Statistics and Analytics
Introduction:
As a healthcare professional, you will work to improve and maintain the health of individuals, families, and communities in various settings. Basic statistical analysis can be used to gain an understanding of current problems. Understanding the current situation is the first step in discovering where an opportunity for improvement exists. This course project will assist you in applying basic statistical principles to a fictional scenario in order to impact the health and wellbeing of the clients being served.
This assignment will be completed in phases throughout the quarter. As you gain additional knowledge through the didactic portion of this course, you will be able to apply your new knowledge to this project. You will receive formative feedback from your instructor on each submission. The final project will be due on week 10.
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 60 patients that have the infectious disease with ages ranging from 35 years of age to 76 years of age for NCLEX Memorial Hospital. Remember this assignment will be completed over the duration of the course.
Review each scenario and data set carefully and choose which scenario you would like to work with. Begin Phase 1 of your analysis by including the following information:
Option 2 allows you to analyze the ages of infectious disease patients at NCLEX Memorial Hospital.
1. Introduce your scenario and data set.
o Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
o Describe the variables in your data set.
Are the variables quantitative or qualitative? Explain.
Are the variables discrete or continuous? Explain
2. Calculate the measures of center and measures of variation. (Calculate these using Excel and then copy the results from Excel into your Word Document) 30 Points
Mean
Median
Mode
Range
Variance
Standard Deviation
3. Conclusion
Recap your ideas by summarizing the information presented.
|
Patient #
|
Infectious Disease
|
Age
|
|
1
|
Yes
|
69
|
|
2
|
Yes
|
35
|
|
3
|
Yes
|
60
|
|
4
|
Yes
|
55
|
|
5
|
Yes
|
49
|
|
6
|
Yes
|
60
|
|
7
|
Yes
|
72
|
|
8
|
Yes
|
70
|
|
9
|
Yes
|
70
|
|
10
|
Yes
|
73
|
|
11
|
Yes
|
68
|
|
12
|
Yes
|
72
|
|
13
|
Yes
|
74
|
|
14
|
Yes
|
69
|
|
15
|
Yes
|
46
|
|
16
|
Yes
|
48
|
|
17
|
Yes
|
70
|
|
18
|
Yes
|
55
|
|
19
|
Yes
|
49
|
|
20
|
Yes
|
60
|
|
21
|
Yes
|
72
|
|
22
|
Yes
|
70
|
|
23
|
Yes
|
76
|
|
24
|
Yes
|
56
|
|
25
|
Yes
|
59
|
|
26
|
Yes
|
64
|
|
27
|
Yes
|
71
|
|
28
|
Yes
|
69
|
|
29
|
Yes
|
55
|
|
30
|
Yes
|
61
|
|
31
|
Yes
|
70
|
|
32
|
Yes
|
55
|
|
33
|
Yes
|
45
|
|
34
|
Yes
|
69
|
|
35
|
Yes
|
54
|
|
36
|
Yes
|
48
|
|
37
|
Yes
|
60
|
|
38
|
Yes
|
61
|
|
39
|
Yes
|
50
|
|
40
|
Yes
|
59
|
|
41
|
Yes
|
60
|
|
42
|
Yes
|
62
|
|
43
|
Yes
|
63
|
|
44
|
Yes
|
53
|
|
45
|
Yes
|
64
|
|
46
|
Yes
|
50
|
|
47
|
Yes
|
69
|
|
48
|
Yes
|
52
|
|
49
|
Yes
|
68
|
|
50
|
Yes
|
70
|
|
51
|
Yes
|
69
|
|
52
|
Yes
|
59
|
|
53
|
Yes
|
58
|
|
54
|
Yes
|
69
|
|
55
|
Yes
|
65
|
|
56
|
Yes
|
61
|
|
57
|
Yes
|
59
|
|
58
|
Yes
|
71
|
|
59
|
Yes
|
71
|
|
60
|
Yes
|
68
|