- Have any questions?
- support@nursingcourseworks.com
Make-Graphs-with-data-data-presentation-assignment-help- Nursing Writers Hub
Congenital aganglionic megacolon (Hirschsprung disease) involves inadequate motility of the colon caused by neural malformation of the _____ nervous system
January 13, 2021What is your evaluation of the effectiveness of the U.S. health care system in the context of delivery, finance, management, and/or sustainability?
January 13, 2021Make-Graphs-with-data-data-presentation-assignment-help- Nursing Writers Hub
Data Presentation Assignment
Complete the following using Excel spreadsheet software. If you wish, you may create one file for each number.
Construct a two variable bar graph comparing the ages of death of males and females for the grouped frequency distribution (see data below).
Age Group
Males
Females
Total
80-89
2
3
5
70-79
2
1
3
60-69
2
4
6
50-59
4
5
9
40-49
4
2
6
30-39
2
1
3
20-29
0
1
1
10-19
0
0
0
0-9
1
1
2
Construct a two variable bar graph comparing the number of deaths under 48 hours and over 48 hours (see data below).
Deaths
Year
Under 48 hours
Over 48 hours
2000
72
253
2001
68
278
2002
64
268
2003
58
254
2004
52
246
Construct a line graph of autopsy rates, comparing the percentage of deaths that were unautopsied versus those that were autopsied or were coroner’s cases (see data below).
Year
Unautopsied
Autopsies
Coroner
#
%
#
%
#
%
2000
312
247
79
58
19
7
2
2001
344
281
82
52
15
11
3
2002
338
273
81
55
16
10
3
2003
310
264
85
41
13
5
2
2004
323
272
84
47
15
15
1
Construct a histogram showing the frequency distribution of the lengths of stay of patients at least 1 year old that underwent neurosurgery (see data below).
LOS (days)
Frequency
33-34
1
31-32
0
29-30
0
27-28
0
25-26
0
23-24
0
21-22
1
19-20
1
17-18
0
15-16
1
13-14
4
11-12
1
9-10
1
7-8
6
5-6
14
3-4
24
1-2
21
Semiannual surgical records reveal the following number of surgical procedures performed on inpatients, and their respective percentages. Construct a pie graph to represent the data below.
Procedure by Medical Specialty
Number of Procedures
%
Cardiovascular surgery
62
18
Thoracic/Pulmonary surgery
36
10
ENT surgery
12
3
General surgery
111
32
Neurosurgery
5
1.5
Orthopedic surgery
57
16
Urologic surgery
27
8
Gynecologic surgery
40
11.5
The average length of stay (number of days) for the years 1980, 1990 and 2000, by age groups were recorded. Construct a 3 variable bar graph to represent the data below.
Age
1980
1990
2000
<5 years
7.8
6.2
5.2
5-14 years
4.3
5.2
5.0
15-44 years
7.6
5.4
4.4
45-64 years
10.7
6.7
5.6
65-74 years
11.9
8.0
6.5
75+ years
12.4
8.9
7.7
All ages
8.9
6.7
5.6
The average length of stay (number of days) for the years 1980, 1990 and 2000, by geographic region, were also recorded. Construct a 3 variable bar graph to represent the data below.
Region
1980
1990
2000
Northeast
10.1
7.3
6.9
Midwest
8.7
6.2
5.0
South
8.2
6.7
5.6
West
8.9
6.3
5.4
Pretend that you have just aggregated the data below. You now need to present this to me, your supervisor. Create 3 graphs to show me the 3 most significant findings you can identify from the data. (You determine the significance – there is no correct answer.) Show me some interesting stuff so I don’t have to spend a lot of time analyzing the data myself.
The number of cases of cancer per 100,000 population for the years 1980, 1985, 1990, 1995 and 2000 were recorded as follows:
Population
1980
1985
1990
1995
2000
White males:
Colorectal
58.7
63.4
59.0
53.0
48.1
Pancreatic
11.1
10.7
10.1
9.8
9.2
Lung & bronchial
82.2
82.0
80.9
74.5
71.2
Non-Hodgkin’s lymphoma
12.6
15.9
19.6
20.6
20.8
Prostate
78.8
87.1
133.0
140.0
129.8
Black males:
Colorectal
63.5
60.8
59.7
59.8
53.5
Pancreatic
17.6
19.7
15.4
17.4
15.1
Lung & bronchial
131.0
131.3
118.6
113.3
115.7
Non-Hodgkin’s lymphoma
9.3
10.0
14.2
17.9
18.6
Prostate
126.7
133.6
173.3
245.7
210.1
White females:
Colorectal
44.7
45.9
40.2
37.0
36.4
Pancreatic
7.3
8.1
7.7
7.6
7.2
Lung & bronchial
28.2
35.9
42.5
44.5
44.0
Non-Hodgkin’s lymphoma
9.2
11.4
12.9
13.5
12.4
Breast
87.8
107.2
114.4
114.8
115.7
Black females:
Colorectal
49.6
45.9
49.5
46.9
43.3
Pancreatic
13.0
11.3
10.3
12.0
12.5
Lung & bronchial
33.8
40.2
46.9
49.3
42.7
Non-Hodgkin’s lymphoma
6.0
7.1
9.3
7.2
9.5
Breast
74.3
92.5
97.7
101.9
101.3
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
"Is this question part of your assignment? We Can Help!"
