Question

20 321 Average Daily TV Viewing Time Per U.S. Household Year Hours Min Total Min 1950 260 1955 298 1960 1965 349 1970 364 1975 404 1980 433 1985 453 1990 437 1995 458 2000 484 2005 524 2010 0 VOU 557 Click here for the Excel Data File (a)Fit a linear trend to the Total Min data. (Round your answers to 2 decimal places.) (b)Make a forecast for 2015. (Round your answer to the nearest whole number.) Forecast for 2015 - O minutes

Answer 1

​​​​​​

Sum of X = 25740 Sum of Y = 5342 Mean X= 1980 Mean Y = 410.9231 Sum of squares (55x) = 4550 Sum of products (SP) = 20430 Regression Equation = = bX+ a b= SPISSx= 20430/4550 = 4.49011 a = My - bMx = 410.92 - (4.49*1980) = -8479.49451 ỹ = 4.49011x - 8479.49451

So the linear fit is y-hat=4.49t - 8479.49

b) forecast of 2015 is 568.