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 & 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.
0 comments