Figure 2 shows Excel output estimating the following model: NumBikeThefts = 0 +

Question

Figure 2 shows Excel output estimating the following model:

NumBikeThefts= 0 + 1Income + 2Unem + 3Pupil/Tea + 4Divorce +

Where, NumBikeThefts = the number of bikes stolen per state, Income = per capita income per state in dollars, Unem = % of population unemployed by state, Pupil/Tea = the ratio of students to teachers by state, and Divorce = the divorce rate by state.

Which coefficient(s) is (are) significant at the .025 level?

Select one:

a. Income, Unemployment and Pupil/Tea

b. Divorce

c. Income and Pupil/Tea

d. Income

13)  

Refer to Figure 2

Is the regression equation significant at the .05 level?

Select one:

a. YES

b. NO

c. Need more information to answer this question

14)

Refer to Figure 2

Which of the following is a correct interpretation for the variableIncome?

Select one:

a. A 1 dollar increase in per capita income results in fewer bike thefts.

b. Per capita income does not significantly affect the number of bike thefts at the .05 level.

c. A 1 dollar increase in per capita income results in the predicted number of bike thefts to increase by 0.02.

d. An increase in per capita income of $1,000 results in the predicted number of bike thefts to increase by 2.

15)

Refer to Figure 2

What is the predicted number of bike thefts in a state with a per capita income of $25,000, an unemployment rate of 8% (enter in “8”), a pupil teacher ratio of 20 and a divorce rate of 1% (enter in “1”)? Round to 4 decimal places when making the calculations.

Select one:

a. 267

b. 321

c. 582

d. 496

SUMMARY OUTPUT Regression Statistics Multiple R R Squar Adjusted R Square Standard Error Observations 0.688307309 0.473766951 0.42699068 143.3619565 50 ANOVA df MS Significance F 4 832658.6447 208164.6612 10.12836084 6.21151E-06 Regression Residual Total 45 924869.2753 20552.65056 49 1757527.92 t Stat P-value Lower 95% Upper 95% Intercept Income Unem Pupil/Tea Divorce Coefficients Standard Error 1097.525801 254.7116137 -4.308895795 8.80366E-05-1610.541318-584.5102843 0.023041215 0.006347323.630069674 0.000721664 0.010257056 0.035825374 40.628154518.39627131 2.2084994190.032345567 3.576162662 77.68014636 37.63883846 9.704689232 3.878417697 0.000339768 8.0925912857.18508564 26.3106301 20.17113717 1.304370194 0.19873958814.31612504 66.93738523 Figure 2.

Explanation / Answer

Q12) Option C is Correct. Income and Pupil/Tea because their p values is less than 0.025

Q13) Yes, it is significant at 5%

Q14) Option C is Correct. A 1 dollar increase in per capita income results in the predicted number of bike thefts to increase by 0.02

Q15) Y = -1097.5258+0.02304*25000+40.6282*8+37.6388*20+26.3106*1 = 582

Option C is Correct

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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