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

https://brainmass.com/statistics/correlation/using-excel-find-correlations-520232

#### 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.