[Solution Library] In the following data set, please do the following: Construct an x-y scatterplot of the data. Discuss what it tells you State your null
Question: In the following data set, please do the following:
- Construct an x-y scatterplot of the data. Discuss what it tells you
- State your null hypothesis about the groups.
- Describe whether the data is cross-sectional or time-series in nature.
- 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?
- Obtain the best fit linear regression line.
- What confidence level for your correlation coefficient (1- p-value )?
DATA 1: Are oil and silver prices connected, oil is in the first column, silver in the second column.
| 84.22 | 19.31 |
| 84.57 | 19.63 |
| 84.39 | 19.19 |
| 84.97 | 19.35 |
| 85.86 | 19.47 |
| 86.44 | 19.51 |
| 86.76 | 20.1 |
| 86.49 | 19.81 |
| 86.72 | 19.79 |
| 86.37 | 19.83 |
| 86.12 | 20.1 |
| 85.74 | 19.9 |
| 85.7 | 19.82 |
| 85.72 | 20.16 |
| 84.31 | 19.89 |
| 83.88 | 19.7 |
| 84.43 | 19.22 |
| 84.16 | 19.16 |
| 84.48 | 19.3 |
| 84.98 | 19.1 |
| 85.74 | 19.39 |
Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document 