Lab Practice 8

Lab Practice 8 - _ BUSI 410 Lab Practice #8 Due 4/12/2010...

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 4/12/2010 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 residual plots or the data or other Excel output. 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 Home Depot revenues as well as run
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/13/2010 for the course BUSI 410 taught by Professor Massa during the Spring '09 term at UNC.

Ask a homework question - tutors are online