Question

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

Figure 2 shows Excel output estimating the following model: NumBikeThefts-β0+81 Income + β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 divorce rate by state. the SUMMARY OUTPUT ssion Statistics 0.688307309 0.473766951 0.42699068 143.3619565 50 Multiple R R Square Adjusted R Square Standard Error Observations ANOVA df MS Significance F 4 832658.6447 208164.6612 10.128360846.21151E-06 Regression Residual Total 45 924869.2753 20552.65056 9 1757527.92 t Stat r 9596 Coefficients Standard Error 1097.525801 254.7116137-4.308895795 8.80366E-05-1610.541318-584.5102843 0.023041215 0.00634732 3.630069674 0.000721664 0.010257056 0.035825374 40.62815451 18.39627131 2.208499419 0.032345567 3.57616266277.68014636 37.63883846 9.704689232 3.878417697 0.000339768 18.09259128 57.18508564 P-value Lower 95% Intercept Income Unem PupilTea Divorce 26.3106301 20.17113717 1.304370194 0.198739588 -14.31612504 66.93738523 Figure 2.

Select one:

a. Income, Unemployment and Pupil/Tea

b. Divorce

c. Income and Pupil/Tea

d. Income

PART B-- 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

PART C-- Refer to Figure 2

Which of the following is a correct interpretation for the variable Unem?

Select one:

a. Unemployed people steal 40.63 more bikes relative to employed people.

b. A 1% increase in the unemployment rate results in about 41 more bike thefts.

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

d. For every additional 41 bike thefts, there is a 1% increase in unemployment.

PART D--   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 10% (enter in “10”)? Round to 4 decimal places when making the calculations.

Select one:

a. 267

b. 321

c. 582

d. 818

Answer 1

12)

a. Income, Unemployment and Pupil/Tea (As there p values are less than 0.05)

13)

Is the regression equation significant at the .05 level? :Yes

14) b. A 1% increase in the unemployment rate results in about 41 more bike thefts.

15)

predicted number of bike thefts = -1097.53+0.023*25000+40.628*8+37.64*20+26.31*10=818