Using the data of Problem 15.6 on page 529, stored in HondaPrices, perform a natural logarithm transformation

Question:

Using the data of Problem 15.6 on page 529, stored in HondaPrices, perform a natural logarithm transformation of the dependent variable (price). Using the transformed dependent variable and the age as the independent variable, perform a regression analysis.

(a). State the regression equation.

(b). Predict the mean price for a five year old Honda Civic LX.

(c). Perform a residual analysis of the results and determine whether the regression assumptions are valid.

(d). At the 0.05 level of significance, is there a significant relationship between the natural logarithm of price and age?

(e). Interpret the meaning of the coefficient of determination, r2, in this problem.

(f). Compute the adjusted r2.

(g). Compare your results with those in Problem 15.6. Which model is better? Why?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 9780134173054

8th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: