Question: Calculate the correlation between the columns of data below (Y, X1, X2) . What do these correlations tell you about the relationships between (Y and
- Calculate the correlation between the columns of data below (Y, X1, X2) .
- What do these correlations tell you about the relationships between (Y and X1) (X1 and X2) and (Y and X2)?
- Using the Data Analysis Add-In in excel, run a regression to explain the variable Y with the other two variables.
- According to this regression, do either X1 or X2 or both help to explain the variable Y? Is that help significant/useful?
| # | Y | X1 | X2 |
| 1 | -0.4 | 1.5 | 20.7 |
| 2 | -1.7 | 3.8 | 20.3 |
| 3 | -0.3 | 3.3 | 18.5 |
| 4 | -0.7 | 5.0 | 17.7 |
| 5 | -2.1 | 6.6 | 16.6 |
| 6 | -0.2 | 7.2 | 16.7 |
| 7 | -0.6 | 8.3 | 14.9 |
| 8 | -5.4 | 8.7 | 13.7 |
| 9 | -7.1 | 10.2 | 13.5 |
| 10 | -9.9 | 11.7 | 12.2 |
| 11 | -6.9 | 12.2 | 11.0 |
| 12 | -6.5 | 12.1 | 9.6 |
| 13 | -11.2 | 13.7 | 8.8 |
| 14 | -5.0 | 14.8 | 7.0 |
| 15 | -5.0 | 16.8 | 7.5 |
| 16 | -1.9 | 17.6 | 5.1 |
| 17 | -10.7 | 17.1 | 5.8 |
| 18 | -0.4 | 19.8 | 4.5 |
| 19 | -16.9 | 20.3 | 3.8 |
| 20 | -15.4 | 21.0 | 2.5 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
