community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #140: Prove the Birthday Paradox!

Alteryx
Alteryx
Spoiler
Challenge_140_LG.PNG
Alteryx Certified Partner

29

Spoiler
Capture.PNGCaptureIT.PNG
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

 

 

Alteryx Partner

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

Alteryx 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

Asteroid

done...

Spoiler

Brute force approach!


Week140.PNG

Bolide

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

Result 140.JPG

 

 

Spoiler
Batch macro 140.JPGBatch macro

 

Iterative macro 140.JPGIterative macro

 

Workflow 140.JPGWorkflow

 

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