Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #140: Prove the Birthday Paradox!

KMiller
8 - Asteroid

Solution attached

Spoiler
23-12-2019 10-00-38.png23-12-2019 10-01-15.png
tiffany_chen
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

 

 

rmassambane
10 - Fireball

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

danicahui
8 - Asteroid

 

Spoiler
Challenge 140 2020-01-30.jpg

 

JamesCameron
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
mbogusz
9 - Comet
Spoiler
2020-01-29 21_23_29-Greenshot.png
sonyakasenkramer
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

 

hanykowska
11 - Bolide

Nice one

 

Spoiler
image.pngimage.pngimage.png
dsmdavid
11 - Bolide

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

 

GaneshBo
Alteryx
Alteryx

My Solution: