p->

a->

zu viel

Gewinn

μ^->

σ^->

B1: 2 / 3
A3: 1
B3: 2
C3: 3
D3: 4
E3: 5
F3: 6
G3: 7
H3: 8
I3: 9
B2: -2
A4 = RandomBinomial(1, $B$1)
B4 = RandomBinomial(1, $B$1)
C4 = RandomBinomial(1, $B$1)
D4 = RandomBinomial(1, $B$1)
E4 = RandomBinomial(1, $B$1)
F4 = RandomBinomial(1, $B$1)
G4 = RandomBinomial(1, $B$1)
H4 = RandomBinomial(1, $B$1)
I4 = RandomBinomial(1, $B$1)
A5 = RandomBinomial(1, $B$1)
B5 = RandomBinomial(1, $B$1)
C5 = RandomBinomial(1, $B$1)
D5 = RandomBinomial(1, $B$1)
E5 = RandomBinomial(1, $B$1)
F5 = RandomBinomial(1, $B$1)
G5 = RandomBinomial(1, $B$1)
H5 = RandomBinomial(1, $B$1)
I5 = RandomBinomial(1, $B$1)
J4 = Sum(A4:I4)
J5 = Sum(A5:I5)
J6 = Sum(A6:I6)
J7 = Sum(A7:I7)
K4 = If(J4 > 6, J4 - 6, 0)
K5 = If(J5 > 6, J5 - 6, 0)
L4: 9 + (K4 * B$2)
L5: 9 + (K5 * B$2)
A6 = RandomBinomial(1, $B$1)
B6 = RandomBinomial(1, $B$1)
C6 = RandomBinomial(1, $B$1)
D6 = RandomBinomial(1, $B$1)
E6 = RandomBinomial(1, $B$1)
F6 = RandomBinomial(1, $B$1)
G6 = RandomBinomial(1, $B$1)
H6 = RandomBinomial(1, $B$1)
I6 = RandomBinomial(1, $B$1)
K6 = If(J6 > 6, J6 - 6, 0)
L6: 9 + (K6 * B$2)
A7 = RandomBinomial(1, $B$1)
B7 = RandomBinomial(1, $B$1)
C7 = RandomBinomial(1, $B$1)
D7 = RandomBinomial(1, $B$1)
E7 = RandomBinomial(1, $B$1)
F7 = RandomBinomial(1, $B$1)
G7 = RandomBinomial(1, $B$1)
H7 = RandomBinomial(1, $B$1)
I7 = RandomBinomial(1, $B$1)
K7 = If(J7 > 6, J7 - 6, 0)
L7: 9 + (K7 * B$2)
A8 = RandomBinomial(1, $B$1)
B8 = RandomBinomial(1, $B$1)
C8 = RandomBinomial(1, $B$1)
D8 = RandomBinomial(1, $B$1)
E8 = RandomBinomial(1, $B$1)
F8 = RandomBinomial(1, $B$1)
G8 = RandomBinomial(1, $B$1)
H8 = RandomBinomial(1, $B$1)
I8 = RandomBinomial(1, $B$1)
J8 = Sum(A8:I8)
K8 = If(J8 > 6, J8 - 6, 0)
L8: 9 + (K8 * B$2)
A9 = RandomBinomial(1, $B$1)
B9 = RandomBinomial(1, $B$1)
C9 = RandomBinomial(1, $B$1)
D9 = RandomBinomial(1, $B$1)
E9 = RandomBinomial(1, $B$1)
F9 = RandomBinomial(1, $B$1)
G9 = RandomBinomial(1, $B$1)
H9 = RandomBinomial(1, $B$1)
I9 = RandomBinomial(1, $B$1)
J9 = Sum(A9:I9)
K9 = If(J9 > 6, J9 - 6, 0)
L9: 9 + (K9 * B$2)
A10 = RandomBinomial(1, $B$1)
B10 = RandomBinomial(1, $B$1)
C10 = RandomBinomial(1, $B$1)
D10 = RandomBinomial(1, $B$1)
E10 = RandomBinomial(1, $B$1)
F10 = RandomBinomial(1, $B$1)
G10 = RandomBinomial(1, $B$1)
H10 = RandomBinomial(1, $B$1)
I10 = RandomBinomial(1, $B$1)
J10 = Sum(A10:I10)
K10 = If(J10 > 6, J10 - 6, 0)
L10: 9 + (K10 * B$2)
A11 = RandomBinomial(1, $B$1)
B11 = RandomBinomial(1, $B$1)
C11 = RandomBinomial(1, $B$1)
D11 = RandomBinomial(1, $B$1)
E11 = RandomBinomial(1, $B$1)
F11 = RandomBinomial(1, $B$1)
G11 = RandomBinomial(1, $B$1)
H11 = RandomBinomial(1, $B$1)
I11 = RandomBinomial(1, $B$1)
J11 = Sum(A11:I11)
K11 = If(J11 > 6, J11 - 6, 0)
L11: 9 + (K11 * B$2)
A12 = RandomBinomial(1, $B$1)
B12 = RandomBinomial(1, $B$1)
C12 = RandomBinomial(1, $B$1)
D12 = RandomBinomial(1, $B$1)
E12 = RandomBinomial(1, $B$1)
F12 = RandomBinomial(1, $B$1)
G12 = RandomBinomial(1, $B$1)
H12 = RandomBinomial(1, $B$1)
I12 = RandomBinomial(1, $B$1)
J12 = Sum(A12:I12)
K12 = If(J12 > 6, J12 - 6, 0)
L12: 9 + (K12 * B$2)
A13 = RandomBinomial(1, $B$1)
B13 = RandomBinomial(1, $B$1)
C13 = RandomBinomial(1, $B$1)
D13 = RandomBinomial(1, $B$1)
E13 = RandomBinomial(1, $B$1)
F13 = RandomBinomial(1, $B$1)
G13 = RandomBinomial(1, $B$1)
H13 = RandomBinomial(1, $B$1)
I13 = RandomBinomial(1, $B$1)
J13 = Sum(A13:I13)
K13 = If(J13 > 6, J13 - 6, 0)
L13: 9 + (K13 * B$2)
L1 = mean(L4:L13)
L2 = stdevp(L4:L13)