Explore BrainMass
Share

# Using Excel to Find Correlations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

\$2.19

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