BONUS: Problem 2: (20 Points) Global Temperature contains global temperature estimates from 1880- 2007 from NASA global temperature estimates at http://data.giss.nasa. gov/gistemp/tabledata/GLB.Ts.txt a) Use any Excel function of your choice to compute the Average temperature in both Celsius and Fahrenheit for each Decade. Tabulate the results on the Excel worksheet. A sample table is shown below: Decade Average (Celsius) Average (Fahrenheit) b) Using any visual analytics method, display the results obtained in (a) with a Visual chart.

Year	Decade	Celsius	Fahrenheit
1880	1880	13.89	57.002
1881	1880	13.87	56.966
1882	1880	13.99	57.182
1883	1880	13.94	57.092
1884	1880	13.57	56.426
1885	1880	13.76	56.768
1886	1880	13.73	56.714
1887	1880	13.53	56.354
1888	1880	13.75	56.750
1889	1880	14.05	57.290
1890	1890	13.78	56.804
1891	1890	13.44	56.192
1892	1890	13.59	56.462
1893	1890	13.60	56.480
1894	1890	13.67	56.606
1895	1890	13.68	56.624
1896	1890	13.72	56.696
1897	1890	13.85	56.930
1898	1890	13.80	56.840
1899	1890	13.75	56.750
1900	1900	13.94	57.092
1901	1900	13.95	57.110
1902	1900	13.70	56.660
1903	1900	13.65	56.570
1904	1900	13.58	56.444
1905	1900	13.75	56.750
1906	1900	13.85	56.930
1907	1900	13.60	56.480
1908	1900	13.70	56.660
1909	1900	13.70	56.660
1910	1910	13.80	56.840
1911	1910	13.75	56.750
1912	1910	13.67	56.606
1913	1910	13.72	56.696
1914	1910	13.98	57.164
1915	1910	14.05	57.290
1916	1910	13.80	56.840
1917	1910	13.54	56.372
1918	1910	13.66	56.588
1919	1910	13.92	57.056
1920	1920	13.83	56.894
1921	1920	13.96	57.128
1922	1920	13.91	57.038
1923	1920	13.84	56.912
1924	1920	13.88	56.984
1925	1920	13.84	56.912
1926	1920	14.04	57.272
1927	1920	13.95	57.110
1928	1920	13.99	57.182
1929	1920	13.77	56.786
1930	1930	13.97	57.146
1931	1930	14.02	57.236
1932	1930	14.04	57.272
1933	1930	13.89	57.002
1934	1930	14.05	57.290
1935	1930	13.92	57.056
1936	1930	14.02	57.236
1937	1930	14.12	57.416
1938	1930	14.15	57.470
1939	1930	13.98	57.164
1940	1940	14.14	57.452
1941	1940	14.12	57.416
1942	1940	14.11	57.398
1943	1940	14.06	57.308
1944	1940	14.11	57.398
1945	1940	13.99	57.182
1946	1940	14.01	57.218
1947	1940	14.12	57.416
1948	1940	13.98	57.164
1949	1940	13.92	57.056
1950	1950	13.83	56.894
1951	1950	13.98	57.164
1952	1950	14.04	57.272
1953	1950	14.12	57.416
1954	1950	13.91	57.038
1955	1950	13.92	57.056
1956	1950	13.82	56.876
1957	1950	14.08	57.344
1958	1950	14.10	57.380
1959	1950	14.05	57.290
1960	1960	13.98	57.164
1961	1960	14.10	57.380
1962	1960	14.05	57.290
1963	1960	14.02	57.236
1964	1960	13.75	56.750
1965	1960	13.85	56.930
1966	1960	13.92	57.056
1967	1960	13.98	57.164
1968	1960	13.91	57.038
1969	1960	14.00	57.200
1970	1970	14.04	57.272
1971	1970	13.90	57.020
1972	1970	13.95	57.110
1973	1970	14.18	57.524
1974	1970	13.94	57.092
1975	1970	13.98	57.164
1976	1970	13.79	56.822
1977	1970	14.16	57.488
1978	1970	14.07	57.326
1979	1970	14.14	57.452
1980	1980	14.28	57.704
1981	1980	14.40	57.920
1982	1980	14.09	57.362
1983	1980	14.34	57.812
1984	1980	14.15	57.470
1985	1980	14.12	57.416
1986	1980	14.18	57.524
1987	1980	14.35	57.830
1988	1980	14.39	57.902
1989	1980	14.26	57.668
1990	1990	14.48	58.064
1991	1990	14.44	57.992
1992	1990	14.15	57.470
1993	1990	14.19	57.542
1994	1990	14.32	57.776
1995	1990	14.46	58.028
1996	1990	14.39	57.902
1997	1990	14.41	57.938
1998	1990	14.71	58.478
1999	1990	14.46	58.028
2000	2000	14.42	57.956
2001	2000	14.57	58.226
2002	2000	14.69	58.442
2003	2000	14.67	58.406
2004	2000	14.60	58.280
2005	2000	14.76	58.568
2006	2000	14.65	58.370
2007	2000	14.73	58.514