Augenzahl

Wahrscheinlichkeit

gescheitert

gelungen

Spieldauer

Gewinn

Wahrscheinlichkeit

nach

<-erwarteter Gewinn

<-erwartete Spieldauer

Augenzahl

Wahrscheinlichkeit

gescheitert

gelungen

Spieldauer

Gewinn

Wahrscheinlichkeit

nach

<-erwarteter Gewinn

<-erwartete Spieldauer

B4 = 1 (slider from -5 to 5)
C4 = 2 (slider from -5 to 5)
D4 = 3 (slider from -5 to 5)
E4 = 4 (slider from -5 to 5)
F4 = 5 (slider from -5 to 5)
G4 = 6 (slider from -5 to 10)
H4 = 6 (slider from -5 to 10)
B1 = 1 (slider from -5 to 5)
C1 = 2 (slider from -5 to 5)
D1 = 3 (slider from -5 to 5)
E1 = 4 (slider from -5 to 5)
F1 = 5 (slider from -5 to 5)
G1 = 6 (slider from -5 to 10)
D2 = 0.166666666666667 (slider from -5 to 5)
E2 = 0.166666666666667 (slider from -5 to 5)
B2: 1 / 6
C2 = 0.166666666666667 (slider from -5 to 5)
F2 = 0.166666666666667 (slider from -5 to 5)
G2 = 0.166666666666667 (slider from -5 to 5)
B5 = 0 (slider from -5 to 5)
C5 = 1 (slider from -5 to 5)
D5 = 2 (slider from -5 to 5)
E5 = 3 (slider from -5 to 5)
F5 = 4 (slider from -5 to 5)
G5 = 5 (slider from -5 to 5)
H5 = 20 (slider from -5 to 20)
B6: B2
C6: ((B6 / B2 * (1 - B2)) * C2)
D6: ((C6 / C2 * (1 - C2)) * D2)
E6: ((D6 / D2 * (1 - D2)) * E2)
F6: ((E6 / E2 * (1 - E2)) * F2)
G6: ((F6 / F2 * (1 - F2)) * G2)
H6: (G6 / G2 * (1 - G2))
I5 = Sum((B5:H5 * B6:H6))
I6 = Sum((B4:H4 * B6:H6))
B11: 1
C11: 2
D11: 3
E11: 4
F11: 5
G11: 6
H11: 6
B8: 1
C8: 2
D8: 3
E8: 4
F8: 5
G8: 6
D9: 0.38
E9: 0.38
B9: 0.08
C9: 0.04
F9: 0.04
G9: 0.08
B12: 0
C12: 1
D12: 2
E12: 3
F12: 4
G12: 5
H12: 20
B13: B9
C13: ((B13 / B9 * (1 - B9)) * C9)
D13: ((C13 / C9 * (1 - C9)) * D9)
E13: ((D13 / D9 * (1 - D9)) * E9)
F13: ((E13 / E9 * (1 - E9)) * F9)
G13: ((F13 / F9 * (1 - F9)) * G9)
H13: (G13 / G9 * (1 - G9))
I12 = Sum((B12:H12 * B13:H13))
I13 = Sum((B11:H11 * B13:H13))