Hi R experts,

 

I am trying to remove autocorrelation from Simple Moving Average time series. I 
know that this can be done by using seasonal ARIMA like,

 

            library(TTR)

            data <- rnorm(252)

            n=21

            sma_data=SMA(data,n)

            sma_data=sma_data[-1:-n]

            acf(sma_data,length(sma_data))

            arima=arima(sma_data,c(0,0,0),seasonal = list(order = c(0, 
0,n)));tsdiag(arima,100);arima$aic;

 

 

But is there any easy way that we can do in excel?? (Like differencing, dummy 
variable approach etc)

 

 

Thanks and Regards,

Ramesh Kallol | Amba Research

Ph +91 80 3980 8467 | Mob +91 9019720734

Bangalore * Colombo * London * New York * San José * Singapore * 
www.ambaresearch.com <http://www.ambaresearch.com/> 

 

This e-mail may contain confidential and/or privileged i...{{dropped:13}}

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to