Make Graphs with data, data presentation assignment help

Jul 15th, 2016
Steve1995
Category:
Other
Price: $10 USD

Question description

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


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR

Males
1
0
0
2
4
4
2
2
2

Females
1
0
1
1
2
5
4
1
3

Total
2
0
1
3
6
9
6
3
5

Graph of Age Gr

8
7
6

Frequencies

Age_Group
0-9
10-19
20-29
30-39
40-49
50-59
60-69
70-79
80-89

5
4
3
2
1

1

1
0
0-9

Graph of Age Group Against of Death between
Male and Female
Males

Females

5
4

4

4
3

2
1
0

0

10-19

2

1

1

20-29

30-39

2

2

2
1

0
40-49
50-59
Age Group

60-69

70-79

80-89

Under 48 hours
2000
2001
2002
2003
2004

72
68
64
58
52

Over 48 hours
253
278
268
254
246

A Comparison G

300
253
250
200

Frequencies

Year

150
100

72

50
0
2000

A Comparison Graph of Deaths Under and
Over 48 hour
Under 48 hours

Over 48 hours

278

268

254

253

68

2000

2001

64

2002
Years

58

2003

246

52

2004

Years

2000
2001
2002
2003
2004

Deaths
312
344
338
31...

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
pmallory
Dec 10th, 2016
" Totally impressed with results!! :-) "
mixedballz
Dec 1st, 2016
" excellent work as always thanks for the help "
Five Star Tutor
Nov 25th, 2016
" Outstanding Job!!!! "
kiln82
Nov 17th, 2016
" awesome work thanks "
darnay
Nov 8th, 2016
" The best tutor out there!!!! "
likeplum4
Nov 4th, 2016
" Excellent work as usual "
kpcutie
Oct 12th, 2016
" Excellent job "
Joemoe
Oct 3rd, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors