Please answer all questions and show work!

Part 3: World Population Exponential 3. The relationship between time and world population is: (Circle one) Linear 5. State your observations about the actual data compared to the trendline. 6. Show your work and state the results of using Excel-generated trendline equation to predict the world population in 2020 and 2050. 2020 2050 7. Explain what real world phenomena could affect world population growth over time. Year Population Annual Growth Rate (%) Annual Population Change "Columns D and E are for informational purposes only and are not to be used when creating your scatterplot. The annual growth rate in particular might be of interest just to think about the growth en N 16 1956 1750 629,000,000 1800 813,000,000 1850 1,128,000,000 1900 1,550,000,000 1910 1,750,000,000 1920 1,860,000,000 1930 2,070,000,000 1940 2,300,000,000 1950 2,557,628,654 1951 2.594,938,936 1952 2,636,770,386 1953 2.682,050,452 1954 2,730,224,110 19552 .782,093.851 2,835,293,441 1957 2,891,342,302 1958 2.948,128,605 1959 3,000,706,677 1960 3,042,990,271 1961 3,084,007,286 1962 3,140,187,350 1963 3,209,978,774 1964 3,281,412,257 3,350,699,989 1966 3,421,015,609 1967 3.490,735,455 1968 3.562 786,611 1909 3,637,707,956 1970 3.713.327.08 1971 3.790,980,082 1972 3,867,242,256 1973 3,942,790,520 1974 4,017,323,955 1075 A MARRIN RO7 Part 2 - Weekly Earnings 19 20 21 37,310,282 41,831.450 45,280,066 48,173,658 51,869,741 1.912 53,199,590 56,048,861 1.964 56,786,303 1.783 52,578,072 1.409 42,283,594 1.348 41,017,015 1.822 56,180,064 2.223 69.791.424 2.225 71,433,483 2.112 69.287,732 2099 70,315,620 2038 69,719,846 2.064 72,051,156 2 103 74.921,345 2.079 75,619,942 2 091 77.652.184 2012 76.262.174 1.054 75,548.264 1.89 74,533,435 1.779 71,486,942 1714 76 077 090 Part 3 - World Population 1965 32 33 34 3 Part 4 - DJ's Albums Part 5 - Fox Trot Problem 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 50 51 4,017,323,955 4,088,810,897 4,158,888,836 4,229,748,034 4,300,631,215 4,374,349,678 4,445,423.675 4,526,817,917 4,607.193,353 4,688,582,743 4,767,669,177 4,849,860,549 4,934,211,409 5,021,085,089 5,108,736,553 5,195,979,089 5,284,252,039 5,367,488,662 5,452,187,873 5,534,418,049 5,614,530,098 5,695,823,105 5,776,327,747 5,854,841,500 5,932,024,858 6,008,646,651 6,084,703,879 6,160,890,093 6,237,154,134 6,313,942,570 6,390,636,309 6,467,431,499 6,545,218,993 6,623,523,655 6,702,159,402 6,780,833,881 1.779 71,486,942 1.714 70,077,939 1.704 70,859,198 1.676 70,883,181 1.714 73.718,463 1.625 71,073,997 1.831 81,394,242 1.776 80,375,436 1.767 81,389,390 1.687 79,086,434 1.724 82,191,372 1.739 84,350,860 1.761 86,873,680 1.746 87,651,464 1.708 87,242,536 1.699 88,272,950 1.575 83,236.623 1.578 84,699,211 1.508 82,230,176 1.448 80,112,049 1.448 81,293,007 1.413 80,504,642 1.359 78,513,753 1.318 77,183,358 1.292 76,621,793 1.266 76,057,228 1.252 76,186,214 1.238 76,264,041 1.231 76,788,436 1.215 76,693,739 1.202 76.795,190 1.203 77,787.494 1.196 78,304,662 1.187 78,635,747 1.174 78,674,479 1.147 77,750,874 Part 3 - World Population 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 69 Part 2 - Weekly Earnings %%%%%%%8a88 % 8% 9% 80n2z1zg7m 1993 1994 1995 1996 1997 | 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 68| 2008 692009 70 | 2010 2011 2012 73 2013 74 | 2014 2015 76 2016 77| 2017 5,534,418,049 5.614,530,098 5,695,823.105 5,776,327,747 15,854,841,500 5,932,024,858 6,008,646,651 6.084,703,879 6.160,890,093 6.237,154,134 6.313,942,570 6.390,636,309 6,467,431,499 16,545,218,993 6.623.523,655 6.702,159,402 6.780.833,881 6,858,584,755 6,935,999,491 7,013,871.313 7.092,128,094 7.169,968.185 7.247,892,788 7.325,996,709 7,405.107,650 1.448 1.448 1.413 1.359 1318 1292 11.266 1.252 1.238 1.231 1.215 1202 1.203 1.196 1.187 1.174 1.147 1.129 1.123 1116 1.098 1.087 1.078 1.08 1.053 80.112,049 81,293,007 80,504,642 78,513,753 77,183,358 76.621,793 76,057228 76,1861214 76.264,041 76,788,436 76,693,739 76795.190 77.787,494 78.304,662 78,635,747 78,674.479 77750,874 77,414,736 77.871.822 78,256.781 77,840,091 77.924,603 78,103,921 79.110,941 77,942,567 Part 3: World Population Exponential 3. The relationship between time and world population is: (Circle one) Linear 5. State your observations about the actual data compared to the trendline. 6. Show your work and state the results of using Excel-generated trendline equation to predict the world population in 2020 and 2050. 2020 2050 7. Explain what real world phenomena could affect world population growth over time. Year Population Annual Growth Rate (%) Annual Population Change "Columns D and E are for informational purposes only and are not to be used when creating your scatterplot. The annual growth rate in particular might be of interest just to think about the growth en N 16 1956 1750 629,000,000 1800 813,000,000 1850 1,128,000,000 1900 1,550,000,000 1910 1,750,000,000 1920 1,860,000,000 1930 2,070,000,000 1940 2,300,000,000 1950 2,557,628,654 1951 2.594,938,936 1952 2,636,770,386 1953 2.682,050,452 1954 2,730,224,110 19552 .782,093.851 2,835,293,441 1957 2,891,342,302 1958 2.948,128,605 1959 3,000,706,677 1960 3,042,990,271 1961 3,084,007,286 1962 3,140,187,350 1963 3,209,978,774 1964 3,281,412,257 3,350,699,989 1966 3,421,015,609 1967 3.490,735,455 1968 3.562 786,611 1909 3,637,707,956 1970 3.713.327.08 1971 3.790,980,082 1972 3,867,242,256 1973 3,942,790,520 1974 4,017,323,955 1075 A MARRIN RO7 Part 2 - Weekly Earnings 19 20 21 37,310,282 41,831.450 45,280,066 48,173,658 51,869,741 1.912 53,199,590 56,048,861 1.964 56,786,303 1.783 52,578,072 1.409 42,283,594 1.348 41,017,015 1.822 56,180,064 2.223 69.791.424 2.225 71,433,483 2.112 69.287,732 2099 70,315,620 2038 69,719,846 2.064 72,051,156 2 103 74.921,345 2.079 75,619,942 2 091 77.652.184 2012 76.262.174 1.054 75,548.264 1.89 74,533,435 1.779 71,486,942 1714 76 077 090 Part 3 - World Population 1965 32 33 34 3 Part 4 - DJ's Albums Part 5 - Fox Trot Problem 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 50 51 4,017,323,955 4,088,810,897 4,158,888,836 4,229,748,034 4,300,631,215 4,374,349,678 4,445,423.675 4,526,817,917 4,607.193,353 4,688,582,743 4,767,669,177 4,849,860,549 4,934,211,409 5,021,085,089 5,108,736,553 5,195,979,089 5,284,252,039 5,367,488,662 5,452,187,873 5,534,418,049 5,614,530,098 5,695,823,105 5,776,327,747 5,854,841,500 5,932,024,858 6,008,646,651 6,084,703,879 6,160,890,093 6,237,154,134 6,313,942,570 6,390,636,309 6,467,431,499 6,545,218,993 6,623,523,655 6,702,159,402 6,780,833,881 1.779 71,486,942 1.714 70,077,939 1.704 70,859,198 1.676 70,883,181 1.714 73.718,463 1.625 71,073,997 1.831 81,394,242 1.776 80,375,436 1.767 81,389,390 1.687 79,086,434 1.724 82,191,372 1.739 84,350,860 1.761 86,873,680 1.746 87,651,464 1.708 87,242,536 1.699 88,272,950 1.575 83,236.623 1.578 84,699,211 1.508 82,230,176 1.448 80,112,049 1.448 81,293,007 1.413 80,504,642 1.359 78,513,753 1.318 77,183,358 1.292 76,621,793 1.266 76,057,228 1.252 76,186,214 1.238 76,264,041 1.231 76,788,436 1.215 76,693,739 1.202 76.795,190 1.203 77,787.494 1.196 78,304,662 1.187 78,635,747 1.174 78,674,479 1.147 77,750,874 Part 3 - World Population 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 69 Part 2 - Weekly Earnings %%%%%%%8a88 % 8% 9% 80n2z1zg7m 1993 1994 1995 1996 1997 | 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 68| 2008 692009 70 | 2010 2011 2012 73 2013 74 | 2014 2015 76 2016 77| 2017 5,534,418,049 5.614,530,098 5,695,823.105 5,776,327,747 15,854,841,500 5,932,024,858 6,008,646,651 6.084,703,879 6.160,890,093 6.237,154,134 6.313,942,570 6.390,636,309 6,467,431,499 16,545,218,993 6.623.523,655 6.702,159,402 6.780.833,881 6,858,584,755 6,935,999,491 7,013,871.313 7.092,128,094 7.169,968.185 7.247,892,788 7.325,996,709 7,405.107,650 1.448 1.448 1.413 1.359 1318 1292 11.266 1.252 1.238 1.231 1.215 1202 1.203 1.196 1.187 1.174 1.147 1.129 1.123 1116 1.098 1.087 1.078 1.08 1.053 80.112,049 81,293,007 80,504,642 78,513,753 77,183,358 76.621,793 76,057228 76,1861214 76.264,041 76,788,436 76,693,739 76795.190 77.787,494 78.304,662 78,635,747 78,674.479 77750,874 77,414,736 77.871.822 78,256.781 77,840,091 77.924,603 78,103,921 79.110,941 77,942,567