Construct a frequency distribution and histogram

Based on the scenario and data set, construct a document that addresses the questions outlined below. This assignment should be completed using Microsoft Word and Microsoft Excel, and both files should be submitted. The rubric shown in this Canvas dropbox lets you know how the assignment will be graded.

Summarize and graph your data.

Choosing one of the quantitative variables from your data set, construct a frequency distribution that has a minimum of 5 classes (please do not include more than 10 classes). The frequency distribution should contain the following columns:

Lower and Upper Class Limits

Class Boundaries

Midpoints

Relative Frequencies

Cumulative Frequencies

Interpret the results of your frequency distribution in context of your chosen scenario.

What are the measures of center and why are they important?

5.  Using the variable that you analyzed, calculate the measures of center and measures of variation. Interpret your results in context of the selected topic. Include the formula for any of the following statistics which are derived from formulas.

Median

6. Conclusion

Recap your ideas by summarizing the information presented.

G163 Essential Statistics and Analytics – Summative Assessment Option 2
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.
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.
Patient #
Infectious Disease
Age
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
69
35
60
55
49
60
72
70
70
73
68
72
74
69
46
48
70
55
49
60
72
70
76
56
59
64
71
69
55
61
70
55
45
69
54
48
60
61
50
59
60
62
63
53
64
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
50
69
52
68
70
69
59
58
69
65
61
59
71
71
68