2 3 Money (in millions) Fundraising 1987-2012 4 5 Years Democrats Republicans 6 87-88 113.8 251.3 7 89-90 78.5 202 8 91-92 163.3 264.9 9 93-94 132.8 244.1 10 95-96 221.6 416.5 11 97-98 160 285 12 99-00 275.2 465.8 13 01-02 217.3 441.6 14 03-04 678.8 782.4 15 05-06 483.1 602.3 16 07-08 763.3 792.9 17 09-10 600.4 549 18 11-12 805.6 806.9 19 20 21 22 23 Sheet1 + a. Create a new column D for years, where 0 corresponds to the beginning of 1985 (so, your first values should be 2, 4, ...). Then, create a new column E that is the sum of the spending by Democrats and Republicans. Copy and paste this table into your Word document. b. Make a scatterplot of the data, including a title and axes labels. Observe that while there are minor fluctuations to the data, there is a general upward trend that could be modeled by a linear function. Thus, add a linear trendline to your plot, including the equation and the R? value. Also, forecast forward by 5 units. Copy and paste this plot into in your Word document c. Use this linear model (equation) to predict the amount of spending in 2015-16. Show work and label your answer. d. Does this prediction seem reasonable? E16 x v fx A B C D E F G 1 Year 2 1860 3 1870 4 1880 5 1890 6 1900 7 1910 8 1920 9 1930 10 1940 11 1950 12 1960 13 1970 14 1980 15 1990 16 2000 17 2010 18 19 20 21 22 23 24 25 26 27 28 Elgin Population 2,797 5,441 8,787 17,823 22,433 25,976 27,454 35,929 38,333 44,223 49,447 55,691 63,798 77,010 94,487 108,188 Sheet1 which contains Elgin's popu a. Create a new column C for years, where 0 corresponds to 1850 (so, your first value should be 10). Then, it will be easiest to just recopy the population data from column B into column D. Copy and paste this table into your Word document. b. Make a scatterplot of the data, including a title and axes labels. Then, add a linear trendline to your plot, including the equation and the R' value. Also, forecast forward by 10 units. Copy and paste this plot into in your Word document. c. Compare the overall fit of the model in both #2 (political fundraising) and with this model in #3 (Elgin population), incorporating the R values into your answer. d. Use this linear model (equation) to predict the Elgin Population in 2020. Show work and label your answer. Does this prediction seem reasonable? Explain. e. 2 3 Money (in millions) Fundraising 1987-2012 4 5 Years Democrats Republicans 6 87-88 113.8 251.3 7 89-90 78.5 202 8 91-92 163.3 264.9 9 93-94 132.8 244.1 10 95-96 221.6 416.5 11 97-98 160 285 12 99-00 275.2 465.8 13 01-02 217.3 441.6 14 03-04 678.8 782.4 15 05-06 483.1 602.3 16 07-08 763.3 792.9 17 09-10 600.4 549 18 11-12 805.6 806.9 19 20 21 22 23 Sheet1 + a. Create a new column D for years, where 0 corresponds to the beginning of 1985 (so, your first values should be 2, 4, ...). Then, create a new column E that is the sum of the spending by Democrats and Republicans. Copy and paste this table into your Word document. b. Make a scatterplot of the data, including a title and axes labels. Observe that while there are minor fluctuations to the data, there is a general upward trend that could be modeled by a linear function. Thus, add a linear trendline to your plot, including the equation and the R? value. Also, forecast forward by 5 units. Copy and paste this plot into in your Word document c. Use this linear model (equation) to predict the amount of spending in 2015-16. Show work and label your answer. d. Does this prediction seem reasonable? E16 x v fx A B C D E F G 1 Year 2 1860 3 1870 4 1880 5 1890 6 1900 7 1910 8 1920 9 1930 10 1940 11 1950 12 1960 13 1970 14 1980 15 1990 16 2000 17 2010 18 19 20 21 22 23 24 25 26 27 28 Elgin Population 2,797 5,441 8,787 17,823 22,433 25,976 27,454 35,929 38,333 44,223 49,447 55,691 63,798 77,010 94,487 108,188 Sheet1 which contains Elgin's popu a. Create a new column C for years, where 0 corresponds to 1850 (so, your first value should be 10). Then, it will be easiest to just recopy the population data from column B into column D. Copy and paste this table into your Word document. b. Make a scatterplot of the data, including a title and axes labels. Then, add a linear trendline to your plot, including the equation and the R' value. Also, forecast forward by 10 units. Copy and paste this plot into in your Word document. c. Compare the overall fit of the model in both #2 (political fundraising) and with this model in #3 (Elgin population), incorporating the R values into your answer. d. Use this linear model (equation) to predict the Elgin Population in 2020. Show work and label your answer. Does this prediction seem reasonable? Explain. e