(**100 points**) Using the data supplied from ECONOMAGIC (see Excel attachment), estimate a forecasting model for the Number of New Homes Sold in the U.S (NHS) measured in thousands of unitsas the **dependent** variable (Y). As your **independent** variables (X’s) use the Real Disposable Income($B) and the Unemployment Rate (%). The data are collected Monthly beginning in January 1963 and ending August 2019.

- Initially, graph a
**time series**for each variable and give a**brief description**of each variable’s history. - Graph a
**3-dimensional**function using the NHS as the**‘z’**variable and the Real Disposable Income and Unemployment Rate as the**‘x’**and**‘y’** - Test for
**stationarity**in the**dependent (NHS)**variable only. Briefly discuss. - If data are
**non-stationary**correct the model and briefly explain. - Next, estimate and
**interpret**a multiple regression equation. In your answer make sure to include a discussion of theand all supporting statistics (i.e__regression coefficients____. t-tests, R-square, F-test, etc.).__ - Closely inspect the
**residuals**from the regression equation. Are there any discernible patterns in these residuals with particular reference to**outliers**and/or**leverages**? Briefly explain *Now using thisestimated*, provide and briefly interpret for the reader**regression**modelfor the NHS). Use the following specified__three ‘point’ and ‘interval’predictions or forecasts (i.e.,__**values**for the independent variables (selected to represent a steady state, a pessimistic, and anoptimistic economic environment).- Real Disposable Income =$15,000BUnempRate=3.70% (steady state forecast)
- Real Disposable Income =$14,000B UnempRate=5.0% (pessimistic forecast)
- Real Disposable Income =$16,000B UnempRate=2.5% (optimistic forecast)
- Now re-estimate the model using a
**double logarithmic**functional form (columns G-I) are the appropriate transformations in your Excel worksheet) and interpret your regression equation(i.e.__. regression coefficients, t-tests, R-square, F-test, residuals outliers, leverages, etc.)__ **Compare and contrast**the results from the**logarithmic model**(#8) with the**unlogged**model (#5).- Test to determine if the estimated
**slope coefficient on the ln(Income)**variable is**equal to ‘1.00’**; that is, is there a one-to-one correspondence between NHS and Real Disposable Income?

__Submit your paper to this assignment link as an attached WORD document and clearly label your answers as ordered above (i.e., 1-10). Remember you may copy and paste the relevant MINITAB/Economagic outputs but your final analysis must be in essay format!__

__For your review, I have attached an EXCEL and MINITAB documents created from ECONOMAGIC that displays all the relevant data (including the raw as well as the logarithmic transformation). Use the MINITAB document to complete the test__

** Also please insert your name at the top of the WORD document and** make sure when you cut and paste your relevant MINITAB output that the resulting output is properly aligned.

Last Updated on