Use SPSS to run a multiple regression model with CrimeRate as the response varia
ID: 3241019 • Letter: U
Question
Use SPSS to run a multiple regression model with CrimeRate as the response variable and every other variable in the data set as a predictor.
a. Fill in the coefficients for the estimated LOBF: Report your answers to 3 decimal places.
CrimeRate =_____ +_______ *Southern +______ *Expend1960 +______ *Expend1959 +________ *MalesPerFemales + _____ *StatePopulation +_______ *Income + _______*YearsSchooling
b. Which predictor variables are "significant" (meaning that they have estimated coefficients that differ significantly from zero), when controlling for all other variables? Select all that apply.
CrimeRate
Southern
Expend1960
Expend1959
MalesPerFemales
StatePopulation
Income
YearsSchooling
No predictors are significant
Column1 CrimeRate Southern Expend1960 Expend1959 MalesPerFemales StatePopulation Income YearsSchooling 1 79.1 1 58 56 950 33 3940 9.1 2 163.5 0 103 95 1012 13 5570 11.3 3 57.8 1 45 44 969 18 3180 8.9 4 196.9 0 149 141 994 157 6730 12.1 5 123.4 0 109 101 985 18 5780 12.1 6 68.2 0 118 115 964 25 6890 11 7 96.3 1 82 79 982 4 6200 11.1 8 155.5 1 115 109 969 50 4720 10.9 9 85.6 1 65 62 955 39 4210 9 10 70.5 0 71 68 1029 7 5260 11.8 11 167.4 0 121 116 966 101 6570 10.5 12 84.9 0 75 71 972 47 5800 10.8 13 51.1 0 67 60 972 28 5070 11.3 14 66.4 0 62 61 986 22 5290 11.7 15 79.8 1 57 53 986 30 4050 8.7 16 94.6 1 81 77 956 33 4270 8.8 17 53.9 0 66 63 977 10 4870 11 18 92.9 1 123 115 978 31 6310 10.4 19 75 0 128 128 934 51 6270 11.6 20 122.5 0 113 105 985 78 6260 10.8 21 74.2 0 74 67 984 34 5570 10.8 22 43.9 1 47 44 962 22 2880 8.9 23 121.6 0 87 83 953 43 5130 9.6 24 96.8 0 78 73 1038 7 5400 11.6 25 52.3 0 63 57 984 14 4860 11.6 26 199.3 0 160 143 1071 3 6740 12.1 27 34.2 0 69 71 965 6 5640 10.9 28 121.6 0 82 76 1018 10 5370 11.2 29 104.3 0 166 157 938 168 6370 10.7 30 69.6 1 58 54 973 46 3960 8.9 31 37.3 0 55 54 1045 6 4530 9.3 32 75.4 0 90 81 964 97 6170 10.9 33 107.2 1 63 64 972 23 4620 10.4 34 92.3 0 97 97 990 18 5890 11.8 35 65.3 0 97 87 948 113 5720 10.2 36 127.2 0 109 98 964 9 5590 10 37 83.1 1 58 56 974 24 3820 8.7 38 56.6 0 51 47 1024 7 4250 10.4 39 82.6 1 61 54 953 36 3950 8.8 40 115.1 1 82 74 981 96 4880 10.4 41 88 0 72 66 998 9 5900 12.2 42 54.2 0 56 54 968 4 4890 10.9 43 82.3 1 75 70 996 40 4960 9.9 44 103 0 95 96 1012 29 6220 12.1 45 45.5 1 46 41 968 19 4570 8.8 46 50.8 0 106 97 989 40 5930 10.4 47 84.9 0 90 91 1049 3 5880 12.1Explanation / Answer
Solution:
Using SPSS we got this output with Crime rate dependent Variable and All other independent variables.
So multiple regression equation should be
CrimeRate =-366.873 +23.76*Southern +2.348 *Expend1960 -1.364 *Expend1959 +0.3318 *MalesPerFemales + 0.092*StatePopulation -0.0100*Income + 6.4771*YearsSchooling
If we take alpha 0.1 than we find Southern, Expend 1960 and Males per Females are the variables which are significant because p-value is less than 0.1 and all other variables are insignificant p-value is greater than 0.1.
SUMMARY OUTPUT Regression Statistics Multiple R 0.778966 R Square 0.606787 Adjusted R Square 0.536211 Standard Error 26.33934 Observations 47 ANOVA df SS MS F Significance F Regression 7 41752.61 5964.658 8.597573 2.42E-06 Residual 39 27056.67 693.7607 Total 46 68809.28 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -366.873 161.6375 -2.26973 0.028831 -693.815 -39.93 -693.815 -39.93 X Variable 1 23.76859 12.1145 1.961995 0.056928 -0.7353 48.27248 -0.7353 48.27248 X Variable 2 2.348972 1.223431 1.919987 0.062195 -0.12565 4.823595 -0.12565 4.823595 X Variable 3 -1.35643 1.302425 -1.04146 0.304074 -3.99083 1.277975 -3.99083 1.277975 X Variable 4 0.33186 0.170613 1.945111 0.058997 -0.01324 0.676957 -0.01324 0.676957 X Variable 5 0.092828 0.142319 0.652255 0.518063 -0.19504 0.380696 -0.19504 0.380696 X Variable 6 -0.01009 0.0092 -1.09674 0.279482 -0.0287 0.008519 -0.0287 0.008519 X Variable 7 7.747764 6.47711 1.196176 0.23885 -5.35343 20.84896 -5.35343 20.84896Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.