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.
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.
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.
For this assessment, perform hypothesis testing on the differences between two groups in the Assessment 2 Data Set [XLSX] Download 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.