Hypothesis Testing for Differences between Groups
Assessment 2 Hypothesis Testing for Differences Between Groups
Overview
Perform hypothesis testing on the differences between two groups and create an Excel document. Write a 2–3-page analysis of the results in a Word document and insert the results into this document.
Note: You are strongly encouraged to complete the assessments in this course in the order they are presented.
SHOW MORE
Resources
Statistical Significance
• Frey, B. B. (Ed.). (2018). Significance. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.
• Gallo, A. (2016, February 16). A refresher on statistical significance. Harvard Business Review Digital Articles, 2–9.
• Simpson, S. H. (2015). Creating a data analysis plan: What to consider when choosing statistics for a study. Canadian Journal of Hospital Pharmacy, 68(4), 311–317. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4552232/
Hypothesis Testing
• Frey, B. B. (Ed.). (2018). Hypothesis testing. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.
• Hypothesis Tester. • Real Statistics Using Excel. (n.d.). Null and alternative hypothesis. Retrieved from
http://www.real-statistics.com/hypothesis-testing/null-hypothesis/ • Elliott. E. C. (n.d.). Understanding statistical hypothesis testing. Retrieved from
https://www.stattutorials.com/understanding-hypothesis-testing.html • Gonzalez-Chica, D. A., Bastos, J. L., Duquia, R. P., Bonamigo, R. R., & Martínez-Mesa, J.
(2015). Test of association: Which one is the most appropriate for my study? Anais brasileiros de dermatología, 90(4), 523–528. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4560542/
• Quantitative Skills Center: Interpreting Statistical Data.
Details Attempt 1 Available Attempt 2
Attempt 3
Tutorials Support Log Out Samantha Billig 3
p Value
• Frey, B. B. (Ed.). (2018). p value. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.
• Elliott, E. C. (n.d.). Interpreting statistical p-values. Retrieved from https://www.stattutorials.com/p-value-interpreting.html
Interpreting Results
• Evaluation of Analytic Results. • Interpreting Results of Inferential Techniques. • Matching Statistical Tests to Hypotheses.
Significance Tests
• Orr-Depner, R. (n.d.). Learning about 2-sample t-tests with Guitar Hero | Transcript. Retrieved from https://www.sophia.org/tutorials/learning-about-2-sample-t-tests-with-guitar-hero
• Scheer, A. (n.d.). The basics of significance tests | Transcript. Retrieved from https://www.sophia.org/tutorials/sec-91-the-basics-of-significance-tests
• StatisticsLectures.com. (n.d.). Statistical vs practical significance. Retrieved from http://www.statisticslectures.com/topics/statisticalpractical/
• Tutorials for Statistical Data Analysis. (n.d.). Two sample (independent group) t-test using Mcrosoft Excel. Retrieved from https://www.stattutorials.com/EXCEL/EXCEL_TTEST1.html
Textbook
• Kros, J. F., & Rosenthal, D. A. (2016). Statistics for health care management and administration: Working with Excel (3rd. ed.). San Francisco, CA: Jossey-Bass. Available in the courseroom via the VitalSource Bookshelf link.
SHOW LESS
Asssessment Instructions
Preparation
Download the Assessment 2 Dataset [XLSX].
The dataset contains the following variables:
• clinic1 (total number of visits per month for clinic 1). • clinic2 (total number of visits per month for clinic 2).
Instructions
An investor needs to make a decision on whether to acquire one of two medical clinics based on their productivity, as measured by the total number of visits per month. You have been asked whether there is a significance difference in the total number of visits per month between clinic 1 and clinic 2.
For this assessment, perform hypothesis testing on the differences between two groups in the Assessment 2 Dataset. Create an appropriately labeled Excel document with your results. Also
write an analysis of the results in a Word document. Insert the test results into this document (copied from the output file and pasted into a Word document). Refer to Copy From Excel to Another Office Program for instructions.
Submit both the Word document and the Excel file that shows the results.
Grading Criteria
The numbered assessment instructions outlined below correspond to the grading criteria in the Hypothesis Testing for Differences Between Groups Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed.
1. Generate a hypothesis about the difference between two groups in a dataset. ◦ State null hypothesis and alternative hypothesis as an explanation and math
equation.
2. Identify the appropriate statistical test in a dataset. ◦ Provide your statistical rationale.
3. Perform appropriate statistical test of the difference between two groups in a dataset.
4. Interpret the results of a data analysis and state whether to accept or reject the null hypothesis based on the p-value and an alpha of .05.
◦ Interpret p-value and statistical significance.
5. Write a narrative summary of the results that includes practical, administration-related implications of the hypothesis test.
Additional Requirements
Your assessment should meet the following requirements:
• Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.
• Length: 2–3 pages • Resources: Not required. • APA format: Cite your sources using current APA format. • Font and font size: Times Roman, 10 point.
How to use the scoring guide
Hypothesis Testing for Differences Between Groups
Scoring Guide
Use the scoring guide to enhance your learning.
VIEW SCORING GUIDE
SUBMIT ASSESSMENT
This button will take you to the next available assessment attempt tab, where you will be able to submit your assessment.