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 INQ with an Investment of 6.
8) Would your predicted in #7 be interpolation or extrapolation? Why? (Hint: Use the 95% Confidence Interval for reference)
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. (Hint: calculate the difference between the observed ING and predicted ING)
11) What is the standard error of the estimated regression line?