=(SUMPRODUCT(D4:D9-AVERAGE(D4:D12),D7:D12-AVERAGE(D4:D12))/D13/VAR.P(D4:D12))ĭ4:D9 represents the sales series without the last three values due to lag 3 and D7:D12 is the series without the first three values. Similarly, to get the autocorrelation for lag=2 use the following formula. In this way, you will get the autocorrelation of the sales series with their one lagged version. P(D4:D12) → determines variance based on the entire range.OFFSET($D$4:$D$12,0,0,8) → extracts a range with a height of 8 rows from the reference cell $D$4.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |