How do I get started with this?

Hypothesis Testing for Differences Between Groups

Perform hypothesis testing on the differences between two groups and create an Excel 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 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).

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. Performappropriate 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.

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

• 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.

clinic1	clinic2
140	169
126	151
30	175
130	115
193	167
137	153
168	115
99	194
135	216
184	149
118	122
109	155
93	185
136	150
102	141
24	135
99	87
104	42
134	96
80	111
30	234
44	158
156	130
150	148
150	105
95	108
51	114
205	113
30	131
92	114
173	61
49	175
137	135
27	198
150	149
182	92
184	127
152	170
147	167
76	175
161	263
143	138
127	161
166	166
139	88
92	152
145	136
176	121
186	174
48	90
92	179
69	171
168	85
27	134
157	123
83	134
139	64
132	153
85	106
97	192
125	115
145	150
129	151
157	166
183	105
50	159
185	160
149	52
157	167
185	103
127	178
110	174
66	80
141	128
125	172
111	154
150	170
162	152
94	95
138	111
162	144
134	136
83	191
157	193
134	144
137	168
76	94
115	126
51	208
150	136
25	201
137	171
148	148
207	214
189	111
104	204
197	189
131	159
151	188
202	174