From the following observations of annual EPS for a company,what is the first-order autocorrelation?
| Time | EPS |
| 1 | 3.06 |
| 2 | 3.27 |
| 3 | 4.44 |
| 4 | 4.07 |
| 5 | 5.26 |
| 6 | 5.59 |
Note that using the CORREL() spreadsheet function will notproduce the correct result. Though for a large sample it'll bereally close, for a small sample such as this one the differencecan be significant. This is because for the autocorrelation you usethe variance of the full sample in the denominator, as well as usethe full sample to find the mean for use in covariance. Incontrast, the CORREL function will treat the two subsets of thetime series as separate data, and calculate separate mean andstandard deviation for each.
Answer should be 0.4 Please show who to get it in excel
