Floor Space (5q. ft.) 6,060 5,230 4,280 5,580 5,670 5,020 5,410 4,990 Weekly Sales (dollars) 16,380 14,400 13,820 18,230 14, 200 12,800 15,840 16,610 4,220 4,160 4,870 5,470 13,610 10,050 15,320 13,270 B Click here for the Excel Data File (a) Using the table above, select the most appropriate scatter plot from the given choices. Scatter Plot A Scatter Plot B Scatter Plot C Floor Space and Weekly Sales Floor Space and Weekly Sales Floor Space and Weekly Sales 20,000 18,000 16,000 14.000 12,000 10,000 8.000 6,000 4,000 2,000 20,000 18,000 16.000 14.000 12.000 10,000 8.000 6,000 4,000 20,000 18,000 16.000 14,000 * 12,000 10,000 8.000 6.000 4,000 2,000 1. 2,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 FLOOR SPACE FLOOR SPACE FLOOR SPACE O Scatter Plot A O Scatter Plot B O Scatter Plot C sanS A TMM sanvSA TMIM

The total amount of consumer credit has been increasing steadily in recent years. The following table gives the total outstanding consumer credit (in billions of dollars). Answer parts (a) through (e) below Year 2004 2005 2006 2007 2008 Consumer Credit 2250.5 2303.8 2415.0 2517.9 2595.1 Year 2009 2010 2011 2012 2013 Consumer Credit 2551.5 2645.1 2757.0 2926 3 3099 2 a. Find an equation for the least squares line, letting x equal the number of years since 2000. The equation is Y=x (Use integers or decimals for any numbers in the equation Round to two decimal places as needed.)

Please give the excel formula or spreadsheet.

Answer the following questions regarding the population of Hamilton County in 2016. a. If you predict the population of Hamilton County in 2016, should you use the average growth rate of 2000-2009 or the average growth rate of 2009-2015? Explain your choice in a complete sentence.  b. Predict the population of Hamilton Country in 2016. Show your work. Express your answer in “thousand people” rounded to the nearest whole number.