Question

In: Statistics and Probability

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

  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.
  4. Conduct ANOVA F-test for the entirety of the regression. You must write down the ANOVA table with all the details. (30 points)

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.

D)

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...
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 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...
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 Find the approximate 95% confidence interval for the mean calculus final for all the students having X1=70 and X2=592. (who...
Use the following data to develop a multiple regression model to predict from and . Discuss...
Use the following data to develop a multiple regression model to predict from and . Discuss the output, including comments about the overall strength of the model, the significance of the regression coefficients, and other indicators of model fit. y x1 x2 198 29 1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63 201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15 Appendix A Statistical Tables *(Round...
Solve problem (P4.2) from the textbook using the following data instead of the data given in...
Solve problem (P4.2) from the textbook using the following data instead of the data given in the textbook. Solve only requirements under a, b and c. Show your assumptions and consequent calculations on how you catered for the fact that 1997 means first half of the year and 1997.5 means in the second half of the year; without such initial, your solution will not be considered as your own.   (Hint: you may use Excel or any software to conduct linear...
*Problem 1-4A (Video) The following data were taken from the records of Clarkson Company for the...
*Problem 1-4A (Video) The following data were taken from the records of Clarkson Company for the fiscal year ended June 30, 2020. Raw Materials Inventory 7/1/19 $48,900 Factory Insurance $5,100 Raw Materials Inventory 6/30/20 46,900 Factory Machinery Depreciation 18,000 Finished Goods Inventory 7/1/19 97,700 Factory Utilities 30,000 Finished Goods Inventory 6/30/20 21,600 Office Utilities Expense 9,350 Work in Process Inventory 7/1/19 25,200 Sales Revenue 558,900 Work in Process Inventory 6/30/20 23,700 Sales Discounts 5,000 Direct Labor 142,050 Plant Manager’s Salary...
Problem 16-06A The following data, presented in alphabetical order, are taken from the records of Sandhill...
Problem 16-06A The following data, presented in alphabetical order, are taken from the records of Sandhill Corporation. Accounts payable $240,000 Accounts receivable 140,100 Accumulated depreciation—buildings 180,400 Accumulated depreciation—equipment 52,000 Allowance for doubtful accounts 5,200 Bonds payable (10%, due 2028) 500,300 Buildings 949,000 Cash 42,200 Common stock ($10 par value; 499,000 shares authorized, 149,100 shares issued) 1,491,000 Dividends payable 79,200 Equipment 275,200 Goodwill 200,000 Income taxes payable 120,300 Inventory 169,900 Investment in Mara common stock (30% ownership), at equity 380,100 Investment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT