Using the data of Problem 15.6 on page 581, stored in Cost Estimation, perform a natural logarithm

Question:

Using the data of Problem 15.6 on page 581, stored in Cost Estimation, perform a natural logarithm transformation of the dependent variable (total cost). Using the transformed dependent variable and the unit production as the independent variable, perform a regression analysis.
a. State the regression equation.
b. Predict the total cost when production is 145 units.
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 total cost and unit production?
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: 772

7th Edition

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

Question Posted: