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

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 #140: Prove the Birthday Paradox!

TylerNa
10 - Fireball

I hit 75% at 36 and 90% at 42.

WC140 Results.png

Spoiler
WorkflowWorkflowMacroMacro
MichalM
Alteryx Alumni (Retired)

Went the iterative macro route first but when I saw it took almost a minute for 1k iterations per group I decided to take the direct route

 

2.1s for 1k iterations (75% at 33 and 90% at 40)

8.6s for 10k iterations (75% at 32 and 90% at 41)

 

 

JoeM
Alteryx Alumni (Retired)

Some of you may have been able to recognize this problem type, some of you may have not! For those who arrived on an answer - you've just made a Monte Carlo simulation!

 

Not so hard, right?

 

Laurap1228
11 - Bolide

not sure I did this correctly

CharlieS
17 - Castor
17 - Castor
 
Niklas
8 - Asteroid

Bit late to the (birthday) party. My solution-trying to avoid using a macro and accounting for gap years:

 

Chart_140.PNG

 

 

Spoiler
Screenshot_140.PNG

 

Ladarthure
14 - Magnetar
14 - Magnetar

My solution

Hakimipous
10 - Fireball

For someone being born a 29th February, thanks for this ;D

 

 

NikolajFrosig
7 - Meteor

 

 

Screen Shot 2018-11-15 at 10.39.29.png

 

 

 

Spoiler


Screen Shot 2018-11-15 at 10.46.47.png

 

wenjuanchen
8 - Asteroid

Solution attached. I built a batch macro upon an iterative macro. It is fun!

Scatter plot.PNG

 

Spoiler
140.PNG
Spoiler
Spoiler
Batch Macro.PNG
Spoiler
Iterative Macro.PNG