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.PreparationDownload 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).InstructionsAn 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).PreparationDownload 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).InstructionsAn 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 CriteriaThe 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 RequirementsYour assessment should meet the following requirements:Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.Length: 2–3 pagesResources: Not required.APA format: Cite your sources using current APA format.Font and font size: Times Roman, 10 point.Hypothesis Testing for Differences Between Groups Scoring Guide

CRITERIA

NONPERFORMANCE

BASIC

PROFICIENT

DISTINGUISHED

Generate a hypothesis

about the difference

between two groups in a

dataset.

Does not

generate a

hypothesis

about the

difference

between two

groups in a

dataset.

Generates a

hypothesis

about the

difference

between two

groups in a

dataset but it is

incomplete or

contains errors.

Generates a

hypothesis

about the

difference

between two

groups in a

dataset.

Generates a

hypothesis

about the

difference

between two

groups in a

dataset.

Ensures the

hypothesis is

clearly stated,

is complete,

and includes

null and

alternative

hypotheses.

Identify the appropriate

statistical test in a

dataset.

Does not

identify the

appropriate

statistical test

of the

difference

between two

groups in a

dataset.

Incorrectly

identifies the

appropriate

statistical test

of the

difference

between two

groups in a

dataset.

Identifies the

appropriate

statistical test

of the

difference

between two

groups in a

dataset.

Identifies the

appropriate

statistical test

of the

difference

between two

groups in a

dataset and

provides

rationale and

justification for

the selected

test.

Perform appropriate

statistical test of the

difference between two

groups in a dataset.

Does not

perform

appropriate

statistical test

of the

difference

between two

Incorrectly

performs

appropriate

statistical test

of the

difference

between two

Performs

appropriate

statistical test

of the

difference

between two

Performs

appropriate

statistical test

of the

difference

between two

groups in a

NONPERFORMANCE

BASIC

PROFICIENT

DISTINGUISHED

groups in a

dataset.

groups in a

dataset.

groups in a

dataset.

dataset and

provides

concise, logical

reasoning for

the selected

test that

includes an

explanation of

the test

statistic and

significance

level.

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.

Does not

interpret

results of a

data analysis

or state

whether to

accept or

reject the null

hypothesis

based on the

p-value and an

alpha of .05

Interprets

results of a data

analysis but the

interpretation is

incomplete,

inaccurate, or

logically

inconsistent

with the data.

Interprets

results of a

data analysis

and states

whether to

accept or

reject the null

hypothesis

based on the

p-value and an

alpha of .05.

Interprets

results of a

data analysis

and states

whether to

accept or reject

the null

hypothesis

based on the pvalue and an

alpha of .05

that is

complete.

Provides a

perceptive and

clearly

articulated

conclusion and

includes an

assessment of

caveats and

limitations.

Write a narrative

summary of the results

Does not write

a narrative

Writes a

narrative

Writes a

narrative

Writes a

scholarly

CRITERIA

CRITERIA

NONPERFORMANCE

BASIC

PROFICIENT

DISTINGUISHED

that includes practical,

administration-related

implications of the

hypothesis test.

summary of

the results that

includes

practical,

administrationrelated

implications of

the hypothesis

test.

summary of the

results but it

contains

incorrect or

insufficient

administrationrelated

implications of

the hypothesis

test.

summary of

the results that

includes

practical,

administrationrelated

implications of

the hypothesis

test.

narrative

summary of

the results that

includes

practical,

administrationrelated

implications of

the hypothesis

test. Draws

valid, fully

justified

conclusions

well supported

by scholarly

literature.

Write clearly and

concisely, using correct

grammar, mechanics,

and APA formatting.

Does not write

clearly and

concisely,

using correct

grammar,

mechanics, and

APA

formatting.

Writes in a

manner that is

unclear and

disorganized,

includes errors

in grammar and

mechanics that

inhibit effective

communication,

or contains

incorrect or

improperly

formatted

source citations

and references.

Writes clearly

and concisely,

using correct

grammar,

mechanics,

and APA

formatting.

Writes clearly

and concisely.

Ensures

grammar,

mechanics, and

APA formatting

are error free.

Purchase answer to see full

attachment

#### Why Choose Us

- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

#### How it Works

- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "
**PAPER DETAILS**" section. - Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “
**CREATE ACCOUNT & SIGN IN**” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page. - From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.