Use excel to run a t-test for two samples assuming equal


T-test for two samples

A drug company is measuring levels of oxygenation in patients after receiving a test medication. As the researcher, you are interested in whether Group I, which received the medication, has the same oxygenation levels as Group II, which did not.

1) Group 1: 2, 3, 3, 4, 4, 7, 8, 9

2) Group 2: 1, 2, 2, 3, 4, 4, 5, 5, 6, 8

Use Excel to run a t-test for two samples, assuming equal variances, with an alpha value of 0.05. Run the t-test and note:

1) Are you doing a one-tailed test or a two-tailed test (Excel will give you both)?

2) What is the probability that Group I is different from Group 2, using the p value? Is it significant against the benchmark of p < .05?

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

Solution Preview :

Prepared by a verified Expert
Dissertation: Use excel to run a t-test for two samples assuming equal
Reference No:- TGS02228027

Now Priced at $25 (50% Discount)

Recommended (95%)

Rated (4.7/5)