community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #140: Prove the Birthday Paradox!

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

This week we will run an anecdotal workflow to prove the Birthday Paradox! The Birthday paradox simply refers to the phenomenon that if you assembled 23 people into one room, the chances of two people having the same birthday are 50-50. We could 'math' this out, but why not just assembles 100s of thousands of people in the seconds to prove it?

 

In this challenge, your goal is to build a table that increment group sizes from 2 people all the way to 50 people. In each of those group sizes, run 1000 random trials and see what percent of groups had at least one set of people match. Why 1000? Theoretically, the more trials you run, the more likely you are to get a refined percent (e.g. flipping a coin four times may not a perfect 50-50 chance where it would be much closer after 1000 flips).

 

Due to the nature of this challenge, you will need to generate your own data! I have provided a sample output of mine, but since we are randomly assigning birthdays, you may find small differences in our answers. At what group size did it exceed 75% chance? 90% chance?

 

probchart.pngLooking to try the new interactive chart tool too?

Asteroid

Screen Shot 2018-11-05 at 10.34.14 AM.png

 

 

Workflow:

Spoiler
Screen Shot 2018-11-05 at 10.35.04 AM.pngworkflow
Screen Shot 2018-11-05 at 10.23.36 AM.pngmacro
Spoiler
I most certainly over complicated it, but nothing simpler was coming to mind.
Capture.PNG 
Asteroid

Started off with an iterative macro but just ended up with a brute force method.

Spoiler
challenge140.JPG

challenge140 scatter.JPG

Quasar

Challenge #140 graph.PNG

 

Spoiler
I went down the macro route here. Also first time using the interactive chart - great tool!
Challenge #140 final.PNGincorporating the macro, aggregating the data and creating the vizChallenge #140 macro.PNGbatch macro, one per trial
Bolide

Solution attached.

Meteor

Happy birthday to someone on here!

 

Scatterplot.PNG

Asteroid
Spoiler
Workflow.png     Macro.png

 Studied this one as part of my degree :D

Asteroid

Cheers! That was a lot of fun!

Spoiler
I ended up having to nest a iterative macro within a batch macro to make this happen. Here is a screen shot of my iterative macro followed by my batch macro.
Challenge_140.pngIterative MacroChallenge_140_1.pngBatch Macro
Meteoroid