Question

In: Statistics and Probability

Student Math-proficiency   X1 SAT-Math X2 Calculus final (college 1st year)  Y 1 72 462 71 2 96...

Student

Math-proficiency  

X1

SAT-Math X2

Calculus final (college 1st year)  Y

1

72

462

71

2

96

545

92

3

68

585

72

4

86

580

82

5

70

592

74

6

73

516

71

7

91

638

100

8

75

615

87

9

76

596

81

The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is :

Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math

  1. Find the approximate 95% confidence interval for the mean calculus final for all the students having X1=70 and X2=592. (who scored 70 in Math-proficiency and 592 on Sat-Math).
  2. Compute the TSS and ESS from data and regression equation. Please take a screen shot of you lists in TI-84 and submit the screen shot showing the data, the predicted value, the residuals and the squared residuals.  This is a proof that you did the problem.
  3. Compute the coefficient of multiple determination and interpret its value in the context of the problem.  You must write down TSS, ESS and how r2 is computed from them.

Conduct ANOVA F-test for the entirety of the regression. You must write down the ANOVA table with all the details.  

Solutions

Expert Solution

a)

Find the approximate 95% confidence interval for the mean calculus final for all the students having X1=70 and X2=592. (who scored 70 in Math-proficiency and 592 on Sat-Math).

95% Confidence Interval
X1 X2 lower upper
70 592 71.359 81.206

b)

Compute the TSS and ESS from data and regression equation. Please take a screen shot of you lists in TI-84 and submit the screen shot showing the data, the predicted value, the residuals and the squared residuals.  This is a proof that you did the problem.

SS  
Residual 97.3230
Total 848.8889

The regression equation is:

y = -26.6155 + 0.7763*x1 + 0.0820*x2

c)

Compute the coefficient of multiple determination and interpret its value in the context of the problem.  You must write down TSS, ESS and how r2 is computed from them.

R2 = 0.885

88.5% of the variability in the model is explained.

  1. Conduct ANOVA F-test for the entirety of the regression. You must write down the ANOVA table with all the details.  (30 points)
Source SS   df   MS F p-value
Regression 751.5659 2   375.7829 23.17 .0015
Residual 97.3230 6   16.2205
Total 848.8889 8  

The hypothesis being tested is:

H0: β1 = β2 = 0

H1: At least one βi ≠ 0

The p-value is 0.0015.

Since the p-value (0.0015) is less than the significance level (0.05), we can reject the null hypothesis.

Therefore, we can conclude that the model is significant.

The calculations are:

0.885
Adjusted R² 0.847
R   0.941
Std. Error   4.027
n   9
k   2
Dep. Var. Y
ANOVA table
Source SS   df   MS F p-value
Regression 751.5659 2   375.7829 23.17 .0015
Residual 97.3230 6   16.2205
Total 848.8889 8  
Regression output confidence interval
variables coefficients std. error    t (df=6) p-value 95% lower 95% upper
Intercept -26.6155
X1 0.7763 0.1465 5.300 .0018 0.4179 1.1347
X2 0.0820 0.0270 3.039 .0228 0.0160 0.1481
Predicted values for: Y
95% Confidence Interval 95% Prediction Interval
X1 X2 lower upper lower upper
70 592 71.359 81.206 65.266 87.299

Related Solutions

