Question
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
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. Count of race Column Labels Row Labels 0 1 Grand Total Grand Total Row Labels 1 1 5 1 5 2 8 13 2 5 13 3 9 4 13 <---observed frequencies 3 4 13 4 10 20 4 into 00 2 10 5 12 wo 00 00 00 un 8 5 i wooooooo 12 8 20 6 5 6 5 6 7 8 8 16 6 7 ? ?? 8 16 8 9 4 13 8 4 13 9 1 4 9 1 4 Grand Total 63 37 100 Grand Total 63 37 100 Row Labels 0 1 Grand Total 5 1 3.15 2 8.19 13 1.85 4.81 4.81 3.7 3 4 13 10 <----Expected Frequency 20 5 6 7 8.19 6.3 12.6 3.78 10.08 8.19 2.52 7.4 2.22 5.92 4.81 6 16 8 13 9 1.48 4 Grand Total 63 37 100
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started