
BGonline.org Forums
Dancing x times on a y point board? Excel help?
Posted By: sebalotek
Date: Wednesday, 18 November 2015, at 2:11 p.m.
In Response To: Dancing x times on a y point board? Excel help? (scotty)
Thanks Scotty.. I'm guessing that the output of your formula will be probability expressed as a small decimal number?
I am looking for a way / formula to have the results expressed as (the closest possible, doesn't have to be exact) unit fraction i.e. 1 in 729 or 1/729
n.b. just checked and it is a decimal value still. However, it allowed me to verify against my previous results. It revealed that I had misinterpreted Casper's equally correct instructions i.e. "previous column raised to the power 2, 3, 4."
Here is an updated screenshot with corrected results..
and the corrected version of the xlsx:
Still looking for those unit fractions..

BGonline.org Forums is maintained by Stick with WebBBS 5.12.