Please use excel and attach graphs and explanation of how you solved the problem

Question

Please use excel and attach graphs and explanation of how you solved the problems.

Part III. Recall Exercise 1-19 from the first assignment. Using the combined data (both high and low), we obtained a regression line which was a pretty good fit, but if you look at the graph both the points representing the smallest and largest values lie above the line, which is usually a good indication that a quadratic approximation would be more appropriate. is usually a good indicati on that a quadratic approximation would be more appropriate. Find the best-fit quadr atic curve for this data, and show it at least fixes the problem of the regression line al ways having a negative y-intercept. You could also check to see if the quadratic curve gives a smaller value for the residual sum of squares

Explanation / Answer

Quadraric Model

SSR in quadratic - 11.92022046

SSR in linear -   16.21821453

clearly SSR in quadratic is less

How to solve

type data in columns

use excel data data analysis regression

SUMMARY OUTPUT Regression Statistics Multiple R 0.972123814 R Square 0.94502471 Adjusted R Square 0.939527181 Standard Error 1.27350754 Observations 12 ANOVA df SS MS F Significance F Regression 1 278.7909521 278.7909521 171.899904 1.26512E-07 Residual 10 16.21821453 1.621821453 Total 11 295.0091667 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -3.747523778 0.962023733 -3.89545876 0.002982952 -5.89104624 -1.604 -5.89105 -1.604 Radiation 0.037107761 0.002830264 13.11106037 1.26512E-07 0.03080154 0.043414 0.030802 0.043414

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---