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

The Answer is in the image, click to view ...

Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

1: Describe and explain the terms climate sensitivity, fat tail, and low beta, and how they relate to climate change. 2: What are the estimated economic costs of global warming? Can we trust these...

Chapter 3 Describe and explain the terms climate sensitivity, fat tail, and low beta, and how they relate to climate change. What are the estimated economic costs of global warming? Can we trust...

Financial Impacts of Climate Change: Invest or Not? It was a sunny Friday afternoon in downtown Denver, CO, and Skylar Morrisoni was enjoying a muchneeded break in the common area of her venture...

By MARK@ (Ruska, Markevichus, Naniev, Grachev) Emerging russian ice-cream market is good area for different producers as it has great potential 1. Currently Russian ice-cream market is the 4th...

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

I have attached the question. I will post student question when I receive one later. Chapter 2, Customer Behavior and 3, Segmentation of textbook can also be used. Marketing Management: MKT500 Week 1...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

The switch in Figure P28.66a closes when Vc > 2V/3 and opens when Vc Ri Ro Voltage- contolled switch 24 '

1 (one) kg of air at an initial pressure of 8 bar and 100 C is expanded polytropically with n = 1,2 so that the pressure drops as much as one-fifth of the initial pressure. Determine: a. Specific...

Intro Lugget Copp, has one bond issue outstanding with an annual coupon of 3 . 9 m , a face value of $ 1 , 0 0 0 and a price of $ 9 1 5 . 0 6 , which matures in 1 0 years. The company's tax rate is 3...

Auditors must obtain sufficient appropriate audit evidence to afford a reasonable basis for the opinion. Briefly explain what is meant by "sufficient appropriate audit evidence".

18. In the statements below, put a cross for the statement you feel characterizes yourself best when you communicate with others. Its not necessarily the way you know you should communicate, but the...

10. What activities in your life best express the value you want others to associate with you?

7. Also complete the following sentence: This core value is important to me when I ________________________. This is the situation this core value is important to you we are looking for here.