1 .3 9 1 1 1 1 9 9 8 5 8 3 7 .7 8 1 4 6 8 8 9 6 6 6 1927 .9 3 9 4 918221 ,0 1001

Question

1 .3 9 1 1 1 1 9 9 8 5 8 3 7 .7 8 1 4 6 8 8 9 6 6 6 1927 .9 3 9 4 918221 ,0 1001188 0100891120108900 40 70 80 30 80 90 00 20 10 60 70 0 0 0 50 70 70 10 70 60 70 80 30 00 60 40 40 70 70 60 30 70 20 95177827225802028322581 353656644565554446665255465563464 3395-6 33878540971782030118 311512 237436086673 2 0422331357 2 9 0 9 9 9 9 9 99099999999999990909099099 115992861013735857 401706617665761206 3373167441 8754775558 8 3 5 9 9 8 2 5 5 1 1 5 7 2 7 1 6 3 8 3 4 7 78309268503 504401816727665862217487666865596 101000111000001101000100000001001 7 3 7 8 8 8 5 4 9 3 6 5 8 8 8 9615257978 631793424443150 85679597274295 6 0 1|2|3 4 5 6 7 8 9 0 1|2|3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3

Explanation / Answer

Solution:

a. Using excel, the following output is obtained

b0 = 93.0677

b1 = -7.6927

R-sq = 0.009054

p-value = 0.5246

b. Using excel, the following output is obtained

b0 = -178.5940

b1 = -2.3774 p-value = 0.8503

b2 = 0.2745 p-value = 0.1845

R-sq = 0.048369

c. using excel, the following output is obtained

b0 = 1.3247

b1 = 15.1474 p-value = 0.1086

b2 = 0.9879 p-value = 0.0000

R-sq = 0.5040

d. Using excel, the following output is obtained

b0 = -368.3372

b1 = 23.1387 p-value = 0.0153

b2 = 1.0235 p-value = 0.0000

b3 = 0.3702 p-value = 0.010469

R-sq = 0.5749

g. The equation is Robbery rate = 93.06774 - 7.69274Southern

When Southern = 1, the predicted robbery rate would be

Robbery rate = 93.06774 - 7.69274(1)

Robbery rate = 85.375

h. 4.84%

i.57.49%

j. The regression equation is Robbery rate = 1.3247 + 15.1474 Southern + 0.9879 expend 1960

When Southern = 1 and expend 1960 = 44, the robbery rate would be

Robbery rate = 1.3247 + 15.1474 (1) + 0.9879 (44)

Robbery rate = 59.9377

When Southern = 0 and expend 1960 = 55, the robbery rate would be

Robbery rate = 1.3247 + 15.1474 (0) + 0.9879 (55)

Robbery rate = 55.6567

k. Slope coefficient for Southern:

Margin of error = 18.6415

CI lower bound = -3.4941

CI upper bound = 33.7889

Slope coefficient for Expend 1960

Margin of error = 0.3004

CI lower bound = 0.6874

CI upper bound = 1.2883

SUMMARY OUTPUT Regression Statistics Multiple R 0.095152 R Square 0.009054 Adjusted R Square -0.01297 Standard Error 38.97372 Observations 47 ANOVA df SS MS F Significance F Regression 1 624.5197 624.5197 0.411152 0.524638 Residual 45 68352.8 1518.951 Total 46 68977.32 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Robbery rate 93.06774 6.999887 13.29561 3.42E-17 78.96925 107.1662 Southern -7.69274 11.9972 -0.64121 0.524638 -31.8563 16.47086

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.