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.

Data information in the following picture