Assessment 2 Hypothesis Testing for Differences Between Groups Instructions: Perform hypothesis testing on the differences between two groups and create an Excel document. Write a 2-3 page analysis of the results

Assessment 2
Hypothesis Testing for Differences Between Groups

Instructions: 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 that includes a recommendation and a plan of action, 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.

Preparation

Read the Assessment 2 Lecture [PDF] Download Assessment 2 Lecture [PDF].

Them, download the Assessment 2 Data Set [XLSX].

The data set contains the following variables:

• Rural Clinic1 (total number of visits per month for clinic 1).
• Rural Clinic2 (total number of visits per month for clinic 2).

The Healthcare System administrators need to decide on whether to implement the new pre-natal program in rural clinics. You have been asked whether there is a significant difference in the total number of visits per month between clinic 1 and clinic 2. Based on your data analysis, which of the clinics is performing better? Recommend an improvement plan for the underperforming clinic.

Instructions:

For this assessment, perform hypothesis testing on the differences between two groups in the Assessment 2 Data Set [XLSX]. 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 the Copy From Excel to Another Office Program resource 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 the two groups in a data set.
   • State null hypothesis and alternative hypothesis as an explanation and math equation.
2. Identify the appropriate statistical test of the difference between the two groups in a data set.
   • Provide your statistical rationale.
3. Perform an appropriate statistical test of the difference between two groups in a data set.
4. Interpret the statistical 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 recommendation to determine what decision and plan of action for the scenario that is based upon your data analysis and supported with scholarly literature.
6. Write clearly and concisely, using correct grammar, mechanics, and APA formatting.

Additional Requirements:

Your assessment should also meet the following requirements:

• Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.
• Length: 2–3 pages.
• Resources: Include 1–2 scholarly, peer-reviewed sources.
• APA format: Cite the sources using current APA guidelines. See the Find Scholarly & Peer-Reviewed Sources and Evidence and APA Campus resources for guidance.
• Font and font size: Times Roman, 12 point.

Competencies Measured:

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and scoring guide criteria:

• Competency 1: Plan for data collection, measurement, and analysis.
  • Generate a hypothesis about the difference between two groups in a data set.
  • Identify the appropriate statistical test of the difference between two groups in a data set.
• Competency 2: Analyze data using computer-based programming and software.
  • Perform an appropriate statistical test of the difference between two groups in a data set.
• Competency 3: Interpret results of data analysis for value based healthcare decisions, policy, or practice.
  • Interpret the statistical 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 recommendation for a decision and plan of action based on a data analysis and supported with scholarly literature.
• 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.