Marketing Assignments

profileiam llc
cancergraphinginstructions.doc

Graphing/Charting Project

Below is data obtained from the National Cancer Society with projections for the number of newly diagnosed cancer patients through 2050 broken out by age.

image1.wmf

Age of Newly Diagnosed Cancer Patients

Year

<50

50-64

65-74

75-84

>85

2000

0.17

0.38

0.35

0.31

0.14

2010

0.17

0.46

0.57

0.34

0.14

2020

0.17

0.55

0.68

0.40

0.20

2030

0.18

0.60

0.70

0.62

0.16

2040

0.23

0.59

0.69

0.71

0.28

2050

0.22

0.68

0.65

0.70

0.42

Note: .17 equals 170,000 for example

Instructions:

Prepare one slide that graphically best presents this data and make appropriate observations. It would be interesting to try and show if the number of cancer patients are going up year after year and how the distribution by age range is also changing, all in one graphical representation. A stacked bar chart or area chart might serve this purpose well.