WähleAlternative

go

Pfad A

Pfad B

Pfad C

total

nach 100

<-chi²

Würfel

Quader

Lego4er

5aus15

10aus30

1/3

rot

weiß

1/3 rote

1/2 rote

2/3 rote

A: Würfel

B: Quader

C: Lego

min

rot

max

priori

M2: 0.100000000000000
T: {{0.166666666666667, 0.166666666666667, 0.166666666666667, 0.166666666666667, 0.166666666666667, 0.166666666666667},{0.11, 0.0800000000000001, 0.31, 0.31, 0.0800000000000001, 0.11},{0.0900000000000001, 0.0900000000000001, 0.42, 0.22, 0.0900000000000001, 0.0900000000000001}}
Alternativen: B1:D1
i = SelectedIndex(Alternativen)
M: {{0.166666666666667, 0.11, 0.0900000000000001},{0.166666666666667, 0.0800000000000001, 0.0900000000000001},{0.166666666666667, 0.31, 0.42},{0.166666666666667, 0.31, 0.22},{0.166666666666667, 0.0800000000000001, 0.0900000000000001},{0.166666666666667, 0.11, 0.0900000000000001}}
B9: 1 / 3
C9: 0.333333333333334
D9: 1 / 3
Indizien: {1,2,3,4,5,6}
A13: 4
A14: 3
A15: 3
A16: 6
A17: 2
A18: 1
A19: 2
A20: 1
A21: 4
A22: 2
A23: 6
A24: 3
A25: 5
A26: 6
A27: 5
A28: 4
A29: 5
A30: 2
A31: 5
A32: 1
A33: 5
A34: 1
A35: 6
A36: 5
A37: 1
A38: 6
A39: 1
A40: 3
A41: 2
A42: 5
A43: 3
A44: 6
A45: 5
A46: 4
A47: 3
A48: 6
A49: 6
A50: 4
A51: 1
A52: 3
A53: 1
A54: 4
A55: 4
A56: 4
A57: 3
A58: 4
A59: 3
A60: 6
A61: 4
A62: 2
A63: 1
A64: 1
A65: 4
A66: 4
A67: 4
A68: 3
A69: 5
A70: 3
A71: 4
A72: 4
A73: 4
A74: 1
A75: 1
A76: 3
A77: 5
A78: 1
A79: 1
A80: 1
A81: 2
A82: 1
A83: 5
A84: 1
A85: 1
A86: 6
A87: 1
A88: 3
A89: 2
A90: 5
A91: 5
A92: 2
A93: 3
A94: 5
A95: 3
A96: 1
A97: 1
A98: 2
A99: 4
A100: 2
A101: 3
A102: 5
A103: 4
A104: 6
A105: 4
A106: 1
A107: 1
A108: 2
A109: 2
Indizienfolge: {{1},{3},{4},{3},{4},{3},{3},{6},{2},{1},{2},{1},{4},{2},{6},{3},{5},{6},{5},{4},{5},{2},{5},{1},{5},{1},{6},{5},{1},{6},{1},{3},{2},{5},{3},{6},{5},{4},{3},{6},{6},{4},{1},{3},{1},{4},{4},{4},{3},{4},{3},{6},{4},{2},{1},{1},{4},{4},{4},{3},{5},{3},{4},{4},{4},{1},{1},{3},{5},{1},{1},{1},{2},{1},{5},{1},{1},{6},{1},{3},{2},{5},{5},{2},{3},{5},{3},{1},{1},{2},{4},{2},{3},{5},{4},{6},{4},{1},{1},{2},{2},{4},{1},{6},{4},{5},{5},{1},{5},{1}}
A110: 4
A111: 1
A11: 4
A12: 3
A10: 3
E10: (B9 * M(IndexOf[$A10, Indizien], 1))
F10: (C9 * M(IndexOf[$A10, Indizien], 2))
G10: (D9 * M(IndexOf[$A10, Indizien], 3))
H10 = Sum(E10:G10)
B10: E10 / $H10
C10: F10 / $H10
E11: (B10 * M(IndexOf[$A11, Indizien], 1))
F11: (C10 * M(IndexOf[$A11, Indizien], 2))
D10: G10 / $H10
G11: (D10 * M(IndexOf[$A11, Indizien], 3))
H11 = Sum(E11:G11)
B11: E11 / $H11
C11: F11 / $H11
D11: G11 / $H11
E12: (B11 * M(IndexOf[$A12, Indizien], 1))
F12: (C11 * M(IndexOf[$A12, Indizien], 2))
G12: (D11 * M(IndexOf[$A12, Indizien], 3))
H12 = Sum(E12:G12)
B12: E12 / $H12
C12: F12 / $H12
D12: G12 / $H12
E13: (B12 * M(IndexOf[$A13, Indizien], 1))
F13: (C12 * M(IndexOf[$A13, Indizien], 2))
G13: (D12 * M(IndexOf[$A13, Indizien], 3))
H13 = Sum(E13:G13)
B13: E13 / $H13
C13: F13 / $H13
D13: G13 / $H13
E14: (B13 * M(IndexOf[$A14, Indizien], 1))
F14: (C13 * M(IndexOf[$A14, Indizien], 2))
G14: (D13 * M(IndexOf[$A14, Indizien], 3))
H14 = Sum(E14:G14)
B14: E14 / $H14
C14: F14 / $H14
D14: G14 / $H14
E15: (B14 * M(IndexOf[$A15, Indizien], 1))
F15: (C14 * M(IndexOf[$A15, Indizien], 2))
G15: (D14 * M(IndexOf[$A15, Indizien], 3))
H15 = Sum(E15:G15)
B15: E15 / $H15
C15: F15 / $H15
D15: G15 / $H15
E16: (B15 * M(IndexOf[$A16, Indizien], 1))
F16: (C15 * M(IndexOf[$A16, Indizien], 2))
G16: (D15 * M(IndexOf[$A16, Indizien], 3))
H16 = Sum(E16:G16)
B16: E16 / $H16
C16: F16 / $H16
D16: G16 / $H16
E17: (B16 * M(IndexOf[$A17, Indizien], 1))
F17: (C16 * M(IndexOf[$A17, Indizien], 2))
G17: (D16 * M(IndexOf[$A17, Indizien], 3))
H17 = Sum(E17:G17)
B17: E17 / $H17
C17: F17 / $H17
D17: G17 / $H17
E18: (B17 * M(IndexOf[$A18, Indizien], 1))
F18: (C17 * M(IndexOf[$A18, Indizien], 2))
G18: (D17 * M(IndexOf[$A18, Indizien], 3))
H18 = Sum(E18:G18)
B18: E18 / $H18
C18: F18 / $H18
D18: G18 / $H18
E19: (B18 * M(IndexOf[$A19, Indizien], 1))
F19: (C18 * M(IndexOf[$A19, Indizien], 2))
G19: (D18 * M(IndexOf[$A19, Indizien], 3))
H19 = Sum(E19:G19)
B19: E19 / $H19
C19: F19 / $H19
D19: G19 / $H19
E20: (B19 * M(IndexOf[$A20, Indizien], 1))
F20: (C19 * M(IndexOf[$A20, Indizien], 2))
G20: (D19 * M(IndexOf[$A20, Indizien], 3))
H20 = Sum(E20:G20)
B20: E20 / $H20
C20: F20 / $H20
D20: G20 / $H20
E21: (B20 * M(IndexOf[$A21, Indizien], 1))
F21: (C20 * M(IndexOf[$A21, Indizien], 2))
G21: (D20 * M(IndexOf[$A21, Indizien], 3))
H21 = Sum(E21:G21)
B21: E21 / $H21
C21: F21 / $H21
D21: G21 / $H21
E22: (B21 * M(IndexOf[$A22, Indizien], 1))
F22: (C21 * M(IndexOf[$A22, Indizien], 2))
G22: (D21 * M(IndexOf[$A22, Indizien], 3))
H22 = Sum(E22:G22)
B22: E22 / $H22
C22: F22 / $H22
D22: G22 / $H22
E23: (B22 * M(IndexOf[$A23, Indizien], 1))
F23: (C22 * M(IndexOf[$A23, Indizien], 2))
G23: (D22 * M(IndexOf[$A23, Indizien], 3))
H23 = Sum(E23:G23)
B23: E23 / $H23
C23: F23 / $H23
D23: G23 / $H23
E24: (B23 * M(IndexOf[$A24, Indizien], 1))
F24: (C23 * M(IndexOf[$A24, Indizien], 2))
G24: (D23 * M(IndexOf[$A24, Indizien], 3))
H24 = Sum(E24:G24)
B24: E24 / $H24
C24: F24 / $H24
D24: G24 / $H24
E25: (B24 * M(IndexOf[$A25, Indizien], 1))
F25: (C24 * M(IndexOf[$A25, Indizien], 2))
G25: (D24 * M(IndexOf[$A25, Indizien], 3))
H25 = Sum(E25:G25)
B25: E25 / $H25
C25: F25 / $H25
D25: G25 / $H25
E26: (B25 * M(IndexOf[$A26, Indizien], 1))
F26: (C25 * M(IndexOf[$A26, Indizien], 2))
G26: (D25 * M(IndexOf[$A26, Indizien], 3))
H26 = Sum(E26:G26)
B26: E26 / $H26
C26: F26 / $H26
D26: G26 / $H26
E27: (B26 * M(IndexOf[$A27, Indizien], 1))
F27: (C26 * M(IndexOf[$A27, Indizien], 2))
G27: (D26 * M(IndexOf[$A27, Indizien], 3))
H27 = Sum(E27:G27)
B27: E27 / $H27
C27: F27 / $H27
D27: G27 / $H27
E28: (B27 * M(IndexOf[$A28, Indizien], 1))
F28: (C27 * M(IndexOf[$A28, Indizien], 2))
G28: (D27 * M(IndexOf[$A28, Indizien], 3))
H28 = Sum(E28:G28)
B28: E28 / $H28
C28: F28 / $H28
D28: G28 / $H28
E29: (B28 * M(IndexOf[$A29, Indizien], 1))
F29: (C28 * M(IndexOf[$A29, Indizien], 2))
G29: (D28 * M(IndexOf[$A29, Indizien], 3))
H29 = Sum(E29:G29)
B29: E29 / $H29
C29: F29 / $H29
D29: G29 / $H29
E30: (B29 * M(IndexOf[$A30, Indizien], 1))
F30: (C29 * M(IndexOf[$A30, Indizien], 2))
G30: (D29 * M(IndexOf[$A30, Indizien], 3))
H30 = Sum(E30:G30)
B30: E30 / $H30
C30: F30 / $H30
D30: G30 / $H30
E31: (B30 * M(IndexOf[$A31, Indizien], 1))
F31: (C30 * M(IndexOf[$A31, Indizien], 2))
G31: (D30 * M(IndexOf[$A31, Indizien], 3))
H31 = Sum(E31:G31)
B31: E31 / $H31
C31: F31 / $H31
D31: G31 / $H31
E32: (B31 * M(IndexOf[$A32, Indizien], 1))
F32: (C31 * M(IndexOf[$A32, Indizien], 2))
G32: (D31 * M(IndexOf[$A32, Indizien], 3))
H32 = Sum(E32:G32)
B32: E32 / $H32
C32: F32 / $H32
D32: G32 / $H32
E33: (B32 * M(IndexOf[$A33, Indizien], 1))
F33: (C32 * M(IndexOf[$A33, Indizien], 2))
G33: (D32 * M(IndexOf[$A33, Indizien], 3))
H33 = Sum(E33:G33)
B33: E33 / $H33
C33: F33 / $H33
D33: G33 / $H33
E34: (B33 * M(IndexOf[$A34, Indizien], 1))
F34: (C33 * M(IndexOf[$A34, Indizien], 2))
G34: (D33 * M(IndexOf[$A34, Indizien], 3))
H34 = Sum(E34:G34)
B34: E34 / $H34
C34: F34 / $H34
D34: G34 / $H34
E35: (B34 * M(IndexOf[$A35, Indizien], 1))
F35: (C34 * M(IndexOf[$A35, Indizien], 2))
G35: (D34 * M(IndexOf[$A35, Indizien], 3))
H35 = Sum(E35:G35)
B35: E35 / $H35
C35: F35 / $H35
D35: G35 / $H35
E36: (B35 * M(IndexOf[$A36, Indizien], 1))
F36: (C35 * M(IndexOf[$A36, Indizien], 2))
G36: (D35 * M(IndexOf[$A36, Indizien], 3))
H36 = Sum(E36:G36)
B36: E36 / $H36
C36: F36 / $H36
D36: G36 / $H36
E37: (B36 * M(IndexOf[$A37, Indizien], 1))
F37: (C36 * M(IndexOf[$A37, Indizien], 2))
G37: (D36 * M(IndexOf[$A37, Indizien], 3))
H37 = Sum(E37:G37)
B37: E37 / $H37
C37: F37 / $H37
D37: G37 / $H37
E38: (B37 * M(IndexOf[$A38, Indizien], 1))
F38: (C37 * M(IndexOf[$A38, Indizien], 2))
G38: (D37 * M(IndexOf[$A38, Indizien], 3))
H38 = Sum(E38:G38)
B38: E38 / $H38
C38: F38 / $H38
D38: G38 / $H38
E39: (B38 * M(IndexOf[$A39, Indizien], 1))
F39: (C38 * M(IndexOf[$A39, Indizien], 2))
G39: (D38 * M(IndexOf[$A39, Indizien], 3))
H39 = Sum(E39:G39)
B39: E39 / $H39
C39: F39 / $H39
D39: G39 / $H39
E40: (B39 * M(IndexOf[$A40, Indizien], 1))
F40: (C39 * M(IndexOf[$A40, Indizien], 2))
G40: (D39 * M(IndexOf[$A40, Indizien], 3))
H40 = Sum(E40:G40)
B40: E40 / $H40
C40: F40 / $H40
D40: G40 / $H40
E41: (B40 * M(IndexOf[$A41, Indizien], 1))
F41: (C40 * M(IndexOf[$A41, Indizien], 2))
G41: (D40 * M(IndexOf[$A41, Indizien], 3))
H41 = Sum(E41:G41)
B41: E41 / $H41
C41: F41 / $H41
D41: G41 / $H41
E42: (B41 * M(IndexOf[$A42, Indizien], 1))
F42: (C41 * M(IndexOf[$A42, Indizien], 2))
G42: (D41 * M(IndexOf[$A42, Indizien], 3))
H42 = Sum(E42:G42)
B42: E42 / $H42
C42: F42 / $H42
D42: G42 / $H42
E43: (B42 * M(IndexOf[$A43, Indizien], 1))
F43: (C42 * M(IndexOf[$A43, Indizien], 2))
G43: (D42 * M(IndexOf[$A43, Indizien], 3))
H43 = Sum(E43:G43)
B43: E43 / $H43
C43: F43 / $H43
D43: G43 / $H43
E44: (B43 * M(IndexOf[$A44, Indizien], 1))
F44: (C43 * M(IndexOf[$A44, Indizien], 2))
G44: (D43 * M(IndexOf[$A44, Indizien], 3))
H44 = Sum(E44:G44)
B44: E44 / $H44
C44: F44 / $H44
D44: G44 / $H44
E45: (B44 * M(IndexOf[$A45, Indizien], 1))
F45: (C44 * M(IndexOf[$A45, Indizien], 2))
G45: (D44 * M(IndexOf[$A45, Indizien], 3))
H45 = Sum(E45:G45)
B45: E45 / $H45
C45: F45 / $H45
D45: G45 / $H45
E46: (B45 * M(IndexOf[$A46, Indizien], 1))
F46: (C45 * M(IndexOf[$A46, Indizien], 2))
G46: (D45 * M(IndexOf[$A46, Indizien], 3))
H46 = Sum(E46:G46)
B46: E46 / $H46
C46: F46 / $H46
D46: G46 / $H46
E47: (B46 * M(IndexOf[$A47, Indizien], 1))
F47: (C46 * M(IndexOf[$A47, Indizien], 2))
G47: (D46 * M(IndexOf[$A47, Indizien], 3))
H47 = Sum(E47:G47)
B47: E47 / $H47
C47: F47 / $H47
D47: G47 / $H47
E48: (B47 * M(IndexOf[$A48, Indizien], 1))
F48: (C47 * M(IndexOf[$A48, Indizien], 2))
G48: (D47 * M(IndexOf[$A48, Indizien], 3))
H48 = Sum(E48:G48)
B48: E48 / $H48
C48: F48 / $H48
D48: G48 / $H48
E49: (B48 * M(IndexOf[$A49, Indizien], 1))
F49: (C48 * M(IndexOf[$A49, Indizien], 2))
G49: (D48 * M(IndexOf[$A49, Indizien], 3))
H49 = Sum(E49:G49)
B49: E49 / $H49
C49: F49 / $H49
D49: G49 / $H49
E50: (B49 * M(IndexOf[$A50, Indizien], 1))
F50: (C49 * M(IndexOf[$A50, Indizien], 2))
G50: (D49 * M(IndexOf[$A50, Indizien], 3))
H50 = Sum(E50:G50)
B50: E50 / $H50
C50: F50 / $H50
D50: G50 / $H50
E51: (B50 * M(IndexOf[$A51, Indizien], 1))
F51: (C50 * M(IndexOf[$A51, Indizien], 2))
G51: (D50 * M(IndexOf[$A51, Indizien], 3))
H51 = Sum(E51:G51)
B51: E51 / $H51
C51: F51 / $H51
D51: G51 / $H51
E52: (B51 * M(IndexOf[$A52, Indizien], 1))
F52: (C51 * M(IndexOf[$A52, Indizien], 2))
G52: (D51 * M(IndexOf[$A52, Indizien], 3))
H52 = Sum(E52:G52)
B52: E52 / $H52
C52: F52 / $H52
D52: G52 / $H52
E53: (B52 * M(IndexOf[$A53, Indizien], 1))
F53: (C52 * M(IndexOf[$A53, Indizien], 2))
G53: (D52 * M(IndexOf[$A53, Indizien], 3))
H53 = Sum(E53:G53)
B53: E53 / $H53
C53: F53 / $H53
D53: G53 / $H53
E54: (B53 * M(IndexOf[$A54, Indizien], 1))
F54: (C53 * M(IndexOf[$A54, Indizien], 2))
G54: (D53 * M(IndexOf[$A54, Indizien], 3))
H54 = Sum(E54:G54)
B54: E54 / $H54
C54: F54 / $H54
D54: G54 / $H54
E55: (B54 * M(IndexOf[$A55, Indizien], 1))
F55: (C54 * M(IndexOf[$A55, Indizien], 2))
G55: (D54 * M(IndexOf[$A55, Indizien], 3))
H55 = Sum(E55:G55)
B55: E55 / $H55
C55: F55 / $H55
D55: G55 / $H55
E56: (B55 * M(IndexOf[$A56, Indizien], 1))
F56: (C55 * M(IndexOf[$A56, Indizien], 2))
G56: (D55 * M(IndexOf[$A56, Indizien], 3))
H56 = Sum(E56:G56)
B56: E56 / $H56
C56: F56 / $H56
D56: G56 / $H56
E57: (B56 * M(IndexOf[$A57, Indizien], 1))
F57: (C56 * M(IndexOf[$A57, Indizien], 2))
G57: (D56 * M(IndexOf[$A57, Indizien], 3))
H57 = Sum(E57:G57)
B57: E57 / $H57
C57: F57 / $H57
D57: G57 / $H57
E58: (B57 * M(IndexOf[$A58, Indizien], 1))
F58: (C57 * M(IndexOf[$A58, Indizien], 2))
G58: (D57 * M(IndexOf[$A58, Indizien], 3))
H58 = Sum(E58:G58)
B58: E58 / $H58
C58: F58 / $H58
D58: G58 / $H58
E59: (B58 * M(IndexOf[$A59, Indizien], 1))
F59: (C58 * M(IndexOf[$A59, Indizien], 2))
G59: (D58 * M(IndexOf[$A59, Indizien], 3))
H59 = Sum(E59:G59)
B59: E59 / $H59
C59: F59 / $H59
D59: G59 / $H59
E60: (B59 * M(IndexOf[$A60, Indizien], 1))
F60: (C59 * M(IndexOf[$A60, Indizien], 2))
G60: (D59 * M(IndexOf[$A60, Indizien], 3))
H60 = Sum(E60:G60)
B60: E60 / $H60
C60: F60 / $H60
D60: G60 / $H60
E61: (B60 * M(IndexOf[$A61, Indizien], 1))
F61: (C60 * M(IndexOf[$A61, Indizien], 2))
G61: (D60 * M(IndexOf[$A61, Indizien], 3))
H61 = Sum(E61:G61)
B61: E61 / $H61
C61: F61 / $H61
D61: G61 / $H61
E62: (B61 * M(IndexOf[$A62, Indizien], 1))
F62: (C61 * M(IndexOf[$A62, Indizien], 2))
G62: (D61 * M(IndexOf[$A62, Indizien], 3))
H62 = Sum(E62:G62)
B62: E62 / $H62
C62: F62 / $H62
D62: G62 / $H62
E63: (B62 * M(IndexOf[$A63, Indizien], 1))
F63: (C62 * M(IndexOf[$A63, Indizien], 2))
G63: (D62 * M(IndexOf[$A63, Indizien], 3))
H63 = Sum(E63:G63)
B63: E63 / $H63
C63: F63 / $H63
D63: G63 / $H63
E64: (B63 * M(IndexOf[$A64, Indizien], 1))
F64: (C63 * M(IndexOf[$A64, Indizien], 2))
G64: (D63 * M(IndexOf[$A64, Indizien], 3))
H64 = Sum(E64:G64)
B64: E64 / $H64
C64: F64 / $H64
D64: G64 / $H64
E65: (B64 * M(IndexOf[$A65, Indizien], 1))
F65: (C64 * M(IndexOf[$A65, Indizien], 2))
G65: (D64 * M(IndexOf[$A65, Indizien], 3))
H65 = Sum(E65:G65)
B65: E65 / $H65
C65: F65 / $H65
D65: G65 / $H65
E66: (B65 * M(IndexOf[$A66, Indizien], 1))
F66: (C65 * M(IndexOf[$A66, Indizien], 2))
G66: (D65 * M(IndexOf[$A66, Indizien], 3))
H66 = Sum(E66:G66)
B66: E66 / $H66
C66: F66 / $H66
D66: G66 / $H66
E67: (B66 * M(IndexOf[$A67, Indizien], 1))
F67: (C66 * M(IndexOf[$A67, Indizien], 2))
G67: (D66 * M(IndexOf[$A67, Indizien], 3))
H67 = Sum(E67:G67)
B67: E67 / $H67
C67: F67 / $H67
D67: G67 / $H67
E68: (B67 * M(IndexOf[$A68, Indizien], 1))
F68: (C67 * M(IndexOf[$A68, Indizien], 2))
G68: (D67 * M(IndexOf[$A68, Indizien], 3))
H68 = Sum(E68:G68)
B68: E68 / $H68
C68: F68 / $H68
D68: G68 / $H68
E69: (B68 * M(IndexOf[$A69, Indizien], 1))
F69: (C68 * M(IndexOf[$A69, Indizien], 2))
G69: (D68 * M(IndexOf[$A69, Indizien], 3))
H69 = Sum(E69:G69)
B69: E69 / $H69
C69: F69 / $H69
D69: G69 / $H69
E70: (B69 * M(IndexOf[$A70, Indizien], 1))
F70: (C69 * M(IndexOf[$A70, Indizien], 2))
G70: (D69 * M(IndexOf[$A70, Indizien], 3))
H70 = Sum(E70:G70)
B70: E70 / $H70
C70: F70 / $H70
D70: G70 / $H70
E71: (B70 * M(IndexOf[$A71, Indizien], 1))
F71: (C70 * M(IndexOf[$A71, Indizien], 2))
G71: (D70 * M(IndexOf[$A71, Indizien], 3))
H71 = Sum(E71:G71)
B71: E71 / $H71
C71: F71 / $H71
D71: G71 / $H71
E72: (B71 * M(IndexOf[$A72, Indizien], 1))
F72: (C71 * M(IndexOf[$A72, Indizien], 2))
G72: (D71 * M(IndexOf[$A72, Indizien], 3))
H72 = Sum(E72:G72)
B72: E72 / $H72
C72: F72 / $H72
D72: G72 / $H72
E73: (B72 * M(IndexOf[$A73, Indizien], 1))
F73: (C72 * M(IndexOf[$A73, Indizien], 2))
G73: (D72 * M(IndexOf[$A73, Indizien], 3))
H73 = Sum(E73:G73)
B73: E73 / $H73
C73: F73 / $H73
D73: G73 / $H73
E74: (B73 * M(IndexOf[$A74, Indizien], 1))
F74: (C73 * M(IndexOf[$A74, Indizien], 2))
G74: (D73 * M(IndexOf[$A74, Indizien], 3))
H74 = Sum(E74:G74)
B74: E74 / $H74
C74: F74 / $H74
D74: G74 / $H74
E75: (B74 * M(IndexOf[$A75, Indizien], 1))
F75: (C74 * M(IndexOf[$A75, Indizien], 2))
G75: (D74 * M(IndexOf[$A75, Indizien], 3))
H75 = Sum(E75:G75)
B75: E75 / $H75
C75: F75 / $H75
D75: G75 / $H75
E76: (B75 * M(IndexOf[$A76, Indizien], 1))
F76: (C75 * M(IndexOf[$A76, Indizien], 2))
G76: (D75 * M(IndexOf[$A76, Indizien], 3))
H76 = Sum(E76:G76)
B76: E76 / $H76
C76: F76 / $H76
D76: G76 / $H76
E77: (B76 * M(IndexOf[$A77, Indizien], 1))
F77: (C76 * M(IndexOf[$A77, Indizien], 2))
G77: (D76 * M(IndexOf[$A77, Indizien], 3))
H77 = Sum(E77:G77)
B77: E77 / $H77
C77: F77 / $H77
D77: G77 / $H77
E78: (B77 * M(IndexOf[$A78, Indizien], 1))
F78: (C77 * M(IndexOf[$A78, Indizien], 2))
G78: (D77 * M(IndexOf[$A78, Indizien], 3))
H78 = Sum(E78:G78)
B78: E78 / $H78
C78: F78 / $H78
D78: G78 / $H78
E79: (B78 * M(IndexOf[$A79, Indizien], 1))
F79: (C78 * M(IndexOf[$A79, Indizien], 2))
G79: (D78 * M(IndexOf[$A79, Indizien], 3))
H79 = Sum(E79:G79)
B79: E79 / $H79
C79: F79 / $H79
D79: G79 / $H79
E80: (B79 * M(IndexOf[$A80, Indizien], 1))
F80: (C79 * M(IndexOf[$A80, Indizien], 2))
G80: (D79 * M(IndexOf[$A80, Indizien], 3))
H80 = Sum(E80:G80)
B80: E80 / $H80
C80: F80 / $H80
D80: G80 / $H80
E81: (B80 * M(IndexOf[$A81, Indizien], 1))
F81: (C80 * M(IndexOf[$A81, Indizien], 2))
G81: (D80 * M(IndexOf[$A81, Indizien], 3))
H81 = Sum(E81:G81)
B81: E81 / $H81
C81: F81 / $H81
D81: G81 / $H81
E82: (B81 * M(IndexOf[$A82, Indizien], 1))
F82: (C81 * M(IndexOf[$A82, Indizien], 2))
G82: (D81 * M(IndexOf[$A82, Indizien], 3))
H82 = Sum(E82:G82)
B82: E82 / $H82
C82: F82 / $H82
D82: G82 / $H82
E83: (B82 * M(IndexOf[$A83, Indizien], 1))
F83: (C82 * M(IndexOf[$A83, Indizien], 2))
G83: (D82 * M(IndexOf[$A83, Indizien], 3))
H83 = Sum(E83:G83)
B83: E83 / $H83
C83: F83 / $H83
D83: G83 / $H83
E84: (B83 * M(IndexOf[$A84, Indizien], 1))
F84: (C83 * M(IndexOf[$A84, Indizien], 2))
G84: (D83 * M(IndexOf[$A84, Indizien], 3))
H84 = Sum(E84:G84)
B84: E84 / $H84
C84: F84 / $H84
D84: G84 / $H84
E85: (B84 * M(IndexOf[$A85, Indizien], 1))
F85: (C84 * M(IndexOf[$A85, Indizien], 2))
G85: (D84 * M(IndexOf[$A85, Indizien], 3))
H85 = Sum(E85:G85)
B85: E85 / $H85
C85: F85 / $H85
D85: G85 / $H85
E86: (B85 * M(IndexOf[$A86, Indizien], 1))
F86: (C85 * M(IndexOf[$A86, Indizien], 2))
G86: (D85 * M(IndexOf[$A86, Indizien], 3))
H86 = Sum(E86:G86)
B86: E86 / $H86
C86: F86 / $H86
D86: G86 / $H86
E87: (B86 * M(IndexOf[$A87, Indizien], 1))
F87: (C86 * M(IndexOf[$A87, Indizien], 2))
G87: (D86 * M(IndexOf[$A87, Indizien], 3))
H87 = Sum(E87:G87)
B87: E87 / $H87
C87: F87 / $H87
D87: G87 / $H87
E88: (B87 * M(IndexOf[$A88, Indizien], 1))
F88: (C87 * M(IndexOf[$A88, Indizien], 2))
G88: (D87 * M(IndexOf[$A88, Indizien], 3))
H88 = Sum(E88:G88)
B88: E88 / $H88
C88: F88 / $H88
D88: G88 / $H88
E89: (B88 * M(IndexOf[$A89, Indizien], 1))
F89: (C88 * M(IndexOf[$A89, Indizien], 2))
G89: (D88 * M(IndexOf[$A89, Indizien], 3))
H89 = Sum(E89:G89)
B89: E89 / $H89
C89: F89 / $H89
D89: G89 / $H89
E90: (B89 * M(IndexOf[$A90, Indizien], 1))
F90: (C89 * M(IndexOf[$A90, Indizien], 2))
G90: (D89 * M(IndexOf[$A90, Indizien], 3))
H90 = Sum(E90:G90)
B90: E90 / $H90
C90: F90 / $H90
D90: G90 / $H90
E91: (B90 * M(IndexOf[$A91, Indizien], 1))
F91: (C90 * M(IndexOf[$A91, Indizien], 2))
G91: (D90 * M(IndexOf[$A91, Indizien], 3))
H91 = Sum(E91:G91)
B91: E91 / $H91
C91: F91 / $H91
D91: G91 / $H91
E92: (B91 * M(IndexOf[$A92, Indizien], 1))
F92: (C91 * M(IndexOf[$A92, Indizien], 2))
G92: (D91 * M(IndexOf[$A92, Indizien], 3))
H92 = Sum(E92:G92)
B92: E92 / $H92
C92: F92 / $H92
D92: G92 / $H92
E93: (B92 * M(IndexOf[$A93, Indizien], 1))
F93: (C92 * M(IndexOf[$A93, Indizien], 2))
G93: (D92 * M(IndexOf[$A93, Indizien], 3))
H93 = Sum(E93:G93)
B93: E93 / $H93
C93: F93 / $H93
D93: G93 / $H93
E94: (B93 * M(IndexOf[$A94, Indizien], 1))
F94: (C93 * M(IndexOf[$A94, Indizien], 2))
G94: (D93 * M(IndexOf[$A94, Indizien], 3))
H94 = Sum(E94:G94)
B94: E94 / $H94
C94: F94 / $H94
D94: G94 / $H94
E95: (B94 * M(IndexOf[$A95, Indizien], 1))
F95: (C94 * M(IndexOf[$A95, Indizien], 2))
G95: (D94 * M(IndexOf[$A95, Indizien], 3))
H95 = Sum(E95:G95)
B95: E95 / $H95
C95: F95 / $H95
D95: G95 / $H95
E96: (B95 * M(IndexOf[$A96, Indizien], 1))
F96: (C95 * M(IndexOf[$A96, Indizien], 2))
G96: (D95 * M(IndexOf[$A96, Indizien], 3))
H96 = Sum(E96:G96)
B96: E96 / $H96
C96: F96 / $H96
D96: G96 / $H96
E97: (B96 * M(IndexOf[$A97, Indizien], 1))
F97: (C96 * M(IndexOf[$A97, Indizien], 2))
G97: (D96 * M(IndexOf[$A97, Indizien], 3))
H97 = Sum(E97:G97)
B97: E97 / $H97
C97: F97 / $H97
D97: G97 / $H97
E98: (B97 * M(IndexOf[$A98, Indizien], 1))
F98: (C97 * M(IndexOf[$A98, Indizien], 2))
G98: (D97 * M(IndexOf[$A98, Indizien], 3))
H98 = Sum(E98:G98)
B98: E98 / $H98
C98: F98 / $H98
D98: G98 / $H98
E99: (B98 * M(IndexOf[$A99, Indizien], 1))
F99: (C98 * M(IndexOf[$A99, Indizien], 2))
G99: (D98 * M(IndexOf[$A99, Indizien], 3))
H99 = Sum(E99:G99)
B99: E99 / $H99
C99: F99 / $H99
D99: G99 / $H99
E100: (B99 * M(IndexOf[$A100, Indizien], 1))
F100: (C99 * M(IndexOf[$A100, Indizien], 2))
G100: (D99 * M(IndexOf[$A100, Indizien], 3))
H100 = Sum(E100:G100)
B100: E100 / $H100
C100: F100 / $H100
D100: G100 / $H100
E101: (B100 * M(IndexOf[$A101, Indizien], 1))
F101: (C100 * M(IndexOf[$A101, Indizien], 2))
G101: (D100 * M(IndexOf[$A101, Indizien], 3))
H101 = Sum(E101:G101)
B101: E101 / $H101
C101: F101 / $H101
D101: G101 / $H101
E102: (B101 * M(IndexOf[$A102, Indizien], 1))
F102: (C101 * M(IndexOf[$A102, Indizien], 2))
G102: (D101 * M(IndexOf[$A102, Indizien], 3))
H102 = Sum(E102:G102)
B102: E102 / $H102
C102: F102 / $H102
D102: G102 / $H102
E103: (B102 * M(IndexOf[$A103, Indizien], 1))
F103: (C102 * M(IndexOf[$A103, Indizien], 2))
G103: (D102 * M(IndexOf[$A103, Indizien], 3))
H103 = Sum(E103:G103)
B103: E103 / $H103
C103: F103 / $H103
D103: G103 / $H103
E104: (B103 * M(IndexOf[$A104, Indizien], 1))
F104: (C103 * M(IndexOf[$A104, Indizien], 2))
G104: (D103 * M(IndexOf[$A104, Indizien], 3))
H104 = Sum(E104:G104)
B104: E104 / $H104
C104: F104 / $H104
D104: G104 / $H104
E105: (B104 * M(IndexOf[$A105, Indizien], 1))
F105: (C104 * M(IndexOf[$A105, Indizien], 2))
G105: (D104 * M(IndexOf[$A105, Indizien], 3))
H105 = Sum(E105:G105)
B105: E105 / $H105
C105: F105 / $H105
D105: G105 / $H105
E106: (B105 * M(IndexOf[$A106, Indizien], 1))
F106: (C105 * M(IndexOf[$A106, Indizien], 2))
G106: (D105 * M(IndexOf[$A106, Indizien], 3))
H106 = Sum(E106:G106)
B106: E106 / $H106
C106: F106 / $H106
D106: G106 / $H106
E107: (B106 * M(IndexOf[$A107, Indizien], 1))
F107: (C106 * M(IndexOf[$A107, Indizien], 2))
G107: (D106 * M(IndexOf[$A107, Indizien], 3))
H107 = Sum(E107:G107)
B107: E107 / $H107
C107: F107 / $H107
D107: G107 / $H107
E108: (B107 * M(IndexOf[$A108, Indizien], 1))
F108: (C107 * M(IndexOf[$A108, Indizien], 2))
G108: (D107 * M(IndexOf[$A108, Indizien], 3))
H108 = Sum(E108:G108)
B108: E108 / $H108
C108: F108 / $H108
D108: G108 / $H108
E109: (B108 * M(IndexOf[$A109, Indizien], 1))
F109: (C108 * M(IndexOf[$A109, Indizien], 2))
G109: (D108 * M(IndexOf[$A109, Indizien], 3))
H109 = Sum(E109:G109)
B109: E109 / $H109
C109: F109 / $H109
D109: G109 / $H109
E110: (B109 * M(IndexOf[$A110, Indizien], 1))
F110: (C109 * M(IndexOf[$A110, Indizien], 2))
G110: (D109 * M(IndexOf[$A110, Indizien], 3))
H110 = Sum(E110:G110)
B110: E110 / $H110
C110: F110 / $H110
D110: G110 / $H110
E111: (B110 * M(IndexOf[$A111, Indizien], 1))
F111: (C110 * M(IndexOf[$A111, Indizien], 2))
G111: (D110 * M(IndexOf[$A111, Indizien], 3))
H111 = Sum(E111:G111)
B111: E111 / $H111
C111: F111 / $H111
D111: G111 / $H111
No: 0…100
LA: B9:B111
GA = PolyLine((No, LA))
GB = PolyLine((No, C9:C111))
GC = PolyLine((No, D9:D111))
PGA: (No, LA)
PGB: (No, C9:C111)
PGC: (No, D9:D111)
A112: 6
A113: 4
A114: 5
A115: 5
A116: 1
A117: 5
A118: 1
L2: 0.166666666666667
L3: 0.166666666666667
L4: 0.166666666666667
L5: 0.166666666666667
L6: 0.166666666666667
L7: 0.166666666666667
M7: M2
M3: 0.0500000000000001
M4: 0.350000000000000
M5: 0.350000000000000
M6: 0.0500000000000001
N2: 0.09
N3: 0.09
N4: 0.420000000000000
N5: 0.220000000000000
N6: 0.09
N7: 0.09
K3: 2
K4: 3
K5: 4
K6: 5
K7: 6
K2: 1
A2: 1
A3: 2
C4: 0.310000000000000
B4: 0.166666666666667
C5: 0.310000000000000
B5: 0.166666666666667
C6: 0.0800000000000001
B6: 0.166666666666667
C7: 0.110000000000000
B7: 0.166666666666667
E1 = Sum(E2:E7)
E2 = CountIf(x ≟ A2, A$10:A$109)
E3 = CountIf(x ≟ A3, A$10:A$109)
I10: 1
I11: 2
I12 = 3
I13 = 4
I14 = 5
I15 = 6
I16 = 7
I17 = 8
I18 = 9
I19 = 10
I20 = 11
I21 = 12
I22 = 13
I23 = 14
I24 = 15
I25 = 16
I26 = 17
I27 = 18
I28 = 19
I29 = 20
I30 = 21
I31 = 22
I32 = 23
I33 = 24
I34 = 25
I35 = 26
I36 = 27
I37 = 28
I38 = 29
I39 = 30
I40 = 31
I41 = 32
I42 = 33
I43 = 34
I44 = 35
I45 = 36
I46 = 37
I47 = 38
I48 = 39
I49 = 40
I50 = 41
I51 = 42
I52 = 43
I53 = 44
I54 = 45
I55 = 46
I56 = 47
I57 = 48
I58 = 49
I59 = 50
I60 = 51
I61 = 52
I62 = 53
I63 = 54
I64 = 55
I65 = 56
I66 = 57
I67 = 58
I68 = 59
I69 = 60
I70 = 61
I71 = 62
I72 = 63
I73 = 64
I74 = 65
I75 = 66
I76 = 67
I77 = 68
I78 = 69
I79 = 70
I80 = 71
I81 = 72
I82 = 73
I83 = 74
I84 = 75
I85 = 76
I86 = 77
I87 = 78
I88 = 79
I89 = 80
I90 = 81
I91 = 82
I92 = 83
I93 = 84
I94 = 85
I95 = 86
I96 = 87
I97 = 88
I98 = 89
I99 = 90
I100 = 91
I101 = 92
I102 = 93
I103 = 94
I104 = 95
I105 = 96
I106 = 97
I107 = 98
I108 = 99
I109 = 100
I110 = 101
I111 = 102
PA: (100, B109)
PB: (100, C109)
PC: (100, D109)
E112: (B111 * M(IndexOf[$A112, Indizien], 1))
F112: (C111 * M(IndexOf[$A112, Indizien], 2))
G112: (D111 * M(IndexOf[$A112, Indizien], 3))
H112 = Sum(E112:G112)
B112: E112 / $H112
C112: F112 / $H112
D112: G112 / $H112
I112 = 103
E113: (B112 * M(IndexOf[$A113, Indizien], 1))
F113: (C112 * M(IndexOf[$A113, Indizien], 2))
G113: (D112 * M(IndexOf[$A113, Indizien], 3))
H113 = Sum(E113:G113)
B113: E113 / $H113
C113: F113 / $H113
D113: G113 / $H113
I113 = 104
E114: (B113 * M(IndexOf[$A114, Indizien], 1))
F114: (C113 * M(IndexOf[$A114, Indizien], 2))
G114: (D113 * M(IndexOf[$A114, Indizien], 3))
H114 = Sum(E114:G114)
B114: E114 / $H114
C114: F114 / $H114
D114: G114 / $H114
I114 = 105
E115: (B114 * M(IndexOf[$A115, Indizien], 1))
F115: (C114 * M(IndexOf[$A115, Indizien], 2))
G115: (D114 * M(IndexOf[$A115, Indizien], 3))
H115 = Sum(E115:G115)
B115: E115 / $H115
C115: F115 / $H115
D115: G115 / $H115
I115 = 106
E116: (B115 * M(IndexOf[$A116, Indizien], 1))
F116: (C115 * M(IndexOf[$A116, Indizien], 2))
G116: (D115 * M(IndexOf[$A116, Indizien], 3))
H116 = Sum(E116:G116)
B116: E116 / $H116
C116: F116 / $H116
D116: G116 / $H116
I116 = 107
E117: (B116 * M(IndexOf[$A117, Indizien], 1))
F117: (C116 * M(IndexOf[$A117, Indizien], 2))
G117: (D116 * M(IndexOf[$A117, Indizien], 3))
H117 = Sum(E117:G117)
B117: E117 / $H117
C117: F117 / $H117
D117: G117 / $H117
I117 = 108
E118: (B117 * M(IndexOf[$A118, Indizien], 1))
F118: (C117 * M(IndexOf[$A118, Indizien], 2))
G118: (D117 * M(IndexOf[$A118, Indizien], 3))
H118 = Sum(E118:G118)
B118: E118 / $H118
C118: F118 / $H118
D118: G118 / $H118
I118: 109
B8: B109
C8: C109
D8: D109
O2: 0
P2: 0.0839160839160839
Q2: 0.108795419140247
R2: 0.131687242798354
O3: 1
P3: 0.349650349650350
Q3: 0.339985684813271
R3: 0.329218106995885
O4: 2
P4: 0.399600399600400
Q4: 0.359984842743464
R4: 0.329218106995885
O5: 3
P5: 0.149850149850150
Q5: 0.159993263441539
R5: 0.164609053497942
O6: 4
P6: 0.0166500166500167
Q6: 0.0294724432655467
R6: 0.0411522633744856
O7: 5
P7: 0.000333000333000333
Q7: 0.00176834659593281
R7: 0.00411522633744856
B2: 0.166666666666667
B3: 0.166666666666667
C2: 0.110000000000000
C3: 0.0800000000000001
T2: 1 / 3
T3: 2 / 3
U2: 1 / 2
U3: 0.5
V2: 2 / 3
V3: 1 / 3
T4: 0
T5: 0
T6: 0
T7: 0
U4: 0
U5: 0
U6: 0
U7: 0
V4: 0
V5: 0
V6: 0
V7: 0
D2: 0.0900000000000001
D3: 0.0900000000000001
D4: 0.420000000000000
D5: 0.220000000000000
D6: 0.0900000000000001
D7: 0.0900000000000001
A4: 3
E4 = CountIf(x ≟ A4, A$10:A$109)
A5: 4
E5 = CountIf(x ≟ A5, A$10:A$109)
A6: 5
E6 = CountIf(x ≟ A6, A$10:A$109)
A7: 6
E7 = CountIf(x ≟ A7, A$10:A$109)
E8: (($E1 * B2) - $E2)^(2) / (($E1 * B2)) + (($E1 * B3) - $E3)^(2) / (($E1 * B3)) + If[B4 > 0, (($E1 * B4) - $E4)^(2) / (($E1 * B4)), 0] + If[B5 > 0, (($E1 * B5) - $E5)^(2) / (($E1 * B5)), 0] + If[B6 > 0, (($E1 * B6) - $E6)^(2) / (($E1 * B6)), 0] + If[B7 > 0, (($E1 * B7) - $E7)^(2) / (($E1 * B7)), 0]
F8: (($E1 * C2) - $E2)^(2) / (($E1 * C2)) + (($E1 * C3) - $E3)^(2) / (($E1 * C3)) + If[C4 > 0, (($E1 * C4) - $E4)^(2) / (($E1 * C4)), 0] + If[C5 > 0, (($E1 * C5) - $E5)^(2) / (($E1 * C5)), 0] + If[C6 > 0, (($E1 * C6) - $E6)^(2) / (($E1 * C6)), 0] + If[C7 > 0, (($E1 * C7) - $E7)^(2) / (($E1 * C7)), 0]
G8: (($E1 * D2) - $E2)^(2) / (($E1 * D2)) + (($E1 * D3) - $E3)^(2) / (($E1 * D3)) + If[D4 > 0, (($E1 * D4) - $E4)^(2) / (($E1 * D4)), 0] + If[D5 > 0, (($E1 * D5) - $E5)^(2) / (($E1 * D5)), 0] + If[D6 > 0, (($E1 * D6) - $E6)^(2) / (($E1 * D6)), 0] + If[D7 > 0, (($E1 * D7) - $E7)^(2) / (($E1 * D7)), 0]
W2: 1
W3: 2
W4: 3
W5: 4
W6: 5
W7: 6
X2: 11 / 36
X3: 9 / 36
X4: 7 / 36
X5: 5 / 36
X6: 3 / 36
X7: 1 / 36
Z2: 1 / 36
Z3: 3 / 36
Z4: 5 / 36
Z5: 7 / 36
Z6: 9 / 36
Z7: 11 / 36
Y2: 1 / 6
Y3: 0.166666666666667
Y4: 0.166666666666667
Y5: 0.166666666666667
Y6: 0.166666666666667
Y7: 0.166666666666667