Topic: Doing game probabilities in Excel
Started by: rycanada
Started on: 6/20/2008
Board: lumpley games
On 6/20/2008 at 9:40pm, rycanada wrote:
Doing game probabilities in Excel
Hey Vincent, you mentioned a few times that you had an excel sheet you used to check on probabilities for IAWA.
How did you go about constructing that? I know how to calculate a simple probability but the multiple-but-variable round structure of IAWA, possibility of one-vs-many, and the way previous rounds change subsequent rounds defeats me.
On 6/23/2008 at 5:03pm, lumpley wrote:
Re: Doing game probabilities in Excel
Oh I didn't even.
All I checked was whether, like, d8d8d6 or d12d8 was more likely to win any given single comparison. I didn't check for whole fights at all.
I didn't even use statistics-math. I did it by writing macros to cycle through all the possible rolls for each and spit out the number of times each result came up.
-Vincent
On 6/23/2008 at 5:58pm, rycanada wrote:
RE: Re: Doing game probabilities in Excel
Alright, that means I have a challenge ahead of me.