(Step-by-Step) In the following data set, please do the following: m) Construct an x-y scatterplot of the data. Discuss what it tells you n) State your
Question: In the following data set, please do the following:
m) Construct an x-y scatterplot of the data. Discuss what it tells you
n) State your null hypothesis about the groups.
o) Describe whether the data is cross-sectional or time-series in nature.
p) Obtain the correlation coefficient. Use correlator.xls to determine your t-statistic, and the critical t-score. Does your t-stat exceed your t-critical?
q) Obtain the best fit linear regression line.
r) What confidence level for your correlation coefficient (1- p-value )?
DATA SET 3: Is there a correlation between yields on ETF’s in 2009 vs. 2010?
| 2009 | 2010 |
| 11 | 15 |
| 19 | 27 |
| 11 | 18 |
| 14 | 17 |
| 5 | 13 |
| 20 | 16 |
| 12 | 21 |
| -3 | 12 |
| 4 | 8 |
| 13 | 11 |
| 12 | 23 |
| 13 | 13 |
| 3 | 15 |
| 9 | 19 |
| 7 | 10 |
| 6 | 19 |
Deliverable: Word Document 