Make-Graphs-with-data-data-presentation-assignment-help-
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 |
Deaths |
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 |