Forecast the sales for the home improvements market for Mexico City for 2007 using expenditures per household as the explanatory (independent) variable in a linear regression analysis. Graph the actual and forecasted data. See attached for data.
Select another possible explanatory variable, in addition to expenditures per household that could be used to forecast annual sales for the home improvement market in Mexico City. Discuss why this variable may be a good predictor of sales and where you could obtain data on this variable. Then using at least nine years of such data (predicted if necessary), calculate a second linear regression equation using your selected variable.
See attached file for full problem description.
See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks
Year Home improvement sales Expenditures per household Population Forecast using HI Expenditure Forecast Using ...
Demonstrates how to work with actual data to make sales forecast.