We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #140: Prove the Birthday Paradox!

ed_hayter
13 - Pulsar
Spoiler
ed_hayter_0-1686922862160.png

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

 

tristank
11 - Bolide

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

 

Spoiler
Screenshot 2023-08-16 134238.png

 

Screenshot 2023-08-16 134233.png

 

Screenshot 2023-08-16 133953.png

 

gawa
16 - Nebula
16 - Nebula

Done

Spoiler
image.png
geoff_zath
Alteryx
Alteryx
Spoiler
challenge_140_workflow.pngBirthday Paradox.png

BMorgan1390
8 - Asteroid

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

Rob-Silk
8 - Asteroid

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:
challenge_140a_RS_screencap.PNG


Macro:
challenge_140b_RS_screencap.PNG

Scatter plot output:
challenge_140c_RS_screencap.PNG
Bren_Spill2
12 - Quasar
12 - Quasar

Tough challenge!

Spoiler
#140 WF.JPG
#140 Macro.JPG

#140 Plot.JPG

griffinwelsh
12 - Quasar

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

Bobbyt23
13 - Pulsar

That was a tough one but really interesting.

Carolyn
12 - Quasar
12 - Quasar

Solved!

2024-09-09_16-49-04.png

 

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)

2024-09-09_16-50-07.png