The SPSS file below contains data for a TIME-SERIES REGRESSION in which the model (less constant and coefficients) is: LGDP = LG + LUNEMPT + LM2 + LPROD a) Check the Circles below for all levels at which of the coefficients are statistically significant. VARIABLE Not Significant Significant Significant Significant Name Significant at a =.10 at a =.05 at a=.01 at a =.005 LG O O O O LUNEMPT O O O O LM2 O O O O LPROD O O O O b) Find the predicted value for LGDP when LG= 5, LUNEMPT= 1, LM2= 3, LPROD= 2 Regression Model SummaryAdjusted R Std Error of Durbin- Model R R Square Square The Estimate Watson 898 806 789 029097 2.63 a. Predictors: (Constant), LPROD, LUNEMPT, LG, LM2 b. Dependent Variable: LGDP ANOVA Sum of Model Squares df Mean Square F Sig 1 Regression 20.009 4 Residual 1.013 5.002 50 034 147.118 .001 Total 21.022 54 a. Dependent Variable: LGDP b. Predictors: (Constant), LPROD, LUNEMPT, LG, LM2Excel P-value Excel Intercept Coefficients Unstandardized Standardized Model Coefficients Coefficients Collinearity Statistics B Std Error beta sig Tolerance VIF 1 (Constant) 4.00 2.908 3.438 002 LG 1.00 . 151 358 4.293 000 218 4.589 LUNEMPT 80 .063 .010 -1.593 071 255 3.917 LM2 -.30 .233 -.718 -2.635 .018 .144 4.952 LPROD A -.50 .125 -.072 791 .454 .111 9.047 Excel Coefficients