Week 5 Tasks

Learning how to Graph

First, go through the tutorial on how to graph data in Excel.  Learn how to graph with one variable and then with two variables.  Go through the tutorials by click here:  One Variable    Two Variables

Please note that you can do this via Excel or PowerPoint.

Now, go into your files of the three counties that you have been assigned.   This is the same file that you created last week.

Create a bar graph for population of age 7-9 for each of the three counties.
Create a line graph for population of age 30-34 for each of three counties.
Create a histogram  for population of age 62-64 for each of three counties.

Take the following information from SIU's ORDA and place it in two pie charts.   You decide what information needs to be shared to best represent the figures indicated in the table.

Number of Grants Obtained in 1996 Total Dollar Figure of Grants, 1996 Number of Grants Obtained in 1995 Total Dollar Figure of Grants, 1995
Research 47 1883203 35 6190706
Training 9 366406 20 272999
Other 18 457227 19 2018180
Federal 16 1441244 18 892341
State 5 343881 18 7060673
Industry 28 614842 10 270325
Foundation 3 47900 4 60642
Other 22 258969 24 197904

Once you have created all of the required graphs, email them to me at kittleson@hotmail.com