Using excel, guess the temperature of the earth in 2050 from the data below Year temperature (°C) 1880 -0.161881 -0.081882-0.11883-0.161884-0.281885-0.331886-0.311887-0.361888-0.171889-0.11890-0.351891-0.221892-0.271893-0.311894-0.31895-0.221896-0.111897-0.11898-0.271899-0.081900-0.151901-0.281902-0.371903-0.471904-0.261905-0.221906-0.391907-0.431908-0.431909-0.481910-0.431911-0.441912-0.361913-0.341914-0.151915-0.141916-0.361917-0.461918-0.31919-0.271920-0.271921-0.191922-0.291923-0.271924-0.271925-0.221926-0.111927-0.221928-0.21929-0.361930-0.161931-0.11932-0.161933-0.291934-0.121935-0.21936-0.151937-0.03193801939-0.0219400.1219410.1819420.0619430.0919440.219450.091946-0.071947-0.031948-0.111949-0.111950-0.171951-0.0719520.0119530.081954-0.131955-0.141956-0.1919570.0519580.0619590.031960-0.0319610.0619620.0319630.051964-0.21965-0.111966-0.081967-0.021968-0.0819690.0519700.031971-0.0819720.0119730.161974-0.071975-0.011976-0.119770.1819780.0719790.1619800.2619810.3219820.1419830.3119840.1619850.1219860.1819870.3219880.3919890.2719900.4519910.4119920.2219930.2319940.3219950.4519960.3319970.4719980.6119990.3920000.420010.5420020.6320030.6220040.5420050.6820060.6420070.6620080.5420090.6620100.7220110.6120120.6520130.6820140.7420150.920161.0120170.9220180.8520190.9820201.02

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter1: Fundamental Concepts Of Algebra
Section1.4: Fractional Expressions
Problem 66E
icon
Related questions
Question
100%

Using excel, guess the temperature of the earth in 2050 from the data below

Year temperature (°C)

1880 -0.161881 -0.081882-0.11883-0.161884-0.281885-0.331886-0.311887-0.361888-0.171889-0.11890-0.351891-0.221892-0.271893-0.311894-0.31895-0.221896-0.111897-0.11898-0.271899-0.081900-0.151901-0.281902-0.371903-0.471904-0.261905-0.221906-0.391907-0.431908-0.431909-0.481910-0.431911-0.441912-0.361913-0.341914-0.151915-0.141916-0.361917-0.461918-0.31919-0.271920-0.271921-0.191922-0.291923-0.271924-0.271925-0.221926-0.111927-0.221928-0.21929-0.361930-0.161931-0.11932-0.161933-0.291934-0.121935-0.21936-0.151937-0.03193801939-0.0219400.1219410.1819420.0619430.0919440.219450.091946-0.071947-0.031948-0.111949-0.111950-0.171951-0.0719520.0119530.081954-0.131955-0.141956-0.1919570.0519580.0619590.031960-0.0319610.0619620.0319630.051964-0.21965-0.111966-0.081967-0.021968-0.0819690.0519700.031971-0.0819720.0119730.161974-0.071975-0.011976-0.119770.1819780.0719790.1619800.2619810.3219820.1419830.3119840.1619850.1219860.1819870.3219880.3919890.2719900.4519910.4119920.2219930.2319940.3219950.4519960.3319970.4719980.6119990.3920000.420010.5420020.6320030.6220040.5420050.6820060.6420070.6620080.5420090.6620100.7220110.6120120.6520130.6820140.7420150.920161.0120170.9220180.8520190.9820201.02

