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.

Variable Type of Variable Label Value Labels Values Explanation Name Variable County Character County of NA Literal name of county Sex Character Sex of Offender NA Literal name of sex Male, Female Race Character Race of Offender | NA Literal name of race White, Black, Chinese, Nat. Amer. Hispanic, All Others, Unknown Sentence | Numeric Length of Sentence | NA Sentence length in in Months months, except 9999998 = Life, 9999999 = Death Offense Numeric Primary Offense 1 = Murder 2 = Sex Offense 3 =Robbery 4 = Other Violent 5 = Burglary 6 = Property 7 = Drugs 8 = Weapons 9 = Other Crimes JailCredit | Numeric Length in Jail NA In Days Pretrial AgeAdmit | Numeric Age of Offender at | NA In Years Prison Admissions