The Excel and Comparison of Mean

This assignment is due Week 3:
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. The Excel website in your Lifeline can help as well.
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 two t-tests in a short paragraph.
Submit your completed Excel worksheet and Word document. To submit your second document, click “Add Another File” under your first file upload:
Link to the video above:
M2.3 Excel and Comparison of Means Rubric
M2.3 Excel and Comparison of Means Rubric
This criterion is linked to a Learning Outcome
t-test 1
20 pts
Exemplary
Your t-test has been run accurately for the comparison of means between 2017 and 2018 data. Output statistics are clearly identified.
10 pts
Progressing
Your t-test has been run for the comparison of means between 2017 and 2018 data. Output statistics are identified. There are some errors.
0 pts
Not addressed or Not submitted
Your t-test and output statistics comparing the means between 2017 and 2018 are inaccurate or missing.
This criterion is linked to a Learning Outcome
t-test 2
20 pts
Exemplary
Your t-test has been run accurately for the comparison of means between 2018 and 2019 data. Output statistics are clearly identified.
10 pts
Progressing
Your t-test has been run for the comparison of means between 2018 and 2019 data. Output statistics are identified. There are some errors.
0 pts
Not addressed or Not submitted
Your t-test and output statistics comparing the means between 2018 and 2019 are inaccurate or missing.
This criterion is linked to a Learning Outcome
Explanation of Statistics
50 pts
Exemplary
You accurately describe results in common terminology and detail what each t-test tells the reader about the data sets. Details important differences in the two comparisons.
42 pts
Proficient
You describe results in common terminology and detail what each t-test tells the reader about the data set. Minor details need further development.
34 pts
Progressing
You provide a general description of what each t-test tells the reader about the data set. Some terminology is too technical. Your description needs more information for the reader to understand the data sets.
26 pts
Incomplete
Your description of what each t-test tells the reader is unclear, too technical, and/or inaccurate.
0 pts
Not addressed or Not submitted
Does not address this criterion in the assignment. Did not submit assignment. Does not adhere to academic honesty policy.
This criterion is linked to a Learning Outcome
Due Date
10 pts
Exemplary
Submitted by due date.
8 pts
Proficient
Submitted one day after due date.
6 pts
Progressing
Submitted two days after due date.
4 pts
Incomplete
Submitted three days after due date.
0 pts
Not addressed or Not submitted
Submitted four or more days after due date.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code HAPPY