Data Presentation Assignment

Complete the following using Excel spreadsheet software.  If you wish, you may create one file for each
number. 

1. 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

1. 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

1. 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

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

1. 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

1. 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

1. 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

1. 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