Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #24: ARIMA Time Series

Parul_Kapoor
8 - Asteroid

Solution attached.

sgrabish1
8 - Asteroid

Thanks for practice exercise!

Illya
8 - Asteroid

My solution. A new tool for me, looking forward to using it for work at some point

JamesCameron
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1574351862161.png
SueDonim
8 - Asteroid

Very slight differences in the results, but not sure why and I think they are immaterial.

 

Spoiler
Process:
- Calculate monthly average and annual average
- Join monthly average and annual average with original data
- Replace null monthly averages with annual average
- Replace null weekly averages with monthly average
- ARIMA tool with weekly target frequency on weekly units
- TS Predict weekly to 6 periods


MySolution.PNG
jfone
8 - Asteroid

Same forecast but different confidence intervals as others have noted.

prozanini
8 - Asteroid
 
mbogusz
9 - Comet
Spoiler
challenge_24_solution_mbogusz.png
danicahui
8 - Asteroid
Spoiler
Challenge 24 2019-12-10.jpg
joshuaburkhow
ACE Emeritus
ACE Emeritus

Very good intro to Time Series

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks