For each of the following tables practice making a scatterpl

For each of the following tables, practice making a scatterplot of the data. (You do not need to draw one, just practice!) 1. Then, calculate a regression line with your calculator and predict what the data will be for the year 2016. For each, record both the regression line formula and the prediction. Prediction a) Regression Line Bankruptcles The table lists the number of bankrupt cies filed in thousands for selected years Year 2006 | 2007 2008 2009 | 2010 les 160 220 290 380 425 b) Regression Line Prediction = Green Building Material The table lists U.S. demand for green building materials in bittions of dollars for selected years. Year 2010 2011 2012 2013 Demand 65 70 75 80 c) Regression Line Prediction = Hours Worked in Europe The table lists the annua hours worked by the average worker in Europe for selected years. Year 1970 1980 1990 2000 2010 Hours 2000 1860 1750 1690 1590 1980 1990 2000 1590

Solution

a)

Regression equation y=a+bx

From Excel

The fitted Regression y=-138257 +69x

when x=2016

y=-138257 +69(2016) = 847

b)

The regression equation is

y= -9985 +5x

when x=2016

y= -9985 +5*2016

y=95

C)

The fitted Regression is

y = 21479 -9.9x

when x=2016

y=21479 -9.9 *2016 =1520.6

	Coefficients	Standard Error
Intercept	-138257	7239.948757
Year	69	3.605551275