Name: e. Comparing the following model by using Adjusted R Square, Std. Error of the Estimate, Mallows' Prediction Criterion (C statistic). Finish the following table Please don't hand in your SPSS output Model R Square 1. (35 points) You want to construct the multiple regression model to better predict the reported Adjusted R Square Std. Error of the Estimate C-statistic violent crime rate per 100,000 residents y = reported violent crime rate per 100,000 residents, X1 X 1 is annual police funding in S/resident, X2 is % of people 25 years+ with 4 yrs. of high school, X3 X 2 is % of people 25 years+ with at least 4 years of college. X1X2 X1,X2, X3. a. Check multicollinearity by find VIF, fill the following table. Is there any serious multicollinerity among predictors? Why? Model VIF f. Select the best model among the above models by using Adjusted R Square, Std. Error of the Constant 9.268 Estimate, (C statistic). State your reason for each criteria. X 1 1.270 X2 1.274 1.124 b. Check multicollinearity by find Correlation Coefficient Matrix, fill the following table. Please list all pairs with significant linear relationship. Is there any serious multicollinerity among predictors? Why? X1 X 2 X3 X1 1 0.431 0.279 g. Use the stepwise method to select the best model. Write the best fitted model. Describe all steps in X- 431 283 stepwise. X3 .279 283 C. Is X3 significant in the multiple linear regression model when X, and X2 already in the model? State your hypothesis test, write all 6 steps to make the conclusion. Carry out the test, using a=.05. 1. Is X2 significant in the multiple linear regression model when X, and X3 already in the model? State your hypothesis test, write all steps to make the conclusion. Carry out the test, using a=.05