von

n

a

c

h

p(X≤t)

p(X=t)

μ->

C2: 0
D2: 1
E2: 2
B3: 0
C3: 1
B4: 1
C4: 0
D4: 0
E4: 0
B5: 2
C5: 0
E5: 0
F2: 3
G2: 4
H2: 5
B6: 3
B7: 4
B8: 5
C6: 0
C7: 0
C8: 0
D6: 0
D7: 0
D8: 0
E6: 0
E8: 0
F3: 0
F5: 0
F6: 0
F7: 0
G3: 0
G4: 0
G5: 0
p = 0.5 (slider from 0.1 to 0.9, step 0.1)
D5: p
D3: 1 - p
E7: p
E3: 1 - p
F8: p
F4: 1 - p
G8: p
G6: 1 - p
G7: 0
H8: 1
H3: 0
H4: 0
H5: 0
H6: 0
H7: 0
start = 1 (slider from 0 to 5, step 1)
C10: C2
D10: D2
E10: E2
F10: F2
G10: G2
H10: H2
C11 = If(start ≟ 0, 1, 0)
D11 = If(start ≟ 1, 1, 0)
E11 = If(start ≟ 2, 1, 0)
F11 = If(start ≟ 3, 1, 0)
G11 = If(start ≟ 4, 1, 0)
H11 = If(start ≟ 5, 1, 0)
C12 = Sum(($C11:$H11 * $C$3:$H$3))
D12 = Sum(($C11:$H11 * $C$4:$H$4))
E12 = Sum(($C11:$H11 * $C$5:$H$5))
F12 = Sum(($C11:$H11 * $C$6:$H$6))
G12 = Sum(($C11:$H11 * $C$7:$H$7))
H12 = Sum(($C11:$H11 * $C$8:$H$8))
B11: 0
B12: 1
B13: 2
B14: 3
B15: 4
B16: 5
B17: 6
B18: 7
B19: 8
B20: 9
B21: 10
C13 = Sum(($C12:$H12 * $C$3:$H$3))
D13 = Sum(($C12:$H12 * $C$4:$H$4))
E13 = Sum(($C12:$H12 * $C$5:$H$5))
F13 = Sum(($C12:$H12 * $C$6:$H$6))
G13 = Sum(($C12:$H12 * $C$7:$H$7))
H13 = Sum(($C12:$H12 * $C$8:$H$8))
C14 = Sum(($C13:$H13 * $C$3:$H$3))
D14 = Sum(($C13:$H13 * $C$4:$H$4))
E14 = Sum(($C13:$H13 * $C$5:$H$5))
F14 = Sum(($C13:$H13 * $C$6:$H$6))
G14 = Sum(($C13:$H13 * $C$7:$H$7))
H14 = Sum(($C13:$H13 * $C$8:$H$8))
C15 = Sum(($C14:$H14 * $C$3:$H$3))
D15 = Sum(($C14:$H14 * $C$4:$H$4))
E15 = Sum(($C14:$H14 * $C$5:$H$5))
F15 = Sum(($C14:$H14 * $C$6:$H$6))
G15 = Sum(($C14:$H14 * $C$7:$H$7))
H15 = Sum(($C14:$H14 * $C$8:$H$8))
C16 = Sum(($C15:$H15 * $C$3:$H$3))
D16 = Sum(($C15:$H15 * $C$4:$H$4))
E16 = Sum(($C15:$H15 * $C$5:$H$5))
F16 = Sum(($C15:$H15 * $C$6:$H$6))
G16 = Sum(($C15:$H15 * $C$7:$H$7))
H16 = Sum(($C15:$H15 * $C$8:$H$8))
C17 = Sum(($C16:$H16 * $C$3:$H$3))
D17 = Sum(($C16:$H16 * $C$4:$H$4))
E17 = Sum(($C16:$H16 * $C$5:$H$5))
F17 = Sum(($C16:$H16 * $C$6:$H$6))
G17 = Sum(($C16:$H16 * $C$7:$H$7))
H17 = Sum(($C16:$H16 * $C$8:$H$8))
C18 = Sum(($C17:$H17 * $C$3:$H$3))
D18 = Sum(($C17:$H17 * $C$4:$H$4))
E18 = Sum(($C17:$H17 * $C$5:$H$5))
F18 = Sum(($C17:$H17 * $C$6:$H$6))
G18 = Sum(($C17:$H17 * $C$7:$H$7))
H18 = Sum(($C17:$H17 * $C$8:$H$8))
C19 = Sum(($C18:$H18 * $C$3:$H$3))
D19 = Sum(($C18:$H18 * $C$4:$H$4))
E19 = Sum(($C18:$H18 * $C$5:$H$5))
F19 = Sum(($C18:$H18 * $C$6:$H$6))
G19 = Sum(($C18:$H18 * $C$7:$H$7))
H19 = Sum(($C18:$H18 * $C$8:$H$8))
C20 = Sum(($C19:$H19 * $C$3:$H$3))
D20 = Sum(($C19:$H19 * $C$4:$H$4))
E20 = Sum(($C19:$H19 * $C$5:$H$5))
F20 = Sum(($C19:$H19 * $C$6:$H$6))
G20 = Sum(($C19:$H19 * $C$7:$H$7))
H20 = Sum(($C19:$H19 * $C$8:$H$8))
C21 = Sum(($C20:$H20 * $C$3:$H$3))
D21 = Sum(($C20:$H20 * $C$4:$H$4))
E21 = Sum(($C20:$H20 * $C$5:$H$5))
F21 = Sum(($C20:$H20 * $C$6:$H$6))
G21 = Sum(($C20:$H20 * $C$7:$H$7))
H21 = Sum(($C20:$H20 * $C$8:$H$8))
I12: C12 + H12
B10(t) = t
I13: C13 + H13
I14: C14 + H14
I15: C15 + H15
I16: C16 + H16
I17: C17 + H17
I18: C18 + H18
I19: C19 + H19
I20: C20 + H20
I21: C21 + H21
J13: I13 - I12
J14: I14 - I13
J15: I15 - I14
J16: I16 - I15
J17: I17 - I16
J18: I18 - I17
J19: I19 - I18
J20: I20 - I19
J21: I21 - I20
J12: I12
a = BarChart(B12:B21, J12:J21)
B22: 11
B23: 12
B24: 13
B25: 14
B26: 15
B27: 16
B28: 17
B29: 18
B30: 19
B31: 20
C22 = Sum(($C21:$H21 * $C$3:$H$3))
D22 = Sum(($C21:$H21 * $C$4:$H$4))
E22 = Sum(($C21:$H21 * $C$5:$H$5))
F22 = Sum(($C21:$H21 * $C$6:$H$6))
G22 = Sum(($C21:$H21 * $C$7:$H$7))
H22 = Sum(($C21:$H21 * $C$8:$H$8))
I22: C22 + H22
J22: I22 - I21
C23 = Sum(($C22:$H22 * $C$3:$H$3))
D23 = Sum(($C22:$H22 * $C$4:$H$4))
E23 = Sum(($C22:$H22 * $C$5:$H$5))
F23 = Sum(($C22:$H22 * $C$6:$H$6))
G23 = Sum(($C22:$H22 * $C$7:$H$7))
H23 = Sum(($C22:$H22 * $C$8:$H$8))
I23: C23 + H23
J23: I23 - I22
C24 = Sum(($C23:$H23 * $C$3:$H$3))
D24 = Sum(($C23:$H23 * $C$4:$H$4))
E24 = Sum(($C23:$H23 * $C$5:$H$5))
F24 = Sum(($C23:$H23 * $C$6:$H$6))
G24 = Sum(($C23:$H23 * $C$7:$H$7))
H24 = Sum(($C23:$H23 * $C$8:$H$8))
I24: C24 + H24
J24: I24 - I23
C25 = Sum(($C24:$H24 * $C$3:$H$3))
D25 = Sum(($C24:$H24 * $C$4:$H$4))
E25 = Sum(($C24:$H24 * $C$5:$H$5))
F25 = Sum(($C24:$H24 * $C$6:$H$6))
G25 = Sum(($C24:$H24 * $C$7:$H$7))
H25 = Sum(($C24:$H24 * $C$8:$H$8))
I25: C25 + H25
J25: I25 - I24
C26 = Sum(($C25:$H25 * $C$3:$H$3))
D26 = Sum(($C25:$H25 * $C$4:$H$4))
E26 = Sum(($C25:$H25 * $C$5:$H$5))
F26 = Sum(($C25:$H25 * $C$6:$H$6))
G26 = Sum(($C25:$H25 * $C$7:$H$7))
H26 = Sum(($C25:$H25 * $C$8:$H$8))
I26: C26 + H26
J26: I26 - I25
C27 = Sum(($C26:$H26 * $C$3:$H$3))
D27 = Sum(($C26:$H26 * $C$4:$H$4))
E27 = Sum(($C26:$H26 * $C$5:$H$5))
F27 = Sum(($C26:$H26 * $C$6:$H$6))
G27 = Sum(($C26:$H26 * $C$7:$H$7))
H27 = Sum(($C26:$H26 * $C$8:$H$8))
I27: C27 + H27
J27: I27 - I26
C28 = Sum(($C27:$H27 * $C$3:$H$3))
D28 = Sum(($C27:$H27 * $C$4:$H$4))
E28 = Sum(($C27:$H27 * $C$5:$H$5))
F28 = Sum(($C27:$H27 * $C$6:$H$6))
G28 = Sum(($C27:$H27 * $C$7:$H$7))
H28 = Sum(($C27:$H27 * $C$8:$H$8))
I28: C28 + H28
J28: I28 - I27
C29 = Sum(($C28:$H28 * $C$3:$H$3))
D29 = Sum(($C28:$H28 * $C$4:$H$4))
E29 = Sum(($C28:$H28 * $C$5:$H$5))
F29 = Sum(($C28:$H28 * $C$6:$H$6))
G29 = Sum(($C28:$H28 * $C$7:$H$7))
H29 = Sum(($C28:$H28 * $C$8:$H$8))
I29: C29 + H29
J29: I29 - I28
C30 = Sum(($C29:$H29 * $C$3:$H$3))
D30 = Sum(($C29:$H29 * $C$4:$H$4))
E30 = Sum(($C29:$H29 * $C$5:$H$5))
F30 = Sum(($C29:$H29 * $C$6:$H$6))
G30 = Sum(($C29:$H29 * $C$7:$H$7))
H30 = Sum(($C29:$H29 * $C$8:$H$8))
I30: C30 + H30
J30: I30 - I29
C31 = Sum(($C30:$H30 * $C$3:$H$3))
D31 = Sum(($C30:$H30 * $C$4:$H$4))
E31 = Sum(($C30:$H30 * $C$5:$H$5))
F31 = Sum(($C30:$H30 * $C$6:$H$6))
G31 = Sum(($C30:$H30 * $C$7:$H$7))
H31 = Sum(($C30:$H30 * $C$8:$H$8))
I31: C31 + H31
J31: I31 - I30
J9 = Sum((B12:B31 * J12:J31))
K31: (H31 * 5)