The Pages in the Workbook: 1. 6 states [all data] 2. 6 states with only Cocaine Heroin and Methadone reported by state 3. Raw data table for Cocaine Heroin and Methadone reported by state 4. 6 states with opioids, natural and semi synthetic opioids, and synthetic opioids reported by state. 5. Raw data table for opioids, natural and semi synthetic opioids, and synthetic opioids reported by state. 6. Chi Square on opioids in three states observed and expected with the null hypothesis given. P 0.05. 7. Chi Square comparing two groups of drugs by three states. P 0.05. 8. T-Test raw data - Data sorted by state and by substance - Column B and A data sorted. 9. Run the T-Test comparing Column A and Column B drugs for all 6 states.

The following are what needs to be included in your report.

• Comparing deaths from cocaine, methadone, heroin all 6 states. Find totals and then create a bar chart or pie chart with results and labels displayed.
• Comparing deaths from all types opioids all 6 states. Find totals and then create a bar chart or pie chart with results and labels displayed.
• Chi square on opioids / states. Write the alternative hypothesis.
• Chi test to accept or reject the null hypothesis. Write the alternative hypothesis. Write a 3-5 sentence paragraph on your findings. *Column A = Synthetic opioids, excl. methadone, Opioids , Natural & semi-synthetic opioids. *Column B = Methadone, Heroin, Cocaine, Psychostimulants with abuse potential.
• T-Test p 0.05. Run a T-test to determine if there is any significance between categories of drugs and state of reported deaths. Write the alternative hypothesis.
• For all six states - Find the mean of each of the 7 categories of drugs.Find the mean for total number of drug overdose deaths.
• Tennessee
• Ohio
• Michigan
• Kentucky
• Indiana
• Illinois

~For Total Mean Deaths for 10 months by State.Find totals and then create a bar chart or pie chart with results and labels displayed.Write a 3-5 sentence paragraph explaining the results.

~ Total Deaths by natural semi synthetic opioids 10 months by StateFind totals and then create a bar chart or pie chart with results and labels displayed.

~ Total Deaths by synthetic opioids 10 months by State.Find totals and then create a bar chart or pie chart with results and labels displayed.