Imagine that you have been hired as a data analyst for the health department. While cancer studies continue to try to solve the medical mysteries of cancer occurrences and death, the health department would like to see if there is a relationship between the death rates of cancer and various demographic qualities in counties across the United States. For this report, you will analyze the relationship between poverty rates and cancer-related death occurrence rates from a supplied data set of over 90% of counties in the United States. You will then use two methods to test a claim that the mean poverty rate is 16%. Your calculations will be executed in Microsoft Excel. You will submit your Excel file for your instructor’s reference. You will also submit a written report as a Word file. This written report will contain not only your analysis, but also images of supporting graphs, charts, and tables from your Excel file. Follow the instructions below to complete calculations and create visual representations of data within your Excel data file and complete the corresponding sections of your written report. Begin by reading through the directions for this assignment in full. In your Excel file 1. Randomly select 200 counties from the DATA tab to use for your sample. Be sure to follow the process outlined in the video guide for this project to ensure that your sample is randomly selected. 2. Highlight all information for your random sample, including your rand() column, click Ctrl-C, then place it into cell A1 of the CALCULATIONS tab by selecting the Calculations tab, then A1, and clicking Ctrl-V. Ignore the original data tab sheet once you create your sample. Work only with your sampled data. MTH 315 – Project 2 Assignment Instructions 2 3. Create a histogram for each poverty level and death from cancer. 4. Calculate the mean and the five-number summary for each variable. In your report 5. Beginning on the title page, replace bracketed text with your information and work. The brackets themselves should also be removed