[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

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..

2015-11-18 13_58_47-Microsoft Excel - 1 Backgammon - Chances of Coming in per roll- WJ 4.xlsx.png

and the corrected version of the xlsx:

http://we.tl/PCmRknmTYa

Still looking for those unit fractions..

Messages In This Thread

 

Post Response
Your Name:
Your E-Mail Address:
Subject:
Message:

If necessary, enter your password below:

Password:
 

 

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

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