Health Care Research Methods, analysis and Utilization

Health Care Research Methods, analysis and Utilization

Need back by Noveber 2, 2014 at 3pm Central time 

Must be on two different excel sheet  Part 1 & 2

Part 1

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

Part 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?

Looking for a similar assignment? Get help from our qualified experts!

Order Now

Related Posts