Statistics homework help. WEEK 3 ASSIGNMENTS:
M2.1 Engage: Graphs
Thinking about the video you just watched, create 3 different data sets with data of your choosing. You may wish to poll individuals on a topic related to the video or gather data associated with your research that is related to the video. Place the data in the appropriate graph.
DISCUSSION INSTRUCTIONS
Discuss how the graph you created visually communicates your data sets. Why did you select it?
M2.2 Engage: Null Hypothesis
The scientific method is used to determine fact and truth. Doing so is more difficult than might be immediately evident.
As you have discovered, hypotheses are statements that can be proven to be true or false. A hypothesis allows you to center your work specifically and to create a foundation for your case to support decisions made for improving the situation in Dayton.
ASSIGNMENT INSTRUCTIONS
For this assignment, create an alternative and null hypothesis for your solution to the opioid crisis. Be sure to follow the guidelines on hypotheses creation from the activity notes above.
M2.3 Engage: Excel and Comparison of Means
You have been working in Excel to find descriptive statistics, now let’s explore how to compare means. You will need to utilize the Excel spreadsheet with your descriptives from your M1.5 assignment.
When comparing means, we would like to know if they are significantly different. Keeping in mind that your data in your spreadsheet gives three different groups of data, one for 2017, 2018, and 2019, simple comparisons of means procedures typically only cover two means. Running multiple tests is not ideal, but for our purposes, let’s examine the independent-t procedure. Simply put, in this case we have the following:
| Research Question and Hypotheses | |
| Research Question | Is there a significant difference in the number of accidental overdose deaths in Montgomery County in 2017 and 2018? |
| Research/Alternative Hypothesis | There is a significant difference in the number of accidental overdose deaths in Montgomery County for 2017 and 2018. |
| Null Hypothesis | There is no significant difference in the number of accidental overdose deaths in Montgomery County for 2017 and 2018. |
Why might we want to explore this? Perhaps we have implemented a solution to the problem and want to see if it was effective. Maybe we just want to see if there is a difference so we can begin to look for variables that might have impacted the change. Regardless, an independent-t test can tell us if two means are significantly different.
Please review the video above on how to run an independent-t test in Excel.
ASSIGNMENT INSTRUCTIONS
Following the video instructions, perform an independent-t test on your data sets for 2017 – 2018 and 2018 – 2019. Be sure to review the p value of the tests.
- Are there significant differences between these years?
- Be sure to label your output statistics on your worksheet so your instructor can identify the years you are comparing.
- In a separate Word document, explain the results of your twot-tests in a short paragraph.
https://youtu.be/kmww0EewIp0
https://www.youtube.com/watch?v=kmww0EewIp0&feature=youtu.be
M2.4 Engage: Locating Scholarly Material
Find three articles from three different scholarly journals or valid and reliable publications in your field specific to your role and solution to the opioid crisis. Your articles should contain data that you need to support your solution for your magazine article.
ASSIGNMENT INSTRUCTIONS
- Discuss why the test and data in the article are appropriate.
- Describe the data presented in each article in detail.
- Provide an interpretation of the results of the articles that is digestible by the average adult.
