2. You will be using this data to make three plots; the homework assignment will consist of these three plots, your interpretation of these plots, and some additional questions about the nature of the data. You will be looking at four sets of numbers for about 150 different countries.
a. Per Capita Actual Renewable Water Resources
b. % Access to an improved water source in 2004
c. % Access to improved sanitation in 2004
d. per capita gdp
3. Click on "Actual Renewable Water Resources: Per capita" at EarthTrends: The Environmental Information Portal, select "...or retrieve all data for this variable." and click on "View Technical Notes". Succinctly describe in your own words what is it that "Actual Renewable Water Resources: Per capita" measures.
4. Click on "Water and Sanitation: Access to an improved water source" at EarthTrends: The Environmental Information Portal, select "...or retrieve all data for this variable." and click on "View Technical Notes". Succinctly describe in your own words what is it that "Access to an improved water source" measures.
5. Click on "Water and Sanitation: Access to improved sanitation" at EarthTrends: The Environmental Information Portal, select "...or retrieve all data for this variable." and click on "View Technical Notes". Succinctly describe in your own words what is it that "Access to improved sanitation" measures.
6. Use the power of the internet to find a definition for per capita GDP. Succinctly describe in your own words what is it that per capita GDP measures.
7. Plot 1: in excel, plot % Access to improved water source in 2004 (y-axis) as a function of 2006 & 2007 average Per Capita Actual Renewable Water Resources (Cubic meters (m^3) per person per year) normalized to % of world average (x-axis)(highlight your two columns of interest and "insert" an (xy) scatter (plot) with only markers). Modify the x-axis so that it is logarithmic (right-click on one of the numbers on the axis, select "format axis" and then click the box next to "Logarithmic Scale"). Print out the graph, label the axis, and succinctly describe any trends that are evident in the data; specifically, how do any observed trends compare with any trends that you might have predicted?
8. Plot 2: in excel, plot % Access to improved water source in 2004 (y-axis) as a function of per capita gdp as % of world average (x-axis)(highlight your two columns of interest and "insert" an (xy) scatter (plot) with only markers). Modify the x-axis so that it is logarithmic (right-click on one of the numbers on the axis, select "format axis" and then click the box next to "Logarithmic Scale"). Print out the graph, label the axis, and succinctly describe any trends that are evident in the data; specifically, how do any trends compare with any trends that you might have predicted?
9. Plot 3: in excel, plot % Access to improved sanitation in 2004 (y-axis) as a function of per capita gdp as % of world average (x-axis) (highlight your two columns of interest and "insert" an (xy) scatter (plot) with only markers). Modify the x-axis so that it is logarithmic (right-click on one of the numbers on the axis, select "format axis" and then click the box next to "Logarithmic Scale"). Print out the graph, label the axis, and succinctly describe any trends that are evident in the data; specifically, how do any trends compare with the trends from Plot 2?
10. Sort the data by “% Access to an improved water source in 2004”. When you look through the list of data, is there any general inference to be made about the different regions of the world? That is, do some regions’ countries tend to belong in one end of the spectrum, or in the middle? The regions are: Europe, The Middle East, Asia, Africa, South America, Oceania and North America.
11. This homework assignment is is due Friday, April 2 at the beginning of class as a printed hard copy.
No comments:
Post a Comment