Year
Temperature (*C)
1880
-0.16
1881
-0.08
1882
-0.1
1883
-0.16
1884
-0.28
1885
-0.33
1886
-0.31
1887
-0.36
1888
-0.17
1889
-0.1
1890
-0.35
1891
-0.22
1892
-0.27
1893
-0.31
1894
-0.3
1895
-0.22
1898
-0.11
1897
-0.1
1898
-0.27
1899
-0.08
1900
-0.15
1901
-0.28
1902
-0.37
1903
-0.47
1904
-0.26
1905
-0.22
1908
-0.30
1907
-0.43
1908
-0.43
1909
-0.48
1910
-0.43
1911
-0.44
1912
-0.36
1913
-0.34
1914
-0.15
1915
-0.14
1916
-0.36
1917
-0.46
1918
-0.3
1919
-0.27
1920
-0.27
1921
-0.19
1922
-0.29
1923
-0.27
1924
-0.27
1925
-0.22
1926
-0.11
1927
-0.22
1928
-0.2
1929
-0.36
1930
-0.16
1931
-0.1
1932
-0.16
1933
-0.29
1934
-0.12
1935
-0.2
1936
-0.15
1937
-0.03
1938
1939
-0.02
1940
0.12
1941
0.18
1942
0.06
1943
0.00
1944
0.2
1945
0.00
1946
-0.07
1947
-0.03
1948
-0.11
1949
-0.11
1950
-0.17
1951
-0.07
1952
0.01
1953
0.08
1954
-0.13
1955
-0.14
1956
-0.19
1957
0.05
1958
0.06
1959
0.03
1980
-0.03
Transcribed Image Text:Year Temperature (*C) 1880 -0.16 1881 -0.08 1882 -0.1 1883 -0.16 1884 -0.28 1885 -0.33 1886 -0.31 1887 -0.36 1888 -0.17 1889 -0.1 1890 -0.35 1891 -0.22 1892 -0.27 1893 -0.31 1894 -0.3 1895 -0.22 1898 -0.11 1897 -0.1 1898 -0.27 1899 -0.08 1900 -0.15 1901 -0.28 1902 -0.37 1903 -0.47 1904 -0.26 1905 -0.22 1908 -0.30 1907 -0.43 1908 -0.43 1909 -0.48 1910 -0.43 1911 -0.44 1912 -0.36 1913 -0.34 1914 -0.15 1915 -0.14 1916 -0.36 1917 -0.46 1918 -0.3 1919 -0.27 1920 -0.27 1921 -0.19 1922 -0.29 1923 -0.27 1924 -0.27 1925 -0.22 1926 -0.11 1927 -0.22 1928 -0.2 1929 -0.36 1930 -0.16 1931 -0.1 1932 -0.16 1933 -0.29 1934 -0.12 1935 -0.2 1936 -0.15 1937 -0.03 1938 1939 -0.02 1940 0.12 1941 0.18 1942 0.06 1943 0.00 1944 0.2 1945 0.00 1946 -0.07 1947 -0.03 1948 -0.11 1949 -0.11 1950 -0.17 1951 -0.07 1952 0.01 1953 0.08 1954 -0.13 1955 -0.14 1956 -0.19 1957 0.05 1958 0.06 1959 0.03 1980 -0.03
1962
0.03
1963
0.05
1964
-0.2
1965
-0.11
1968
-0.08
1967
-0.02
1968
-0.08
1969
0.05
1970
0.03
1971
-0.08
1972
0.01
1973
0.16
1974
-0.07
1975
-0.01
1976
-0.1
1977
0.18
1978
0.07
1979
0.16
1980
0.26
1981
0.32
1982
0.14
1983
0.31
1984
0.16
1985
0.12
1986
0.18
1987
0.32
1988
0.39
1989
0.27
1990
0.45
1991
0.41
1992
0.22
1993
0.23
1994
0.32
1995
0.45
1996
0.33
1997
0.47
1998
0.61
1999
0.39
2000
0.4
2001
0.54
2002
0.63
2003
0.62
2004
0.54
2005
0.68
2006
0.64
2007
0.66
2008
0.54
2009
0.66
2010
0.72
2011
0.61
2012
0.65
2013
0.68
2014
0.74
2015
0.9
2018
1.01
2017
0.92
2018
0.85
2019
0.98
2020
1.02
Transcribed Image Text:1962 0.03 1963 0.05 1964 -0.2 1965 -0.11 1968 -0.08 1967 -0.02 1968 -0.08 1969 0.05 1970 0.03 1971 -0.08 1972 0.01 1973 0.16 1974 -0.07 1975 -0.01 1976 -0.1 1977 0.18 1978 0.07 1979 0.16 1980 0.26 1981 0.32 1982 0.14 1983 0.31 1984 0.16 1985 0.12 1986 0.18 1987 0.32 1988 0.39 1989 0.27 1990 0.45 1991 0.41 1992 0.22 1993 0.23 1994 0.32 1995 0.45 1996 0.33 1997 0.47 1998 0.61 1999 0.39 2000 0.4 2001 0.54 2002 0.63 2003 0.62 2004 0.54 2005 0.68 2006 0.64 2007 0.66 2008 0.54 2009 0.66 2010 0.72 2011 0.61 2012 0.65 2013 0.68 2014 0.74 2015 0.9 2018 1.01 2017 0.92 2018 0.85 2019 0.98 2020 1.02
Expert Solution
steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning