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. 

  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

 
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.