WEATHER OR NOT
Making Graphs with Excel

For this assignment, you will be using Excel to produce TWO high-quality data sets and TWO related graphs. The first will show weather trends, and the second will be your choice. You will have to find the data, enter it into your spreadsheet in the correct format, and then create a graph that clearly shows your data trends. You should choose the graph format carefully, as it will ultimately determine how your complex data set is shown.

Guidelines:

-For your first chart, choose three different cities (anywhere on earth) and one weather variable (for example “rainfall in inches”). Then enter the data over a period of twelve months (January to December), and make a chart from this. Get your information here: http://www.weatherbase.com/


For your other chart/graph, choose ONE of the following:

A. Baseball Stats, 2002 to 2004 (three years). Pick ONE batting, pitching or fielding statistic (for example, “home runs” or “strike outs”) and FIVE different players. Find data for the 2002, 2003, and 2004 seasons, and make a chart. Get your data here::
http://sports.espn.go.com/mlb/statistics

B. Nonstop Round-the-world Sailing Records, 1968-present. List the names of the yachts that broke this important record and chart their corresponding times in days. Get your data here:
http://www.sailspeedrecords.com/roundnonstop.html

C. Internet domain names, 1996 to 2001. Use .COM, .NET, and .EDU, and chart how many registered domain names there were every year from 1996 to 2001. Use the data from the CLOSEST MONTH TO JANUARY that is posted. Get your data here:
http://www.ngi.org/trends.htm

D. PRICE COMPARISONS: Come up with a list of two different items that you would like to buy. Then find the prices for each of the items at 5 stores on the internet. Use FROOGLE.COM or SHOPPING .COM.

E.



Remember:
-Put a clear and accurate graph title and labels on the x- and y-axis.
-Pick a graph type that suits your data.
-Use simple colors and font types.

Extra Credit: Do three or four charts total (One with the weather and two or more from the list.)