hw problem & answers

Question #$2$

$\backslash$table$[[$Question #$2,,]]$

$($A$)$ Perform a regression analysis on the above data to see if household income can be used to predict future sales. $($B$)$ Create a graph that shows the historical data and the regression line. $($C$)$ Predict sales for the next three years based on the income projections listed below. $($fill in the blanks on the first sheet$)$

$\backslash$table$[[,,$Average,$],[,$Number of$,$Household,Widgets$],[$Year$,$Households,Income,Sold$],[1980,39\mathrm{.}5,34,000,5,500],[1981,39\mathrm{.}8,34,600,5,600],[1982,40\mathrm{.}4,41,000,5,900],[1983,43\mathrm{.}1,38,000,5,800],[1984,43\mathrm{.}2,39,000,6,100],[1985,44\mathrm{.}0,42,000,6,900],[1986,44\mathrm{.}5,44,000,6,300],[1987,46\mathrm{.}2,49,000,7,300],[1988,46\mathrm{.}5,46,000,6,700],[1989,46\mathrm{.}8,51,000,6,900],[1990,47\mathrm{.}0,48,000,7,200],[1991,47\mathrm{.}1,47,000,7,100],[1992,47\mathrm{.}3,50,000,7,100],[1993,47\mathrm{.}7,51,000,7,400],[1994,48\mathrm{.}0,53,000,7,600],[1995,48\mathrm{.}1,54,000,7,900],[1996,48\mathrm{.}4,55,000,7,300],[1997,48\mathrm{.}5,53,000,8,000],[1998,49\mathrm{.}0,57,000,8,500]]$