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?

In case you have a similar question and need it answered for you just say write my essay. At Academized we have all the most qualified academic writers and tutors, for all your assignments, essays, cases studies, discussion posts, project proposals, research papers, discussion posts, nursing assignments, admission essays, blog articles, and other forms of academic work.

If you don’t want a custom paper, just buy a pre-written essay from Buy College Essay.