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