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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #140: Prove the Birthday Paradox!

Asteroid

Here is my solution

challenge_140.jpg

Alteryx Partner
 
Asteroid

Solved. Bit lengthy and complex, but gets the job done.

 

 

My solution!

 

NOTE: Was way easier after I realized that "same birthday" meant people who celebrate their birthday on the same day, not people who were born the exact same day AND year. (In case you are wondering, the birthday paradox does not apply to scenario #2... though with a group size of 50, and an assumed average life expectancy of 75 years, turns out there is actually still a ~5% chance that two people were born on the exact same day!)

 

Spoiler
WeeklyChallenge140.JPGWeeklyChallenge140 Chart.JPGShowing 50% probability that birthdays will be shared at a group size of 23... probability increases to 75% around group size of 32, and 90% at 41 people!

Cheers! And since the data seems to indicate there's a pretty good chance it's someone's birthday today with a Community this size... happy birthday, whoever you are! :)

 

NJ

Alteryx Certified Partner

Again, loving the Interactive Chart tool. My solution below,

 

Spoiler
Challenge 140 - Capture W.PNGWorkflowChallenge 140 - Capture M.PNGMacroChallenge 140 - Capture.PNG
Alteryx Certified Partner

Here's my solution. I went for a batch macro. Really enjoyed this one!

 

Spoiler
Screenshot 2018-12-30 at 23.03.56.pngMain workflowScreenshot 2018-12-30 at 23.04.10.pngBatch macroScreenshot 2018-12-30 at 23.03.48.pngProbability scatter plot

 

 

Alteryx Partner

Avoided using macros in order to solve this challenge, got a pretty elegant workflow regardless.

 

Preview of workflow:

Spoiler
workflow.PNG

Preview of the results:

Spoiler
Capture.PNG
Alteryx Certified Partner

My solution

Asteroid
Spoiler
Challenge 140.PNG

Interesting practice

Asteroid

Pushed this one pretty hard... Ran 100,000 simulations each for both Leap Years and Non Leap Years, then weighted the Leap Years 97/400 and non Leap Years 303/400 (Based on a prior calculated 400 year Leap Year cycle calculation). Then ran the precision out to 10 decimals! Had fun with this one!! With 100K simulations the curve smooths out pretty nicely.

 

Birthday duplicate curve.png