Question

In: Math

The following is the regression output for a study on serious crime rates in cities in...

The following is the regression output for a study on serious crime rates in cities in the United States. The data was collected in the 1970s. AREA is the size of the city, DOCS is the number of Doctors, % > 65 is the proportion of residents greater than 65 years of age and HOSPITAL BEDS is the number of hospital beds per population. Answer the following questions given the supplied regression output. These variables are regressed on the serious crime rates in an attempt to explain variance in crime rates in different cities. (3 points per question)

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.673273

R Square

0.4532966

Adjusted R Square

0.4047007

Standard Error

12.033733

Observations

50

ANOVA

df

SS

MS

F

Significance F

Regression

4

5403.1119

1350.778

9.3278852

1.40799E-05

Residual

45

6516.4834

144.81074

Total

49

11919.595

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

66.550797

9.4140949

7.069272

8.044E-09

47.58983709

85.511758

AREA

1.9887428

0.8666883

2.2946459

0.0264716

0.24314292

3.7343427

% > 65

-1.368696

0.6703271

-2.041833

0.0470559

-2.718804364

-0.018588

DOCS

8.6790607

3.3369629

2.6008862

0.1125379

1.958072413

15.400049

HOSP BEDS

-2.407649

0.7129517

-3.377016

0.0015198

-3.843607893

-0.971691

  1. How accurate is regression model? What amount of the variance in Serious Crimes is explained
  2. How strong is the linear relationship between the predictors and Serious Crimes?
  3. How close to the regression line is the majority of observations?
  4. Does the model fit the data better than not using these predictor variables? Is the F-test significant? What hypothesis can we draw from it?
  5. Use the output to form the regression equation.
  6. Are all the predictors significant? Is zero contained in the confidence intervals? Why is that interesting?
  7. Of the significant variables, does the corresponding slopes make intuitive sense?   Are the effects of the predictors reasonable?
  8. How much variance in serious crime is unaccounted for? What additional data might explain some of this remaining variance?

Solutions

Expert Solution

How accurate is regression model? What amount of the variance in Serious Crimes is explained

R^2 = 0.4533

hence 45.33 % of variance is explained by this model

How strong is the linear relationship between the predictors and Serious Crimes?

significance F = 1.4080*10^(-5) << 0.05

hence the model is significant


How close to the regression line is the majority of observations?

standard error = 12.0337


Does the model fit the data better than not using these predictor variables? Is the F-test significant? What hypothesis can we draw from it?

yes, as F-test significant

Are all the predictors significant? Is zero contained in the confidence intervals? Why is that interesting?

yes , all predictors are significant as p-value < 0.05 for all 4 variable

zero is not present in confidence intervals ,this is interesting because p-value < 0.05 in each case and 0 is not present in any CI


Of the significant variables, does the corresponding slopes make intuitive sense?   Are the effects of the predictors reasonable?

yes, slope make intuitive sense


How much variance in serious crime is unaccounted for? What additional data might explain some of this remaining variance?

unaccounted = 1 - 0.4533 = 0.5467


Related Solutions

Mention at least two cities which are in serious threat of Urbanization. Dwellers of these cities...
Mention at least two cities which are in serious threat of Urbanization. Dwellers of these cities face many problems regularly. Discuss the drawbacks of urbanization of any one city following your text. Suggest at least one recommendation for combating each problem in an efficient manner.
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE T P-vaule Constant 7.096 3.245 2.187 0.010 x1 0.222 0.117 1.897 0.000 x2 -1.024 0.562 -1.822 0.028 x3 -0.337 0.192 -1.755 0.114 x4 0.623 0.263 2.369 0.001 x5 -0.056 0.029 -2.000 0.112 Analysis of Variance Source DF SS MS F P-Value Regression 5 2009.28 401.9 7.33 0.000 Residual Error 50 2741.54 54.83...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars.    Predictor Coef SE Coef T     Constant 10.237 3.447 2.97 X1 0.392 -0.209 -1.88 X2 -0.392 -0.099 3.96 X3 0.207 -0.110 -1.88 X4 0.794 0.201 3.95 X5 -0.335 -0.126 2.66      Analysis of Variance   Source DF SS MS F   Regression 5 3710.00 742.00 15.14   Residual Error 48 2647.38 57.55   Total 53 6357.38    X1...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 8.870 3.128 2.836 0.010 x1 0.212 0.050 4.240 0.000 x2 − 1.004 0.545 − 1.842 0.028 x3 − 0.246 0.387 − 0.636 0.114 x4 0.669 0.326 2.052 0.001 x5 − 0.062 0.030 − 2.067 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,029.13 405.8...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT