Lab Practice 8

Lab Practice 8 - _ _ BUSI 410 Lab Practice #8 Due...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
________________________________________________________________________________ _________________ 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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online