Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Round all intermediate calculations to at least 4 decimal places.) Consider the

ID: 3052591 • Letter: R

Question

Round all intermediate calculations to at least 4 decimal places.) Consider the following sample data (Use Table 2): y 53 28 49 38 51 38 28 48 x1 38 37 37 40 37 38 39 39 X2 20 23 23 21 22 23 22 21 Click here for the Excel Data File a. Find the sample regression equation, = b0 + b1 x1 + b2x2. (Negative values should be indicated by minus sign. Round your answers to 2 decimal places.) X2 b. Construct the 95% confidence interval for E(y) if X1 equals 50 and x2 equals 20' (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Confidence interval to c. Construct the 95% prediction interval for y if x1 equals 50 and x2 equals 20, (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Prediction interval to

Explanation / Answer

Regression Analysis: y versus x1, x2

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 2 362.6 181.29 2.61 0.167
x1 1 221.6 221.58 3.19 0.134
x2 1 327.6 327.58 4.72 0.082
Error 5 347.3 69.46
Lack-of-Fit 4 126.8 31.70 0.14 0.942
Pure Error 1 220.5 220.50
Total 7 709.9


Model Summary

S R-sq R-sq(adj) R-sq(pred)
8.33418 51.08% 31.51% 0.00%


Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant 429 179 2.40 0.062
x1 -5.98 3.35 -1.79 0.134 1.43
x2 -7.27 3.35 -2.17 0.082 1.43


Regression Equation

y = 429 - 5.98 x1 - 7.27 x2

B and C)

Variable Setting
x1 50
x2 20

Fit SE Fit 95% CI 95% PI

-15.75 36.8028 (-110.355, 78.8545) (-112.750, 81.2499)

Hope this will be helpful. Thanks and God Bless You :-)