Unformatted text preview: annual return. Include residual calculations and a plot of residuals for both independent variables. How much of the variation is explained by these two independent variables? What is your estimate of the annual return of a stock fund where the fund manager had 7 years of experience? Example 2 – Resale Value of Long’s Automobile (from Text – Cases pg.144) Do a scatter diagram for each of the numerical independent variables. Add trend lines. Use the IF function to create dummy variables Do a CORRELATION analysis to see how each factor is related to the other factors Do a multiple regression analysis on all five factors How well does this model explain the resale price of a car? What factors are the most important in predicting the resale value of a car? What would you estimate to be the resale value of a 1999 car with 29,300 miles, manual transmission, leather interior and air conditioning?...
View
Full Document
 Fall '11
 Dr.SusanSproule
 Linear Regression, Regression Analysis, multiple regression analysis, fund manager, linear regression model

Click to edit the document details