Wasnesky
Analyzing Air Quality
During this lab you will be using the internet to collect information and Microsoft Excel to organize your data.
Use the following web pages:
1) Find out how many people live in the following counties:
- Monmouth Co., NJ
- Chittenden Co., VT
- New York Co., NY
- Cook Co., IL
- Harrision Co., MS
- Los Angeles Co., CA
- Missoula Co., MT
- Juneau City, AK
- King Co., WA
- El Paso Co., CO
- Miami-Dade Co., FL
- Suffolk Co., MA
- Coconino Co., AZ
- Franklin Co., OH
- Humboldt Co., CA
- Wayne Co., MI
- Jackson Co., MO
- Hudson Co., NJ
- Penobscot Co., ME
- Teton Co., WY
2) Look up air quality data for ACTIVE OUTDOORS for each of the above counties. Record how many “Unhealthy Days” they had last year.
3) Use Excel to organize and graph the two sets of data. When you have your graph, right click on any “# of unhealthy days” data point. Then, click on “format data series” and then select SECONDARY AXIS on the far right. This will allow you to graph the large population numbers along with the smaller number of days on the same graph. Then adjust the format of your graph to make as easy to read as possible.
Results
Copy and paste your graph into a MS Word document and use it to answer the following questions:
- Is there a relationship between county population and unhealthy air quality? Why or why not? Explain.
Yes there is greater unhealthy air quality in
- Is there a county that has a large population but good air quality? Why might this be? Conversely, does the opposite happen? Again, why?
- Which county had the greatest number of unhealthy days last year? Why do you think this is (research the county if you need to)?
- Besides population size, what other factors could be at play here?
- If you were plotting the population sizes of twenty various countries would you expect there to be a direct relationship to amount of air pollution. Why or why not? Explain.
- Name ten things you can do to improve air quality in MonmouthCounty.