Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Differencing time series outside TS ARIMA

ritikat
6 - Meteoroid

Hi Experts,

 

Can we do differencing on a time series outside TS ARIMA tool? I want to difference the series outside and then check the ACF and PCF in the TS PLOT. 

 

Regards,

Ritika

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @ritikat ,

 

Not sure if that answers the question, but can't you imitate differencing with a multi-row formula tool  (first, second grade if needed and so on) and then checking if the time-series is stationary or not based on that?

 

It's a really interesting question. If I may ask, what's the reason that makes you want to do it outside the ARIMA tool?

 

Regards,

 

Angelos

ritikat
6 - Meteoroid

Hi @AngelosPachis ,

 

Thank you for your prompt answer

 

The idea is to analyze the following in the time series - 

 

1) If the time series is stationary or not - I did a Dicky Fuller's test using python. After checking the ADF coefficient and p - value , I figured that series is not stationary. 

 

2) Make the time series stationary and then again do the ADF test to check if it's stationary. To do this step, I would like to do the differencing outside. 

 

Regards,

Ritika

AngelosPachis
16 - Nebula

Oh I see, to be honest I am not sure how the ARIMA tool enforces/checks stationarity and whether it uses the Dickey Fuller test. I know it is somehow done automatically but can't quite tell.

 

I think the multi-row formula tool will help you do the differencing outside of the tool and then feed the data into Python. Hope this will work, it's a really cool idea

Labels