Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

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?

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65