Explore BrainMass

Explore BrainMass

    Building a quadratic regression model

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See attachment for data on y = green liquor (g/L) and x = paper machine speed (ft/min) from a Kraft paper machine.

    (a) Fit the model Y = Bo + B1x + B2x^2 + e using least squares.
    (b) Test for significance of regression using alpha = 0.05. What are your conclusions?
    (c) Plot the residuals from the model in part (a) versus y. Does the plot reveal any inadequacies?
    (d) Construct a normal probability plot of the residuals. Comment on the normality assumption.

    See attachment for given chart.

    © BrainMass Inc. brainmass.com October 2, 2020, 5:43 am ad1c9bdddf


    Solution Preview

    See attached file for full solution.

    Part a:
    After running quadratic regression in excel, the ...

    Solution Summary

    The solution builds a quadratic regression model and tests both significance and normality assumption of the model using excel.