| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | TOTAL WINS | PROBABILITY of TOTAL WINS | Expected Answers in F2:F22 | ||||||
2 | Game | Win | Lose | 0 | 0.000031743% | ||||
3 | 1 | 50.00% | 50.00% | 1 | 0.001168001% | ||||
4 | 2 | 33.00% | 67.00% | 2 | 0.017925423% | ||||
5 | 3 | 65.50% | 34.50% | 3 | 0.153581089% | ||||
6 | 4 | 24.00% | 76.00% | 4 | 0.829138499% | ||||
7 | 5 | 37.50% | 62.50% | 5 | 3.019146758% | ||||
8 | 6 | 78.00% | 22.00% | 6 | 7.749354033% | ||||
9 | 7 | 63.00% | 37.00% | 7 | 14.452598626% | ||||
10 | 8 | 87.00% | 13.00% | 8 | 20.001544529% | ||||
11 | 9 | 13.10% | 86.90% | 9 | 20.831382665% | ||||
12 | 10 | 5.50% | 94.50% | 10 | 16.463260307% | ||||
13 | 11 | 92.00% | 8.00% | 11 | 9.904637380% | ||||
14 | 12 | 46.00% | 54.00% | 12 | 4.527927213% | ||||
15 | 13 | 83.00% | 17.00% | 13 | 1.561658222% | ||||
16 | 14 | 25.60% | 74.40% | 14 | 0.400900376% | ||||
17 | 15 | 51.00% | 49.00% | 15 | 0.074956886% | ||||
18 | 16 | 23.00% | 77.00% | 16 | 0.009870886% | ||||
19 | 17 | 13.70% | 86.30% | 17 | 0.000869037% | ||||
20 | 18 | 42.00% | 58.00% | 18 | 0.000046977% | ||||
21 | 19 | 2.30% | 97.70% | 19 | 0.000001337% | ||||
22 | 20 | 34.00% | 66.00% | 20 | 0.000000014% | ||||
23 | |||||||||
24 | Sum Check | 100% | |||||||
25 | |||||||||
26 | 1048576 | ||||||||
27 |