We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #140: Prove the Birthday Paradox!

Alteryx Alumni (Retired)

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?

Looking to try the new interactive chart tool too?

8 - Asteroid

Workflow:

Spoiler
workflow
macro
16 - Nebula
Spoiler
I most certainly over complicated it, but nothing simpler was coming to mind.

12 - Quasar

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

Spoiler

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
12 - Quasar

Spoiler
I went down the macro route here. Also first time using the interactive chart - great tool!
incorporating the macro, aggregating the data and creating the vizbatch macro, one per trial
12 - Quasar

Solution attached.

7 - Meteor

Happy birthday to someone on here!

8 - Asteroid
Spoiler

Studied this one as part of my degree 😄

11 - Bolide

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.
Iterative MacroBatch Macro
8 - Asteroid