Assessment 2 Instructions: Hypothesis Testing for Differences Between Groups Print 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.
Â
Introduction Note: You are strongly encouraged to complete the assessments in this course in the order they are presented.
Â
Hypothesis testing is a foundational statistical technique used to make decisions about a hypothesis.
Â
A hypothesis test compares two mutually exclusive statements (null hypothesis, alternative hypothesis) where only one is true.
Â
Hypothesis testing can determine statistical significance by examining the probability that a given result would occur under the null hypothesis. For this assessment, you will perform hypothesis testing on the differences between two groups.
Â
Overview and 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. Generate a hypothesis about the difference between two groups in a dataset. State null hypothesis and alternative hypothesis as an explanation and math equation.
Â
Identify the appropriate statistical test in a dataset.
Â
Provide your statistical rationale. Perform appropriate statistical test of the difference between two groups in a dataset. 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. 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. Competencies Measured By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment
Competency 1: Plan for data collection, measurement, and analysis. Generate a hypothesis about the difference between two groups in a dataset. Identify the appropriate statistical test in a dataset.
Â
Competency 2: Analyze data using computer-based programming and software. Performs appropriate statistical test of the difference between two groups in a dataset.
Â
Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice. 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. Write a narrative summary of the results that includes practical, administration-related implications of the hypothesis test.
Â
Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style.
Â
Write clearly and concisely, using correct grammar, mechanics, and APA formatting.