Question

1. Use the Recidivism.xls data, conduct an independent sample t-test (alpha= .05) in Excel to

determine whether there is a significant difference in AGE between those who recidivated

(RECIDIVISM=1) and those who did not recidivate (RECIDIVISM=0). For this t-test, as-

sume that the variances of the two groups are equal. Copy and paste the Excel output here.

In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this

hypothesis test, and interpret the result.

2. Use the Recidivism.xls data, conduct an independent sample t-test (alpha= .05) in Excel to

determine whether there is a significant difference in AGE between those who recidivated

(RECIDIVISM=1) and those who did not recidivate (RECIDIVISM=0). For this t-test, as-

sume that the variances of the two groups are unequal. Copy and paste the Excel output

here. In your summary, please discuss the null hypothesis, alternative hypothesis, the result

of this hypothesis test, and interpret the result.

3. Use the Recidivism.xls data, conduct an ANOVA (alpha= .05) in Excel to determine

whether there is a significant difference in AGE across different CRIME (1=violent,

2-property, and 3=drug). Copy and paste the Excel output here. In your summary, please

discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and in-

terpret the result.

Question image 1