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

 

 

 

[griffinwelsh]

My solution was an iterative macro nested inside a batch macro. 

[Bobbyt23]

That was a tough one but really interesting.

[Carolyn]

Solved!

Spoiler

I generated the numbers 2-50 for the different groups of people. I then generated all the individual people within each groups (e.g. if it was the group of 3, I generated 3 rows, numbered 1-3)

From there, I Appended it with the 1k generated rows for the trial to make 1,274,000 rows of data. 

Instead of generating the birthday dates, I used the numbers 1-365 (and pretended that Leap Years weren't a thing)