Introduction Project 3 Hypothesis Tests Due: Friday, April 22nd by 11:59PM The goal of this project is to analyze per capita income and the drug overdose mortality rate for each of the fifty states, for a given year, and over time. The report should be organized, formatted well, and typed (in a program like Microsoft Word). All work MUST be your own. Graphs should be copy and pasted into your report. Do not just print out your Excel spreadsheet. Directions Select the data set from within the assignment posted on Canvas. Use lecture slides from Friday, April 15th as a guide to generate the needed graphs for this project. Use Pages 18-21 from the book as a guide to generate the summary statistics needed for the hypothesis test. Use Pages 229-231 from the book as a guide for the hypothesis test computations. The Assignment Paragraph 1 Use Excel to graph a scatterplot. Per Capita Income should be on the horizonal axis versus Overdose Death Rate on the vertical axis. Make sure the graph is fully labeled. Briefly summarize the visual association between the two variables (positive, negative, or no association). Paragraph 2 Test the alternative hypothesis that the average overdose death rate per 100,000 individuals (across the 50 states) is greater in 2019 than in 2015 (the average in 2015 was 17.8, which will be used as o). Take the level of significance to be 0.05. Exhibit the null and alternative, show all your work for the standard score, report a p-value and explain how you got it, and explain your ultimate decision. Make sure to also explain the type of uncertainty that statistical significance addresses (use lecture slide 12 from Friday, March 25th and lecture slide 16 from Friday, April 8th as a guide). Paragraph 3 In February 2021, the Chicago Tribute reported: "The overdose epidemic that has ravaged Chicago has not spared the nearby suburbs, some of which have death rates comparable to anything seen in the city, according to a report released this week by the Cook County Department of Public Health. ZIP codes in the towns of Worth, Broadview, Maywood and Forest Park, areas that "have substantially lower median household incomes and higher poverty rates," have been especially hard-hit, the report said." In the article, they claimed that lower incomes were associated with higher overdose death rates and that overdose death rates are increasing over time. The data you have been analyzing wasn't focused on Chicago, obviously. But do your results support the general gist of the statistical argument being made in this Tribune excerpt? Please address: Do overdose death rates appear to be associated with per capita income (use scatterplot)? Do overdose death rates appear to be increasing over time (use hypothesis test)? Final Advice Make sure the report is carefully proofed, unique to you, and well written. Do not answer in bulleted or list format.