[Steps Shown] In the following data set, please do the following: g) Construct an x-y scatterplot of the data. Discuss what it tells you h) State your null hypothesis
Question: In the following data set, please do the following:
g) Construct an x-y scatterplot of the data. Discuss what it tells you
h) State your null hypothesis about the groups.
- Describe whether the data is cross-sectional or time-series in nature.
j) 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?
k) Obtain the best fit linear regression line.
l) What confidence level for your correlation coefficient (1- p-value )?
DATA SET 2: This data set compares the actual length of hospital stay in days (ALOS) to the estimated length of hospital stay in days (ELOS). Is there a connection? Note: patient number is not to be used in calculations.
| patient | ELOS | ALOS |
| 1 | 10.5 | 10 |
| 2 | 4.5 | 2 |
| 3 | 7.5 | 4 |
| 4 | 12 | 11 |
| 5 | 7.5 | 11 |
| 6 | 9 | 11 |
| 7 | 6 | 6.5 |
| 8 | 5 | 5 |
| 9 | 6 | 8 |
| 10 | 12 | 16 |
| 11 | 7 | 6.5 |
| 12 | 4.5 | 6 |
| 13 | 3.5 | 3.5 |
| 14 | 6 | 10 |
| 15 | 7.5 | 7 |
| 16 | 3 | 5.5 |
Deliverable: Word Document 