Challenge #140: Prove the Birthday Paradox!

[ed_hayter]

Spoiler

 brain was a bit fried trying to compute the probability - making the dataset was straightforward

[tristank]

Fun! First time nesting an iterative macro within a batch macro. Took less time than I expected to run.

Spoiler

[gawa]

Done

Spoiler

[geoff_zath]

Spoiler

 

 

[BMorgan1390]

This was a fun one.  Had to really think through the process before you started.

[Rob-Silk]

Solution attached below - really enjoyed this challenge:

Spoiler

I went done the route of a batch macro with each run of the macro increasing the number of people and completing 1,000 trials. I also tried to make everything as dynamic as possible and avoid hardcoded variables, so there's a Text Input which sets the starting/minimum number of people, the ending/maximum number of people and the number of trials at each iteration.

Main workflow:



Macro:


Scatter plot output:

[Bren_Spill]

Tough challenge!

Spoiler