Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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: