Share
Explore BrainMass

Using Excel to Find Correlations

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

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?

Attachments

Solution Preview

Please see the attached files; the first is written explanation and the next actual Excel workings. Good luck!

Question 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
Solution: Using Excel, we get the following (see sheet 4)
Column 1 Column 2
Column 1 1
Column 2 0.962911 1
So, we can see that the correlation coefficient is R=0.962911. It appears that there is a strong positive relationship between X and Y.

Question 2: A drug company is ...

Solution Summary

The expert uses Excel to find the correlation between variables.

$2.19