Start Free Trial

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!

Szymon_Czuszek
8 - Asteroid

Attached my solution below. I found a solution which didn't require a macro, and was much more efficient.

 

Workflow:

Spoiler
WeeklyChallenge140.PNG
lwolfie
11 - Bolide

Ripped the band-aid off and figured out the macro.  I also started down a more complicated path of using birth day and year vs integer.

alexnajm
18 - Pollux
18 - Pollux

Done!

Erin
11 - Bolide

That was fun!

Spoiler
workflow: 
workflowworkflow
Macro:
batch macrobatch macro
Results:
resultsresults
RebekaMazuchova
8 - Asteroid

Nice iterative macro. A bit more challenging one.

JBevan89
8 - Asteroid
Spoiler
JB_C140.png

 I found it good how the graph always changes slightly because of the random function (bit novice of me), but it's good how ultimately to probability is around 50% for 23 people

Pilsner
13 - Pulsar

Fun mathematical challenge, here's my solution:

Spoiler
Here's my answer for when it passed the specified milestones:

50%: 23
75%: 32
90%: 41
140.png