The second link gives the average global temperature over about thelast century. Repeat the process described above. Again figure outa way to change the "time" data to the correct months and years inthe current calendar scheme. Here you run into a problem.Spreadsheets don't recognize dates before January 1, 1904 (forMacs) or January 1, 1900 (for PCs). So if you get an error withyour formula, don't worry. Just copy it on down the column and makeyour graph from the data after 1900 or 1904. Then make a graph ofthe data, giving it clear titles, labels, etc. Print out yourgraph, but don't print all the data! Now answer these questions ona separate sheet.
1) What is the approximate rate of increase in the globaltemperature (in number of degrees Celsius per decade, forinstance)?
2) What is this rate in number of degrees Fahrenheit per decade?(Careful, you can't convert a change in temperature the same wayyou convert a single temperature.)
3) If this approximate trend continues, what will be the averageglobal temperature in both degrees Fahrenheit and degrees Celsius100 years from now?
Thewebsite-http://iridl.ldeo.columbia.edu/SOURCES/.Indices/.HANSON/.Global/.Annual/.Temperature/T+exch+table-+text+text+skipanyNaN+-table+.html