# 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 & 2Part 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,92) 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? writersThe post Health Care Research Methods, analysis and Utilization appeared first on Nursing Paper Desk.  “Is this question part of your assignment? We Can Help!”