I’m no quant wiz but recall enough from my studies from L1 and L2.
Essentially I have a monthly time series illustrating the change in subscribers (i work in the telecom industry).
When graphing the series I notice that there is some sort of pattern (seasonality or something); I want to know if there is any serial correlation/autocorrelation.
I figure if i lag the data for 12 months against itself (i think thats k=12) there will be some evidence to buttress my hypothesis.
Any idea how to do this on excel or do i need a stat program? Is my logic even correct…is autocorrelation with the lags right for this task?
Essentially I have a monthly time series illustrating the change in subscribers (i work in the telecom industry).
When graphing the series I notice that there is some sort of pattern (seasonality or something); I want to know if there is any serial correlation/autocorrelation.
I figure if i lag the data for 12 months against itself (i think thats k=12) there will be some evidence to buttress my hypothesis.
Any idea how to do this on excel or do i need a stat program? Is my logic even correct…is autocorrelation with the lags right for this task?