A portion of the Excel Regression tool output follows. 1 answer below »

Recall that in the admissions officer for Clearwater College developed the following estimated regression equation relating final college GPA to the student’s SAT mathematics score and high-school GPA.

Don't use plagiarized sources. Get Your Custom Essay on
A portion of the Excel Regression tool output follows. 1 answer below »
Just from $13/Page
Order Essay

 width= = -1.41 + .0235x1 + .00486x2

x1 = high-school grade point average

x2 = SAT mathematics score

= final college grade point average

A portion of the Excel Regression tool output follows.

 

A

B

C

D

E

F

G

1

SUMMARY OUTPUT

 

 

 

 

 

2

 

 

 

 

 

 

 

3

Regression Statistics

 

 

 

 

 

4

Multiple R

 

 

 

 

 

 

5

R Square

 

 

 

 

 

 

6

Adjusted R Square

 

 

 

 

 

 

7

Standard Error

 

 

 

 

 

 

8

Observations

 

 

 

 

 

 

9

 

 

 

 

 

 

 

10

ANOVA

 

 

 

 

 

 

11

 

df

SS

MS

F

Significance F

 

12

Regression

 

1.76209

 

 

 

 

13

Residual

 

 

 

 

 

 

14

Total

9

1.88

 

 

 

 

15

 

 

 

 

 

 

 

16

 

Coefficients

Standard Error

t Stat

P-value

 

 

17

Intercept

-1.4053

0.4848

 

 

 

 

18

X1

0.023467

0.0086666

 

 

 

 

19

X2

0.00486

0.001077

 

 

 

 

20

 

 

 

 

 

 

 

a. Complete the missing entries in this output.

b. Using α = .05, test for overall significance.

c. Did the estimated regression equation provide a good fit to the data? Explain.

d. Use the test and α = .05 to test H0β1 = 0 and H0β2 = 0.