A regression model to predict y the state by state burglary crime rate per 100,00 people used the following four state predictor X1 = median age in 2005, X2 = number of 2005 bankruptcies per 1,000 people, X3 = 2004 federal expenditures per capita, and X4 = 2005 high school graduation percentage.

Using the sample size of 50 people calculate the t-calc and the p-value in the tables given below

Abbrev	State	Burglary	AgeMed	Bankrupt	FedSpend	HSGrad%
AL	Alabama	986	37.4	10.57	8619	80.9
AK	Alaska	576	33.9	3.48	12885	91.7
AZ	Arizona	990	34.5	6.85	7309	85.7
AR	Arkansas	1094	37.0	11.01	7080	81.4
CA	California	685	34.4	4.63	6474	80.3
CO	Colorado	717	34.7	9.37	6533	89.2
CT	Connecticut	444	39.3	4.36	8649	90.0
DE	Delaware	648	37.9	5.22	6326	86.8
FL	Florida	956	39.5	6.16	7009	86.8
GA	Georgia	940	34.3	9.13	6247	85.7
HI	Hawaii	857	38.5	3.52	9651	87.3
ID	Idaho	547	34.6	8.51	6437	89.1
IL	Illinois	597	35.6	8.43	6043	87.3
IN	Indiana	676	36.1	12.63	6079	87.2
IA	Iowa	615	38.6	6.29	6505	89.9
KS	Kansas	731	36.1	8.28	6993	91.4
KY	Kentucky	625	37.5	9.67	7649	78.9
LA	Louisiana	1005	35.4	8.10	7298	80.2
ME	Maine	481	41.2	5.01	8248	87.2
MD	Maryland	660	37.1	6.31	11645	87.0
MA	Massachusetts	537	38.2	4.10	8279	87.5
MI	Michigan	637	36.9	8.77	5981	88.5
MN	Minnesota	550	36.7	4.98	5644	92.7
MS	Mississippi	953	35.5	8.12	7695	79.9
MO	Missouri	703	37.4	9.11	7947	85.4
MT	Montana	379	40.2	6.32	8085	92.1
NE	Nebraska	562	36.2	6.95	6751	89.7
NV	Nevada	991	35.2	10.11	5469	86.6
NH	New Hampshire	382	39.5	4.64	6124	91.9
NJ	New Jersey	472	38.0	5.67	6353	87.0
NM	New Mexico	1047	36.2	6.53	10437	81.0
NY	New York	368	37.5	5.69	7484	85.6
NC	North Carolina	1185	36.2	4.94	6467	84.0
ND	North Dakota	301	39.1	5.57	9513	90.0
OH	Ohio	846	37.6	11.82	6388	87.9
OK	Oklahoma	1000	36.5	11.20	7562	85.2
OR	Oregon	837	37.0	9.09	6084	88.7
PA	Pennsylvania	439	39.7	6.35	7649	86.3
RI	Rhode Island	506	38.4	5.37	7630	84.0
SC	South Carolina	1034	37.1	3.66	7158	83.0
SD	South Dakota	409	37.0	5.40	8564	88.5
TN	Tennessee	1020	37.3	11.05	7701	81.8
TX	Texas	979	33.2	5.32	6308	78.2
UT	Utah	637	28.5	9.07	5728	92.7
VT	Vermont	545	40.7	4.16	7456	90.0
VA	Virginia	386	37.2	5.97	12150	86.1
WA	Washington	977	36.7	7.56	7228	91.5
WV	West Virginia	602	40.7	9.76	8364	82.4
WI	Wisconsin	433	37.9	6.89	5728	90.5
WY	Wyoming	541	39.1	6.44	8673	90.9

Predictor Coefficient SE Tcalc p-value

Intercept 4551.9569 798.4390

AgeMed -28.390 12.9414

Bankrupt 20.0435 12.5747

FedSpend -0.0180 0.0103

HSGrad % -29.2003 7.1716