question archive In this conversation, we'll explore the data from our weekly surveys
Subject:LawPrice:13.86 Bought3
In this conversation, we'll explore the data from our weekly surveys. Your instructor will provide you with the Excel worksheet which contains the data from the surveys completed in this course. The worksheet will also contain data for Dayton in particular.
What will you do with the data? Throughout the course, you have examined many different statistical analyses and their purpose and function. Be sure to visit your lifeline to determine the correct test and to refresh your memory on how to run statistical analyses in Excel.
DISCUSSION INSTRUCTIONS
Describe the statistical test you chose to run on the data. Why is the test appropriate from the data you chose to manipulate?
State the hypotheses for the test you are running on the data (alternative/research hypothesis and null hypothesis).
Provide the output table for your results. Were they significant? What does your test tell us about the data and why might it be useful?
Do you feel that your area is at a high risk for opioid addiction/ overdose? Yes No Yes Maybe Yes Yes No Yes Maybe Yes Maybe No No No Yes Yes Maybe Yes Yes Yes Maybe Would you categorize your area as rural, suburban or urban? Urban Rural Suburban Suburban Suburban Rural Suburban Urban Suburban Suburban Urban Urban Suburban Rural Suburban Suburban Urban Suburban Suburban Urban Suburban What is the estimated population of your area? 123,744 50,000 291,303 32,996 18,516 7,729 77,000 14,955 349,000 200,000 874,961 38,000,000 30,000 10,602 271,473 157,632 190,488 679,813 3,977 8,200,000 11,857 What is the educational level of most of the residents in your area? What is the median household income of your area? High school or GED completed 66,996 Some college 62,653 Some college 45,787 High school or GED completed 42,949 High school or GED completed 40,000 High school or GED completed 93,756 Some college 43,478 Some college 76,009 Graduate degree 75,200 High school or GED completed 56,948 Graduate degree 130,360 Bachelor's degree 48,000 Some college 52,000 Some college 67,813 High school or GED completed 52,716 Bachelor's degree 48,157 Some college 78,549 High school or GED completed 40,000 High school or GED completed 53,217 Some college 60,000 Some college 92,250 What is the most recent annual number of opioid overdoses for your area? 18 16 64 336 105 82 21 59 30 742 20 7 146 2 9 1,402 42 47 255 37 371 Does your areahavea ccess to an internatio nal airport? Is your area close to an interstate ? Yes No Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
Purchased 3 times