________________________________________________________________________________ _________________ BUSI 410 – Lab Practice #8 Due 11/17/2009 This lab practice is intended to provide you with practice using Excel to perform time series regressions. Download the dataset (Home Depot 9.1.xls) required for this Lab practice from Blackboard. All of the questions below are answered in Chapter 9. Use them as reference but it would be useful to attempt the problem without looking at the solution first. Build a time-series regression model to forecast quarterly revenues for Home Depot. Use past revenue to capture inertia and trend and past new home sales as a leading indicator in your regression. Submit only the answers requested in the questions below. Do not print the residuals or the data or other Excel output. All questions can be answered in one page. 1) Determine the length of the lag for new home sales to be used in the regression. You can visually inspect past new home sales as well as
This is the end of the preview. Sign up
access the rest of the document.