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
8 - Asteroid

Solution attached

Spoiler
23-12-2019 10-00-38.png23-12-2019 10-01-15.png
Highlighted
8 - Asteroid

Fun! I set the trail number as 10,000 and only use 19s to complete running.

 

Spoiler
Annotation 2020-01-02 181231.png
Annotation 2020-01-02 184001.png

 

 

Highlighted
8 - Asteroid

I spent more time than I'd like trying to create a macro. Ended up doing the brute force solution.

Highlighted
8 - Asteroid

 

Spoiler
Challenge 140 2020-01-30.jpg

 

Highlighted
8 - Asteroid

My Effort

Spoiler
Two iterative macros, one looping over the population,the other running 1000 trials

JamesCameron_1-1580592901400.png

JamesCameron_3-1580592930115.png

JamesCameron_4-1580592946427.png
JamesCameron_5-1580592990734.png
8 - Asteroid
Spoiler
2020-01-29 21_23_29-Greenshot.png
Highlighted
8 - Asteroid

I spent a lot of time building a macro that ultimately didn't work, then I decided that I could do this within a workflow if I used a join on iteration number and  sample size rather than appending records then filtering. I got it running in 2 minutes for 10,000 iterations (to get a nice smooth curve)

Spoiler
sonyakasenkramer_0-1582226711845.png

 

Highlighted
8 - Asteroid

Nice one

 

Spoiler
image.pngimage.pngimage.png
Highlighted
Alteryx Partner

Although the challenge says something along the lines of "create a population of 100,000 people, then do the tests sampling from that population" (and I tried that with batch+iterative, taking a looong time) I went with not really "sampling" the population but just creating a new people for each row...should provide similar answers.

Spoiler
dsmdavid_0-1584913265114.png

 

Highlighted
Alteryx
Alteryx

My Solution: