Question

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

(a)	Fill in the values in the table given here for a two-tailed test at α = 0.01 with 40 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.)

  

Predictor	Coefficient	SE	tcalc	p-value
Intercept	4,459.7813	797.7352
AgeMed	-26.190	12.3168
Bankrupt	16.9037	12.6186
FedSpend	-0.0155	0.0133
HSGrad%	-30.9882	7.1255

  

(b-1)

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

  t-value =

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

(a)	Fill in the values in the table given here for a two-tailed test at α = 0.01 with 40 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.)

  

Predictor	Coefficient	SE	tcalc	p-value
Intercept	4,459.7813	797.7352
AgeMed	-26.190	12.3168
Bankrupt	16.9037	12.6186
FedSpend	-0.0155	0.0133
HSGrad%	-30.9882	7.1255

  

(b-1)

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

  t-value =

Answer 1

a and b)

Predictor	Coefficient	SE	tcalc	p-value	t critical
Intercept	4,459.78	797.7352	5.591	0.0000	2.704
AgeMed	-26.19	12.3168	-2.126	0.0397	2.704
Bankrupt	16.9037	12.6186	1.340	0.1879	2.704
FedSpend	-0.0155	0.0133	-1.165	0.2508	2.704
HSGrad%	-30.9882	7.1255	-4.349	0.0001	2.704
				T.DIST.2T(t stat,df)	T.INV.2T(alpha,df)

Use the formulas below or Use t table