Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #140: Prove the Birthday Paradox!

Highlighted
Comet

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

WC140 Results.png

Spoiler
WorkflowWorkflowMacroMacro
Highlighted
Alteryx
Alteryx

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)

 

 

Highlighted
Director, Customer Enablement
Director, Customer Enablement

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?

 

Highlighted
Alteryx Certified Partner

not sure I did this correctly

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
 
Highlighted
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

 

Quasar
Quasar

My solution

Highlighted
Alteryx Certified Partner

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

 

 

Highlighted
Alteryx Partner

 

 

Screen Shot 2018-11-15 at 10.39.29.png

 

 

 

Spoiler


Screen Shot 2018-11-15 at 10.46.47.png

 

Highlighted
Alteryx Partner

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