Analyzing and Mapping Historic Weather Data

User Generated

Auneevf2

Science

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.

  1. Using the following website, select a city or region. http://www.ncdc.noaa.gov/cag/time-series/us
  2. In the attached spreadsheet, record the high annual temperatures, low annual temperatures, and the annual precipitation since 1965.
  3. Determine the average for the 50-year period (see instruction attachment for help) for each variable.
  4. Determine the difference from the 50-year average for each year.
  5. Create a graph for the difference.
  6. In a Word document, explain your assessment of the differences from 1965 to 2015 for each of the three variables.

Answer the following questions:

  1. 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?
  2. How has it changed in your part of the world?
  3. 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.
  4. 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:

Unformatted Attachment Preview

How to gather the data and create the graphs. First, go to http://www.ncdc.noaa.gov/cag/time-series/us collect the data. Select parameter, select Annual, select years, select state, select city or region. Click Plot. Next, look for the Download buttons, click on the excel icon. This will give you a list, which you can copy and paste into the excel spreadsheet. However, you will need to delete the extra info in each cell, so that you only have the temp or precip value. ← To calculate the average for each variable, highlight the 50 cells in each column. In the upper right side, find AutoSum. Click on the arrow for a menu, select Average. This will put the average at the bottom of the column. Next, in a new column, type into the cell =(column number row number – average). For example, in the diagram below, 1965 high temperature data starts in column C, row 7, and the average for the 50 years is 79. Thus, you would type into that cell, =(C7-79), and hit enter. Now, using the small black square in the lower right corner of the cell, click and drag down to the last row of data. This will copy the formula and adjust for the cell change, giving you the difference from the 50 year average. To graph this, highlight that column, then select the insert menu, click on line graph, and select 2-D line. This will put a graph on your screen, which you can move to a different part of the spreadsheet. Do this for each of the 3 variables. Lastly, in a Word document, write your analysis of what this data is telling you about the changes in the past 50 years. city name Year average high low annual annual temperature(oF) annual from 50 year temperature (oF) precipitation precipitation 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 deviation deviation deviation from 50 year from 50 year average high average low 2011 2012 2013 2014 2015
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags