[ 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 8:58 a.m.

Hallo all,

Does anybody know of a simple formula for calculating the probabilities of dancing x times on a y point board?

I've started working on this in Excel but my math is not advanced enough to finish the job neatly.

I have problems with row 7 and 8 using my method (raising the denominator of the derived unit fraction (1/x) by an increasing power for each roll).

Here is a screenshot of the work in progress..

1 Backgammon - Chances of Coming in per roll- WJ 2.xlsx

And here is a link to my Excel file so far..

http://we.tl/ioEC11DjsW

Don't know if there are any Excel wizards on here who can see what I am trying to do and modify / improve?

Cheers!

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.