I'm creating a game system based on Fudge/Fate dice rolls and I need to validate if a have a fair distribution. Since I don't have much contact with this for a long time (since high school), I figure that someone here could help me with this.
For those that don't know, a Fudge/Fate dice is a common 6 sided die (d6) where you have 2 faces for each value (-1, 0, +1): (-1, -1, 0, 0, +1, +1). In a Fudge/Fate die, -1 represents a failure and +1 represents a success and for each roll, a failure cancels a success (and 0 means neither).
Then, consider that we always sum the results.
For example, rolling 4 dices (dices are always rolled simultaneously):
- 4dF {0, 0, +1, -1} = 0
- 4dF {0, 0, +1, +1} = +2
- 4dF {0, 0, -1, -1} = -2
I'm trying to discover the probability of getting, for example, at least +20 in 100 rolls. I want to make a spreadsheet where I have the Y-axis as the number of rolls and X-axis as the desired number.
My goal with that is to establish the player range of success based on the number of rolls he has available.
For nonnegative integers $n$, and integers $x$, let $p(n,x)$ be the probability of getting a score of at least $x$ in $n$ rolls.
Then we have the recursion $$ p(n,x)= \begin{cases} 0&\;\;\;\text{if}\;\,n < x\\[4pt] 1&\;\;\;\text{if}\;\,-n \ge x\\[4pt] \frac{1}{3}p(n-1,x-1)+ +\frac{1}{3}p(n-1,x)+ +\frac{1}{3}p(n-1,x+1) &\;\;\;\text{otherwise}\\ \end{cases} $$ Implementing the recursion in Maple, we get $$p(100,20)=\frac{a}{b}\approx .008336093451$$ where $a,b$ are given by \begin{align*} a&=159119821311220187192678211640711891517682398\\[4pt] b&=19088056323407827075424486287615602692670648963 \end{align*}
Note:$\;$The above recursion yields an exact answer as a fraction, but as you can see, the numerators and denominators can be huge, so this method would require a programming language implementation, e.g., Python, or a CAS, such as Maple, rather than, say, Excel.
Here's an implementation in Maple . . .
Here is a table showing the approximate values of $p(100,x)$, for $1\le x \le 100$ . . .