1. Produce a frequency table and a pie chart for RACE. Summarize the results. (Note that 0 = White and 1= Black).
2. Produce the mode, median, mean, standard deviation, variance, range, minimum, and maximum for JAIL CREDIT and AGE ADMIT. Report the results.
3. Construct a 95% confidence interval around the sample mean of JAIL CREDIT and AGE ADMIT, respectively. Interpret and summarize your results.
4. Assume that the average age of offenders at prison admissions in the state of Florida is 30. Use the data to perform a hypothesis test to determine if the average age of offenders at prison admissions in your sample is significantly different from the average age in the offender population in Florida. The variable that measures the average age of offenders at prison admission is AGE ADMIT. Use a .05 level of statistical significance. Run the one-sample t-test in Excel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.
5. Assume that the average length of jail in pretrial in the state of Florida is 90 days. Use the data to perform a hypothesis test to determine if the average length of jail in pretrial in your sample is significantly different from the average length of jail in pretrial in Florida. The variable that measures the average length of jail in pretrial is JAIL CREDIT. Use a .05 level of statistical significance. Run the one-sample t-test in Excel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.
6. Conduct an independent sample t-test (alpha= .05) in Excel to determine whether there is a significant difference in the length of jail in pretrial between White and Black offenders. For this t-test, assume that the variances of the two groups are unequal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.
7. Conduct an independent sample t-test (alpha= .05) in Excel 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.
8. Conduct a Chi-Square test in Excel 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.
9. Conduct an ANOVA test in Excel to determine if there is a significant difference in JAIL CREDIT across offense types. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.
10. Correlate AGE ADMIT and JAIL CREDIT in Excel. 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)

Link to data chart: https://docs.google.com/spreadsheets/d/1_06M0xILmtGxUEyUSQZmrZcaQlghT-A-1ZzCUsCGgA4/edit?usp=sharing