Challenge #73: Plinko Probabilities

[ALT_2358]

Not the nicest looking solution but it seems to work, as far as I can tell. 

I'm sure there are much simpler ways of doing it, maybe using a macro. 

[mithily]

Spoiler

usage of generate rows

[hlombemalandela]

Challenge complete here is my solution

[Tgigs]

My solution attached.

I took a slightly different approach. In my app, I have the user input 3 values. (1) the width of the plinko board, (2) the height of the plinko board, and (3) the slot that they drop the puck in. Based on these inputs, the probability distribution of plinko board is returned.

Had to employ some R code to simulate the probabilities because I used a nested for loop to iterate through each row and column of the plinko board individually and handle the various cases. Unfortunately could not figure out a way to do this with native Alteryx tools but Im sure there is.

[BS_THE_ANALYST]

Two outputs, the possible combinations in tabular form or the specific probability:

Spoiler

 

[H_a_n_g_C_h_e_n__x3]

Its a very fun challenge

[asultanov]

Most of the time taken up by wrapping my head around the problem.

Spoiler

[Pilsner]

Very nice challenge, I tried to take the formulaic approach. I came across several sticking points and had to think of different approaches to usual so it was a great challenge for slightly out-of-the-box thinking.

My solution:

Spoiler

Main workflow:

Macro:

 

[aatalai]

More of an estimate, but did it via Monte carlo

[Jon-Knepper]

Heavy inspiration from others to help me understand this one.

Spoiler