Question
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
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, assume 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.
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 interpret the result.
person | sex | race | age | crime | recidivism | custody | |
1 | 1 | 2 | 27 | 3 | 1 | Medium | |
2 | 1 | 2 | 77 | 1 | 0 | Minimum | |
3 | 1 | 2 | 34 | 3 | 0 | Medium | |
4 | 1 | 1 | 70 | 1 | 0 | Medium | |
5 | 1 | 2 | 40 | 1 | 0 | Minimum | |
6 | 1 | 2 | 62 | 3 | 0 | Close | |
7 | 1 | 2 | 71 | 1 | 0 | Minimum | |
8 | 1 | 1 | 62 | 2 | 0 | Medium | |
9 | 1 | 1 | 57 | 2 | 0 | Medium | |
10 | 1 | 1 | 72 | 3 | 0 | Close | |
11 | 1 | 2 | 25 | 2 | 0 | Medium | |
12 | 1 | 2 | 51 | 3 | 0 | Medium | |
13 | 1 | 1 | 43 | 3 | 0 | Minimum | |
14 | 1 | 1 | 76 | 3 | 1 | Minimum | |
15 | 1 | 1 | 57 | 2 | 0 | Minimum | |
16 | 1 | 2 | 34 | 2 | 1 | Minimum | |
17 | 1 | 2 | 37 | 1 | 0 | Medium | |
18 | 1 | 1 | 61 | 2 | 1 | Close | |
19 | 1 | 2 | 40 | 2 | 0 | Close | |
20 | 1 | 2 | 73 | 1 | 0 | Minimum | |
21 | 1 | 2 | 44 | 2 | 0 | Minimum | |
22 | 1 | 2 | 39 | 2 | 1 | Medium | |
23 | 1 | 2 | 69 | 3 | 0 | Medium | |
24 | 1 | 2 | 52 | 2 | 0 | Medium | |
25 | 1 | 2 | 54 | 1 | 0 | Close | |
26 | 1 | 2 | 69 | 2 | 0 | Medium | |
27 | 1 | 1 | 77 | 1 | 1 | Minimum | |
28 | 1 | 2 | 32 | 2 | 0 | Close | |
29 | 1 | 1 | 71 | 2 | 0 | Minimum | |
30 | 1 | 2 | 42 | 1 | 0 | Medium |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started