1. Conduct an independent sample t-test (alpha= .05) inExcel to determine whether there is a significant difference in the age of offenders at prison admissions between White and Black offenders. For this t-test, assume that the variances of the two groups are equal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

1. Conduct a Chi-Square test inExcel to determine if the race of offenders is independent of offense type.In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

1. Conduct an ANOVA test inExcel to determine if there is a significant difference in JAILCREDIT across offense types.In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

1. CorrelateAGEADMIT and JAILCREDIT inExcel. Summarize your results and make sure that you briefly explain what this correlation means to you in terms of the impact of age on the length of jail in pretrial (direction of the correlation, correlation coefficient, and test of significance result).

Variable Name	Type of Variable	Variable Label	Value Labels	Values Explanation
County	Character	County of Sentence	NA	Literal name of county
Sex	Character	Sex of Offender	NA	Literal name of sex-Male, Female
Race	Character	Race of Offender	NA	Literal name of race-White, Black, Chinese, Nat. Amer. Hispanic, All Others, Unknown
Sentence	Numeric	Length of Sentence in Months	NA	Sentence length in months, except 9999998 = Life, 9999999 = Death
Offense	Numeric	Primary Offense	1 = Murder
			2 = Sex Offense
			3 = Robbery
			4 = Other Violent
			5 = Burglary
			6 = Property
			7 = Drugs
			8 = Weapons
			9 = Other Crimes
JailCredit	Numeric	Length in Jail Pretrial	NA	In Days
AgeAdmit	Numeric	Age of Offender at Prison Admissions	NA	In Years

Excel link for data: https://arizonastateu-my.sharepoint.com/:x:/g/personal/gsmoral1_sundevils_asu_edu/EbuuHsFtjAVAuD7sj4K0YfIB2FpU6GboA1grf-UF11OdYA?rtime=eAtz-LTU2kg