Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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