A regression model to predict Y , the state burglary rate per 100,000 people for

Question

A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X4 = 2005 high school graduation percentage.

Fill in the values in the table given here for a two-tailed test at ? = 0.01 with 30 d.f. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your t-values to 3 decimal places and p-values to 4 decimal places.)

  

  

What is the critical value of Student's t in Appendix D for a two-tailed test at ? = 0.01 with 30 d.f? (Round your answer to 3 decimal places.)

A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X4 = 2005 high school graduation percentage.

Explanation / Answer

(a)

Following is the completed table:

(b-1)

The critical value, using excel function "=TINV(0.01,30)", the critical value is 2.750.

(b-2)

Since p-value is less than 0.01 for HSGrad% so

Only HSGrad% differs significantly from zero.

Predictor Coefficient SE tcalc=coefficient /Se p-value Excel function used for p value Intercept 4,029.24 792.2866 5.086 0 =ROUND(TDIST(D2,30,2),4) AgeMed -27.081 12.6421 -2.142 0.0404 =ROUND(TDIST(D3,30,2),4) Bankrupt 19.5689 12.8085 1.528 0.137 =ROUND(TDIST(D4,30,2),4) FedSpend -0.0182 0.014 -1.3 0.2035 =ROUND(TDIST(D5,30,2),4) HSGrad% -27.2539 7.1758 -3.798 0.0007 =ROUND(TDIST(D6,30,2),4)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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