Challenge #24: ARIMA Time Series

[dsmdavid]

As mentioned by others, slightly different values -- I changed "units" to double to be able to use the decimals in the average. Took me ages to realize I needed the TS forecast to visualize output...

[PhilipMannering]

Predictive can vex and perplex me... but here it is. Solution attached.

Révélation

[jasperlch]

Solution attached.

[datavizbro]

Done! In my solution I first checked how the ARIMA performed against the ETS model by scoring each against the last 6 weeks of withheld data and then used the scored ARIMA model's settings instead of AUTO settings as these may be different to the scored model. This is perhaps the reason why some get slightly different results as the settings aren't set manually.

[dsmdavid]

Slightly different results, partly because I changed Units to "double" to take the monthly/yearly average 

[michalsicak]

my solution is very similar to some of the others. time series forecast made easy! 

Révélation

[aclaxton]

That was a fun one! I might have to bring this tool combo into my daily work...

Révélation

[MaxGiegerich]

Also got some minor differences to the answer due to field type rounding I believe. Thanks!

[JosephSerpis]

Challenge Completed

[KOBoyle]

Solution attached. The was my first exposure to the predictive tools, and it was very useful. I first did this problem a couple of months ago, and it worked fine. However, I was reviewing it recently on a new laptop, and the ARIMA tool was throwing an error. I see that a couple of others have encountered the error too.

https://community.alteryx.com/t5/Advanced-Analytics/ARIMA-Error-in-searchDir-dbDir-lang-expecting-a-...

I hope Alteryx can figure out how to reproduce and resolve it.

-Ken