A production manager wishes to examine the relationship between unit production (number of units produced) and associated

Question:

A production manager wishes to examine the relationship between unit production (number of units produced) and associated costs (total cost). The file Cost Estimation contains data for 10 months of production.
a. Construct a scatter plot for unit production and total cost.
b. Fit a quadratic regression model to predict total cost and state the quadratic regression equation.
c. Predict the total cost when production is 145 units.
d. Perform a residual analysis on the results and determine whether the regression model is valid.
e. At the 0.05 level of significance, is there a significant overall relationship between monthly unit production and total cost?
f. What is the p-value in (e)? Interpret its meaning.
g. At the 0.05 level of significance, determine whether there is a significant quadratic effect.
h. What is the /?-value in (g)? Interpret its meaning.
i. Interpret the meaning of the coefficient of multiple determination.
j. Compute the adjusted r2.
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: 9780133130805

7th Edition

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

Question Posted: