A financial advisor wants to know if there is a relationship between ING and investment banking. Does ING predict good investments in banking? The results are as follows:

Regression Statistics

R Square 0.8921

Adjusted R Square 0.8742

Observations 8

ANOVA

df SS MS F Significance F

Regression 1 180.2143 180.2143 ?? 0.00041

Residual 6 21.7857 ?? 

Total 7 ?? 

Variable Coefficient Standard Error T value P value Lower 95% Upper 95%

Intercept -0.3214 1.4848 ?? 0.8358 ?? ??

Investments 4.1429 0.5881 ?? 0.0004 ?? ??

1) Fill in the tables with the missing values? (You should have 10 different values you need to find)

2) What is the correlation coefficient of the model?

3) What is the correlation of determination?

4) What is the estimated regression equation?

5) Interpret the slope.

6) What is the hypothesis scenario?

7) Use the estimated regression equation to predict ING with an Investment of 6.

8) Would your predicted in #7 be interpolation or extrapolation? Why? 

9) Is there evidence of a significant relationship between ING and Investments? Use alpha = .05.

10) One pair of data in this sample is (2, 5). Which says that Investments of 2 had an ING of 5, calculate a residual for this data point.

11) What is the standard error of the estimated regression line?