Lab Practice 7

Lab Practice 7 - 1. The regression output when all seven...

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

View Full Document Right Arrow Icon
_________________________________________________________________________________________________ BUSI 410 – Lab Practice #7 Due 03/31/2010 This lab practice is intended to provide you with practice using Excel to do multiple regression analysis in order to identify business drivers, eliminate multicollinearity, and determine the extent of influence of the drivers. Download the dataset (Excel 8.1 Sakura Motors.xls) required for this Lab practice from Blackboard. Work through Excel exercises 8.1 and 8.2 on pp. 216-218 in your textbook. As you work on this assignment, make sure you can conceptually understand the issue of multicollinearity. Hand in only the following (DO NOT hand in printouts of the data or the residuals!):
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1. The regression output when all seven potential drivers MPG, seconds, liters, horsepower, cylinders, pounds, and passengers are included in the model. 2. Which variables have the wrong sign? 3. The table of correlations between each pair of these seven potential drivers. 4. The regression output when the four final drivers MPG, seconds, liters and pounds are included in the model. a. What is the percentage variation in emissions that is explained by the four drivers? b. Interpret the coefficients of the four final drivers in plain English c. Present the regression output in equation format....
View Full Document

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

Ask a homework question - tutors are online