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

Finding the Regression Line by using Excel

A sales manager for an advertising agency believes there is a relationship between the number of contacts and the amount of sales. To verify this belief, the following data were collected:

Salesperson # of Contacts Sales (000)

1 14 24

2 12 14

3 20 28

4 16 30

5 46 80

6 23 30

7 48 90

8 50 85

9 55 120

10 50 110

(a) Create a scatter diagram. Put the independent variable on the X (horizontal) axis and put the dependent variable on the Y (Vertical) axis. Be sure to label the axes.

(b) Determine the regression equation. State what the y intercept is and what the slope of the linear equation is. Does this appear to be a good model?

c) What is the value of the correlation coefficient, and what is the value of the coefficient of determination?

View Full Posting Details