Problem # 3 is done by exact Table (6-4) for question #3 Text 6-4 See instructio

Question

Problem # 3 is done by exact Table (6-4) for question #3 Text 6-4 See instructions on bottom of page 323: complete parts (a) - (g), and (i) only but as follows: Identify the appropriate dependent and independent variables Complete a spreadsheet for the linear regression, by the four methods we used in class on 19 and 21 April [trendline, solver, sum of squares, excel functions =linest(...]. Calculate the standard error and correlation coefficient from the spreadsheet values as we did in class on 4/19 (i.e., "manually"). Calculate values of the confidence intervals of the regression coefficients using your spreadsheet with appropriate values for t_alpha/2,v from the table in the Appendix. Verify the value you looked up in the Appendix with the =tinv(... Excel function. Plot values of the confidence interval and the prediction interval for the entire range of T.

Explanation / Answer

a. Temperature is the independent variable and turbidity is the dependent variable.

b.

SUMMARY OUTPUT Regression Statistics Multiple R 0.63752571 R Square 0.406439031 Adjusted R Square 0.356975617 Standard Error 67.67771625 Observations 14 ANOVA df SS MS F Significance F Regression 1 37635.93497 37635.93 8.216963 0.014181017 Residual 12 54963.27932 4580.273 Total 13 92599.21429 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -510.71343 228.1957349 -2.23805 0.044955 -1007.909225 -13.51763517 -1007.909225 -13.51763517 x 26.30832282 9.177777038 2.866525 0.014181 6.311664466 46.30498118 6.311664466 46.30498118

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.