1.Use the Recidivism.xls data,

Conduct a Chi-Square independence test (alpha= .05) in Excel

to determine whether there is a significant relationship between RACE (1=Black, 2=White)

and RECIDIVISM (1=the ex-offender recidivate, 0=the ex-offender did not recidivate).

	person	sex	race	age	crime	recidivism	custody
	1	1	1	52	2	1	Minimum
	2	1	1	43	3	0	Close
	3	1	2	22	1	0	Close
	4	1	2	47	1	0	Close
	5	1	2	63	2	0	Minimum
	6	1	2	31	3	1	Medium
	7	1	2	76	2	1	Medium
	8	1	1	70	1	0	Close
	9	1	1	37	2	1	Medium
	10	1	2	49	2	1	Medium
	11	1	2	54	2	0	Minimum
	12	1	2	68	2	0	Minimum
	13	1	2	23	1	1	Medium
	14	1	2	47	3	0	Close
	15	1	2	61	2	0	Medium
	16	1	1	33	2	0	Close
	17	1	2	45	3	0	Minimum
	18	1	1	34	1	0	Minimum
	19	1	2	54	2	1	Minimum
	20	1	2	29	2	0	Medium
	21	1	2	56	2	0	Medium
	22	1	2	29	3	1	Medium
	23	1	2	30	1	1	Minimum
	24	1	2	21	1	0	Medium
	25	1	1	51	1	0	Medium
	26	1	1	55	2	1	Medium
	27	1	1	78	2	1	Medium
	28	1	2	72	3	0	Medium
	29	1	2	46	2	0	Medium
	30	1	2	42	2	0	Medium