answer question

profilebasil101516
b.xlsx
Home>Business & Finance homework help>Financial markets homework help>answer question

Output

Regression Analysis
R² 0.808
Adjusted R² 0.693 n 9
R 0.899 k 3
Std. Error 0.221 Dep. Var. GDP_POP
ANOVA table
Source SS df MS F p-value
Regression 1.02862636 3 0.34287545 7.01 .0306
Residual 0.24468346 5 0.04893669
Total 1.27330982 8
Regression output confidence interval
variables coefficients std. error t (df=5) p-value 95% lower 95% upper VIF
Intercept 36.4889 0.9033 40.396 1.75E-07 34.1669 38.8108
DJIA -0.00004216 0.00012662 -0.333 .7527 -0.00036765 0.00028334 4.576
TAX -0.0371 0.2810 -0.132 .9000 -0.7594 0.6851 3.585
LAG_RATE -0.1639 0.1157 -1.417 .2156 -0.4613 0.1334 8.591
5.584
mean VIF
Observation GDP_POP Predicted Residual
1 34.80156 35.05193 -0.25037
2 34.89399 34.99539 -0.10140
3 35.07400 34.96061 0.11339
4 35.24780 35.00941 0.23839
5 35.22608 35.10849 0.11759
6 35.29535 35.42486 -0.12951
7 35.38864 35.59284 -0.20420
8 35.85883 35.80723 0.05160
9 35.99376 35.82923 0.16452
Durbin-Watson = 0.99

Sheet1

QTR POP GDP GDP_POP DJIA TAX RATE LAG_RATE
2012Q1 281 9650 34.3416 11723 0 5.85
2012Q2 282.2 9821 34.8016 11338 0 6.53 5.85
2012Q3 283 9875 34.8940 10035 0 6.52 6.53
2012Q4 283.8 9954 35.0740 10899 0 6.4 6.52
2013Q1 284.5 10028 35.2478 10208 0 5.31 6.4
2013Q2 285.3 10050 35.2261 11215 1 3.97 5.31
2013Q3 286.1 10098 35.2954 8921 1 3.07 3.97
2013Q4 286.9 10153 35.3886 8436 1 1.82 3.07
2014Q1 287.6 10313 35.8588 8211 1 1.73 1.82
2014Q2 288.3 10377 35.9938 8039 1 1.75 1.73
1.75
QTR POP GDP GDP_POP DJIA TAX RATE LAG_RATE
2012Q2 282.2 9821 34.8016 11338 0 6.53 5.85
2012Q3 283 9875 34.8940 10035 0 6.52 6.53
2012Q4 283.8 9954 35.0740 10899 0 6.4 6.52
2013Q1 284.5 10028 35.2478 10208 0 5.31 6.4
2013Q2 285.3 10050 35.2261 11215 1 3.97 5.31
2013Q3 286.1 10098 35.2954 8921 1 3.07 3.97
2013Q4 286.9 10153 35.3886 8436 1 1.82 3.07
2014Q1 287.6 10313 35.8588 8211 1 1.73 1.82
2014Q2 288.3 10377 35.9938 8039 1 1.75 1.73
QTR GDP_POP DJIA TAX LAG_RATE
2012Q2 34.8016 11338 0 5.85
2012Q3 34.8940 10035 0 6.53
2012Q4 35.0740 10899 0 6.52
2013Q1 35.2478 10208 0 6.4
2013Q2 35.2261 11215 1 5.31
2013Q3 35.2954 8921 1 3.97
2013Q4 35.3886 8436 1 3.07
2014Q1 35.8588 8211 1 1.82
2014Q2 35.9938 8039 1 1.73