In this lab, you will investigate the correlation between weather and air quality, by reviewing trends in air quality for ozone and particulate matter in your local area over the past year. Develop two hypotheses:  About the impact of the time of year on ozone levels, and  About the impact of the time of the year on the level of particulate matter in the air. Then, 1. Download the SC236: Lab Two Microsoft® Excel® file from Doc Sharing. Note: If you do not have Microsoft Excel, you can search the Web for a free downloadable graph maker, or you can use the online graph-making tool from the National Center for Educational Statistics: National Center for Education Statistics. (n.d.). Create a graph. Retrieved from http://nces.ed.gov/nceskids/createAgraph/default.a… 2. Visit the AirNow website at http://www.airnow.gov and type your Zip Code in the Local Air Quality Conditions menu (top, right-hand side of the page). 3. Review today’s Daily Air Quality Index (AQI) Ozone levels and record this information under the Ozone AQI column for this month in the SC236: Lab Two Microsoft Excel file. 4. Review today’s Daily AQI PM2.5 and record this information under the Particulate (AQI) SC236: Lab Two Microsoft Excel file. 5. Select a date that is one month earlier and repeat Steps 4 and 5. Repeat this process until you have Ozone and PM2.5 AQI values for each month of the past year. 6. Next, review the graphs in the SC236: Lab Two Microsoft Excel file. If you do not have Microsoft Excel, create a line graph that displays dates on the x-axis and Particulate Matter Daily 24-Hour AQI values on the y-axis.

For order inquiries        1-800-700-6200

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp