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
Alteryx
Alteryx
Spoiler
Challenge_140_LG.PNG
Highlighted
Alteryx Certified Partner

29

Spoiler
Capture.PNGCaptureIT.PNG
Highlighted
Alteryx
Alteryx

It's going to take me a week just to review all the different ways people attacked this challenge. Here's my solution:

Spoiler
2019-07-15_23-16-08.png2019-07-15_23-18-08.png

 

Alteryx Certified Partner

So I built this solution, but it takes forever to run, so I modified the workflow a bit by decreasing the number of trials by a factor ~333 (it says 1000 in the image but I adjusted it to 3)... But this is not enough for my model as it results in perfect separation... 1000 trials would be better, but this requires a full year's worth of simulations to run with this workflow.... I call it a night I guess as I cannot open my macro any longer after exporting it (I am not sure how, but something broke as a tool is now missing or disfigured/-membered)

 

Overall workflow:

Spoiler
140.png

Birthday macro:

Spoiler
140 birthday sampling.png

 

 

Highlighted
Alteryx Partner

I really loved using Alteryx to show this well known problem!

Highlighted
Alteryx Certified Partner

This was not a quick workflow to run

clipboard_image_0.png

Spoiler
I had an iterative macro within a batch macro.
Challenge 140 flow.png

The batch macro ran one group size per batch
challenge 140 batch.png
The iterative macro did the actual modelling
challenge 140 iterative.png

In total, the workflow took around half an hour to run

Highlighted
8 - Asteroid

done...

Spoiler

Brute force approach!


Week140.PNG

Highlighted
13 - Pulsar

My solution - Iterative macro inside of a batch macro (Alteryx Inception?)

Result 140.JPG

 

 

Spoiler
Batch macroBatch macro

 

Iterative macroIterative macro

 

WorkflowWorkflow

 

Highlighted
Alteryx Partner

Love me some birthday paradox. Like many others, I went the route of brute-forcing it.

 

Spoiler
Workflow Solution.PNG

Chart Solution.PNGTable Solution.PNG

Highlighted
8 - Asteroid