Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #140: Prove the Birthday Paradox!

Highlighted
9 - 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
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

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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