NATURAL SCIENCE GURU ONLY

Question 2

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?

While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines.

Use Excel to do a correlation between the following variables:

1. X – 2,5,5,6,6,7,8,9
2. Y – 1,2,2,3,4,4,5,5

Please provide an excel and word document explaining the work with references.