Problem (multiple regression).  Following data are taken from textbook (p.614) Student Math-proficiency   X1 SAT-Math X2 Calculus final...
Problem (multiple regression).  Following data are taken from textbook (p.614) Student Math-proficiency   X1 SAT-Math X2 Calculus final (college 1st year)  Y 1 72 462 71 2 96 545 92 3 68 585 72 4 86 580 82 5 70 592 74 6 73 516 71 7 91 638 100 8 75 615 87 9 76 596 81 V= 56331/9 = 6259   S=sqrt6259 = 79.1 The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is : Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math Find the approximate 95% confidence...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus final (college 1st year) Y 1 72 462 71 2 96 545 92 3 68 585 72 4 86 580 82 5 70 592 74 6 73 516 71 7 91 638 100 8 75 615 87 9 76 596 81 The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is : Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math Find the approximate 95% confidence interval for the mean...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus final (college 1st year) Y 1 72 462 71 2 96 545 92 3 68 585 72 4 86 580 82 5 70 592 74 6 73 516 71 7 91 638 100 8 75 615 87 9 76 596 81 The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is : Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math Find the approximate 95% confidence interval for the mean...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus final (college 1st year) Y 1 72 462 71 2 96 545 92 3 68 585 72 4 86 580 82 5 70 592 74 6 73 516 71 7 91 638 100 8 75 615 87 9 76 596 81 The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is : Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math Find the approximate 95% confidence interval for the mean...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus...
Problem (multiple regression). Following data are taken from textbook (p.614) Student Math-proficiency X1 SAT-Math X2 Calculus final (college 1st year) Y 1 72 462 71 2 96 545 92 3 68 585 72 4 86 580 82 5 70 592 74 6 73 516 71 7 91 638 100 8 75 615 87 9 76 596 81 The least-square equation is Y=-26.6+0.777X1+0.082 X2, that is : Calculus final=-26.6+0.777 *math-proficiency +0.082* Sat-Math Find the approximate 95% confidence interval for the mean...
Compute the projection of y = (1, 2, 2, 2, 1)  onto span (x1, x2) where x1...
Compute the projection of y = (1, 2, 2, 2, 1)  onto span (x1, x2) where x1 =(1, 1, 1, 1, 1)   x2 =(4, 1, 0, 1, 4) The inner product to use is the usual dot product. (This will compute a best-fitting function that is quadratic with no linear term, fitting to the data (−2, 1),(−1, 2),(0, 2),(1, 2),(2, 1).)
(1) z=ln(x^2+y^2), y=e^x. find ∂z/∂x and dz/dx. (2) f(x1, x2, x3) = x1^2*x2+3sqrt(x3), x1 = sqrt(x3),...
(1) z=ln(x^2+y^2), y=e^x. find ∂z/∂x and dz/dx. (2) f(x1, x2, x3) = x1^2*x2+3sqrt(x3), x1 = sqrt(x3), x2 = lnx3. find ∂f/∂x3, and df/dx3.
DATA 2 ID X1 X2 X3 Y A 0 2 4 9 B 1 0 8...
DATA 2 ID X1 X2 X3 Y A 0 2 4 9 B 1 0 8 10 C 0 1 0 5 D 1 1 0 1 E 0 0 8 10 CORRELATION MATRIX Y X1 X2 X3 Y 1 ? -0.304 +0.889 X1 ? 1 -0.327 0 X2 -0.304 -0.327 1 -0.598 X3 +0.889 0 -0.598 1 1. What is the sum of squares regression for the full model? (Correct answer is 58, please show me how to get...
DATA 2 ID X1 X2 X3 Y A 0 2 4 9 B 1 0 8...
DATA 2 ID X1 X2 X3 Y A 0 2 4 9 B 1 0 8 10 C 0 1 0 5 D 1 1 0 1 E 0 0 8 10 CORRELATION MATRIX Y X1 X2 X3 Y 1 ? -0.304 +0.889 X1 ? 1 -0.327 0 X2 -0.304 -0.327 1 -0.598 X3 +0.889 0 -0.598 1 Comparing the zero order model and full model 1. Did the addition of X2 and X3 significantly increase R2? (correct answer is...
y x1 x2 13 20 3 1 15 2 11 23 2 2 10 4 20...
y x1 x2 13 20 3 1 15 2 11 23 2 2 10 4 20 30 1 15 21 4 27 38 0 5 18 2 26 24 5 1 16 2 A manufacturer recorded the number of defective items (y) produced on a given day by each of ten machine operators and also recorded the average output per hour (x1) for each operator and the time in weeks from the last machine service (x2). a. What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT