Description
Lab Exercise: Analyzing and Mapping Historic Weather Data (30 points)
For this lab, you will analyze weather data for one city or region over a 50-year period. You will use Microsoft Excel to create a spreadsheet and graph. Note: If you do not have Microsoft Office, click here to access OPEN OFFICE software. To learn how to use Microsoft Excel, click here or here.
- Using the following website, select a city or region. http://www.ncdc.noaa.gov/cag/time-series/us
- In the attached spreadsheet, record the high annual temperatures, low annual temperatures, and the annual precipitation since 1965.
- Determine the average for the 50-year period (see instruction attachment for help) for each variable.
- Determine the difference from the 50-year average for each year.
- Create a graph for the difference.
- In a Word document, explain your assessment of the differences from 1965 to 2015 for each of the three variables.
Answer the following questions:
- View the animation at http://apod.nasa.gov/apod/ap130731.html. Assess the differences from 1884 to 2011. What areas of the world seem to have changed the most?
- How has it changed in your part of the world?
- Review the anomaly map at https://www.ncdc.noaa.gov/sotc/global/201513. Choose one anomaly outside the US and explain the situation, when, where, and why it was abnormal.
- In your birthplace, where ever in the world it is, briefly describe the major weather anomalies in the past decade.
Attach both the Microsoft Word and Excel files in the assignment area.
Your paper should meet the following requirements:
- 3-4 pages in length (excluding the Excel worksheet)
- 1-2 outside sources
- Formatted according to the CSU-Global Guide to Writing and APA Requirements.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
attached is my answer
Solution to Mapping Historic Weather Data Map
Solution to Mapping Historic Weather Data Map
Student’s Name
Course’s Name
Professor’s Name
Institution
Due Date
1
Solution to Mapping Historic Weather Data Map
2
Solution to Mapping Historic Weather Data Map
Summary of Results
In terms of average annual precipitation, the high precipitation better than expected for
the fifty years happened in the times of 1977, 1982, 1992, 1994, 1999, 2009, 1997 and 1979 with
the exceptionally most elevated happening in 1976 which was 8.9 creeps better than expected,
1963 chronicle 8.5 crawls better than expected and 1981 recorded 8.43 creeps better than
expected. These years could have recorded these high rainfalls better than expected because of
the tropical storm in San Diego, which is located at the west of California. Minimal high better
than expected happened in 2006 which recorded 0.76 creeps better than expected as portrayed in
the lab information and the diagram. From 1969 to 1974 San Diego recorded precipitation
underneath normal for the fifty years. The most noteworthy precipitation beneath normal was
recorded in 1988 which was - 6.4 inches, 2001 was - 6.0 inches and 2006 were - 5.94 crawls with
the least underneath normal being in 2004 which was - 0.40 inches.
In terms of high annual temperatures, from the year 1975 to 1985 temperatures were
better than expected with the most elevated better than expected being 2015 and 2016. These two
years have recorded 3.69 o F and 3.79 o F separately. These nonstop most extreme temperatures
better than expected in San Diego might be a reasonable indication of an unnatural weather
change that has its impact being felt around the world. The least most extreme temperatures
beneath normal happened in the times of 1965 to 1975 this is when there was less contamination
and in this way, an unnatural weather change had not produced results. With the most reduced
beneath normal being in 1970 with - 10.63 o F. Despite the fact that 1999, 2000,2001,2008 and
2011 recorded underneath normal greatest temperatures appropriate challenging a dangerous
atmosp...