PerlenSTICHproben

rote

gelbe

grüne

Summe

<-p(rot)

Gruppe 1

Gruppe 2

Gruppe 3

Gruppe 4

Gruppe 5

von

bis

h

zweifel

k-von

k-bis

Konfidenzintervalle  einzeln / Gruppen / alle zusammen
je mehr Perlen desto kleiner

Prognoseintrvalle für hypothetische Wk p(rot)
für 25 Personen/ 5 Gruppen / Plenum

g = Segment((0, 0), (0, 1))
P = Point(g)
G1: y(P)
A3: 1
C3: 28
D3: 22
E3: 17
A4: 2
C4: 24
D4: 16
E4: 22
A5: 3
C5: 37
D5: 10
E5: 18
A6: 4
C6: 40
D6: 15
E6: 10
A7: 5
C7: 41
D7: 15
E7: 15
A10: 6
C10: 35
D10: 24
E10: 22
F10: 81
A11: 7
C11: 32
D11: 17
E11: 19
F11: 68
A12: 8
C12: 31
D12: 8
E12: 16
F12: 55
A13: 9
C13: 19
D13: 13
E13: 15
F13: 47
A14: 10
C14: 30
D14: 18
E14: 10
F14: 58
A17: 11
C17: 34
D17: 17
E17: 11
F17: 62
A18: 12
C18: 28
D18: 11
E18: 22
F18: 61
A19: 13
C19: 27
D19: 19
E19: 15
F19: 61
A20: 14
C20: 13
D20: 6
E20: 8
F20: 27
A21: 15
C21: 17
D21: 9
E21: 15
F21: 41
A24: 16
C24: 31
D24: 14
E24: 15
F24: 60
A25: 17
C25: 29
D25: 10
E25: 10
F25: 49
A26: 18
C26: 27
D26: 16
E26: 18
F26: 61
A27: 19
C27: 29
D27: 14
E27: 17
F27: 60
A28: 20
C28: 41
D28: 9
E28: 17
F28: 67
A31: 21
A32: 22
A33: 23
A34: 24
A35: 25
C8 = Sum(C3:C7)
D8 = Sum(D3:D7)
E8 = Sum(E3:E7)
F8 = Sum(F3:F7)
F3 = Sum(C3:E3)
F4 = Sum(C4:E4)
F5 = Sum(C5:E5)
F6 = Sum(C6:E6)
F7 = Sum(C7:E7)
C15 = Sum(C10:C14)
D15 = Sum(D10:D14)
E15 = Sum(E10:E14)
F15 = Sum(F10:F14)
C22 = Sum(C17:C21)
D22 = Sum(D17:D21)
E22 = Sum(E17:E21)
F22 = Sum(F17:F21)
C29 = Sum(C24:C28)
D29 = Sum(D24:D28)
E29 = Sum(E24:E28)
F29 = Sum(F24:F28)
C31: 31
D31: 21
E31: 18
F31: 70
C32: 27
D32: 14
E32: 11
F32: 52
C33: 31
D33: 12
E33: 16
F33: 59
C34: 22
D34: 17
E34: 14
F34: 53
C35: 41
D35: 17
E35: 18
F35: 76
C36 = Sum(C31:C35)
D36 = Sum(D31:D35)
E36 = Sum(E31:E35)
F36 = Sum(F31:F35)
G3: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F3))
H3: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F3))
I3: C3 / F3
J3 = If(G3 ≤ I3 ≤ H3, 0, 1)
G4: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F4))
H4: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F4))
I4: C4 / F4
J4 = If(G4 ≤ I4 ≤ H4, 0, 1)
G5: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F5))
H5: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F5))
I5: C5 / F5
J5 = If(G5 ≤ I5 ≤ H5, 0, 1)
G6: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F6))
H6: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F6))
I6: C6 / F6
J6 = If(G6 ≤ I6 ≤ H6, 0, 1)
G7: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F7))
H7: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F7))
I7: C7 / F7
J7 = If(G7 ≤ I7 ≤ H7, 0, 1)
G8: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F8))
H8: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F8))
I8: C8 / F8
J8 = If(G8 ≤ I8 ≤ H8, 0, 1)
G10: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F10))
H10: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F10))
I10: C10 / F10
J10 = If(G10 ≤ I10 ≤ H10, 0, 1)
G11: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F11))
H11: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F11))
I11: C11 / F11
J11 = If(G11 ≤ I11 ≤ H11, 0, 1)
G12: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F12))
H12: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F12))
I12: C12 / F12
J12 = If(G12 ≤ I12 ≤ H12, 0, 1)
G13: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F13))
H13: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F13))
I13: C13 / F13
J13 = If(G13 ≤ I13 ≤ H13, 0, 1)
G14: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F14))
H14: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F14))
I14: C14 / F14
J14 = If(G14 ≤ I14 ≤ H14, 0, 1)
G15: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F15))
H15: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F15))
I15: C15 / F15
J15 = If(G15 ≤ I15 ≤ H15, 0, 1)
G17: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F17))
H17: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F17))
I17: C17 / F17
J17 = If(G17 ≤ I17 ≤ H17, 0, 1)
G18: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F18))
H18: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F18))
I18: C18 / F18
J18 = If(G18 ≤ I18 ≤ H18, 0, 1)
G19: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F19))
H19: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F19))
I19: C19 / F19
J19 = If(G19 ≤ I19 ≤ H19, 0, 1)
G20: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F20))
H20: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F20))
I20: C20 / F20
J20 = If(G20 ≤ I20 ≤ H20, 0, 1)
G21: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F21))
H21: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F21))
I21: C21 / F21
J21 = If(G21 ≤ I21 ≤ H21, 0, 1)
G22: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F22))
H22: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F22))
I22: C22 / F22
J22 = If(G22 ≤ I22 ≤ H22, 0, 1)
G24: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F24))
H24: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F24))
I24: C24 / F24
J24 = If(G24 ≤ I24 ≤ H24, 0, 1)
G25: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F25))
H25: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F25))
I25: C25 / F25
J25 = If(G25 ≤ I25 ≤ H25, 0, 1)
G26: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F26))
H26: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F26))
I26: C26 / F26
J26 = If(G26 ≤ I26 ≤ H26, 0, 1)
G27: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F27))
H27: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F27))
I27: C27 / F27
J27 = If(G27 ≤ I27 ≤ H27, 0, 1)
G28: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F28))
H28: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F28))
I28: C28 / F28
J28 = If(G28 ≤ I28 ≤ H28, 0, 1)
G29: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F29))
H29: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F29))
I29: C29 / F29
J29 = If(G29 ≤ I29 ≤ H29, 0, 1)
G31: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F31))
H31: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F31))
I31: C31 / F31
J31 = If(G31 ≤ I31 ≤ H31, 0, 1)
G32: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F32))
H32: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F32))
I32: C32 / F32
J32 = If(G32 ≤ I32 ≤ H32, 0, 1)
G33: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F33))
H33: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F33))
I33: C33 / F33
J33 = If(G33 ≤ I33 ≤ H33, 0, 1)
G34: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F34))
H34: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F34))
I34: C34 / F34
J34 = If(G34 ≤ I34 ≤ H34, 0, 1)
G35: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F35))
H35: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F35))
I35: C35 / F35
J35 = If(G35 ≤ I35 ≤ H35, 0, 1)
G36: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F36))
H36: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F36))
I36: C36 / F36
K3: $I3 - (2 * sqrt((($I3 * (1 - $I3))) / $F3))
L3: $I3 + (2 * sqrt((($I3 * (1 - $I3))) / $F3))
K4: $I4 - (2 * sqrt((($I4 * (1 - $I4))) / $F4))
L4: $I4 + (2 * sqrt((($I4 * (1 - $I4))) / $F4))
K5: $I5 - (2 * sqrt((($I5 * (1 - $I5))) / $F5))
L5: $I5 + (2 * sqrt((($I5 * (1 - $I5))) / $F5))
K6: $I6 - (2 * sqrt((($I6 * (1 - $I6))) / $F6))
L6: $I6 + (2 * sqrt((($I6 * (1 - $I6))) / $F6))
K7: $I7 - (2 * sqrt((($I7 * (1 - $I7))) / $F7))
L7: $I7 + (2 * sqrt((($I7 * (1 - $I7))) / $F7))
K8: $I8 - (2 * sqrt((($I8 * (1 - $I8))) / $F8))
L8: $I8 + (2 * sqrt((($I8 * (1 - $I8))) / $F8))
K10: $I10 - (2 * sqrt((($I10 * (1 - $I10))) / $F10))
L10: $I10 + (2 * sqrt((($I10 * (1 - $I10))) / $F10))
K11: $I11 - (2 * sqrt((($I11 * (1 - $I11))) / $F11))
L11: $I11 + (2 * sqrt((($I11 * (1 - $I11))) / $F11))
K12: $I12 - (2 * sqrt((($I12 * (1 - $I12))) / $F12))
L12: $I12 + (2 * sqrt((($I12 * (1 - $I12))) / $F12))
K13: $I13 - (2 * sqrt((($I13 * (1 - $I13))) / $F13))
L13: $I13 + (2 * sqrt((($I13 * (1 - $I13))) / $F13))
K14: $I14 - (2 * sqrt((($I14 * (1 - $I14))) / $F14))
L14: $I14 + (2 * sqrt((($I14 * (1 - $I14))) / $F14))
K15: $I15 - (2 * sqrt((($I15 * (1 - $I15))) / $F15))
L15: $I15 + (2 * sqrt((($I15 * (1 - $I15))) / $F15))
K17: $I17 - (2 * sqrt((($I17 * (1 - $I17))) / $F17))
L17: $I17 + (2 * sqrt((($I17 * (1 - $I17))) / $F17))
K18: $I18 - (2 * sqrt((($I18 * (1 - $I18))) / $F18))
L18: $I18 + (2 * sqrt((($I18 * (1 - $I18))) / $F18))
K19: $I19 - (2 * sqrt((($I19 * (1 - $I19))) / $F19))
L19: $I19 + (2 * sqrt((($I19 * (1 - $I19))) / $F19))
K20: $I20 - (2 * sqrt((($I20 * (1 - $I20))) / $F20))
L20: $I20 + (2 * sqrt((($I20 * (1 - $I20))) / $F20))
K21: $I21 - (2 * sqrt((($I21 * (1 - $I21))) / $F21))
L21: $I21 + (2 * sqrt((($I21 * (1 - $I21))) / $F21))
K22: $I22 - (2 * sqrt((($I22 * (1 - $I22))) / $F22))
L22: $I22 + (2 * sqrt((($I22 * (1 - $I22))) / $F22))
K24: $I24 - (2 * sqrt((($I24 * (1 - $I24))) / $F24))
L24: $I24 + (2 * sqrt((($I24 * (1 - $I24))) / $F24))
K25: $I25 - (2 * sqrt((($I25 * (1 - $I25))) / $F25))
L25: $I25 + (2 * sqrt((($I25 * (1 - $I25))) / $F25))
K26: $I26 - (2 * sqrt((($I26 * (1 - $I26))) / $F26))
L26: $I26 + (2 * sqrt((($I26 * (1 - $I26))) / $F26))
K27: $I27 - (2 * sqrt((($I27 * (1 - $I27))) / $F27))
L27: $I27 + (2 * sqrt((($I27 * (1 - $I27))) / $F27))
K28: $I28 - (2 * sqrt((($I28 * (1 - $I28))) / $F28))
L28: $I28 + (2 * sqrt((($I28 * (1 - $I28))) / $F28))
K29: $I29 - (2 * sqrt((($I29 * (1 - $I29))) / $F29))
L29: $I29 + (2 * sqrt((($I29 * (1 - $I29))) / $F29))
K31: $I31 - (2 * sqrt((($I31 * (1 - $I31))) / $F31))
L31: $I31 + (2 * sqrt((($I31 * (1 - $I31))) / $F31))
K32: $I32 - (2 * sqrt((($I32 * (1 - $I32))) / $F32))
L32: $I32 + (2 * sqrt((($I32 * (1 - $I32))) / $F32))
K33: $I33 - (2 * sqrt((($I33 * (1 - $I33))) / $F33))
L33: $I33 + (2 * sqrt((($I33 * (1 - $I33))) / $F33))
K34: $I34 - (2 * sqrt((($I34 * (1 - $I34))) / $F34))
L34: $I34 + (2 * sqrt((($I34 * (1 - $I34))) / $F34))
K35: $I35 - (2 * sqrt((($I35 * (1 - $I35))) / $F35))
L35: $I35 + (2 * sqrt((($I35 * (1 - $I35))) / $F35))
K36: $I36 - (2 * sqrt((($I36 * (1 - $I36))) / $F36))
L36: $I36 + (2 * sqrt((($I36 * (1 - $I36))) / $F36))
N4 = Segment((A4, K4), (A4, L4))
N5 = Segment((A5, K5), (A5, L5))
N6 = Segment((A6, K6), (A6, L6))
N7 = Segment((A7, K7), (A7, L7))
A8: 26
N8_1 = Segment((A8, K8), (A8, L8))
N8 = Segment((A8, K8), (A8, L8))
N10 = Segment((A10, K10), (A10, L10))
N11 = Segment((A11, K11), (A11, L11))
N12 = Segment((A12, K12), (A12, L12))
N13 = Segment((A13, K13), (A13, L13))
N14 = Segment((A14, K14), (A14, L14))
A15: 27
N15 = Segment((A15, K15), (A15, L15))
A22: 28
A29: 29
A36: 30
N17 = Segment((A17, K17), (A17, L17))
N18 = Segment((A18, K18), (A18, L18))
N19 = Segment((A19, K19), (A19, L19))
N20 = Segment((A20, K20), (A20, L20))
N21 = Segment((A21, K21), (A21, L21))
N22 = Segment((A22, K22), (A22, L22))
N24 = Segment((A24, K24), (A24, L24))
N25 = Segment((A25, K25), (A25, L25))
N26 = Segment((A26, K26), (A26, L26))
N27 = Segment((A27, K27), (A27, L27))
N28 = Segment((A28, K28), (A28, L28))
N29 = Segment((A29, K29), (A29, L29))
N31 = Segment((A31, K31), (A31, L31))
N32 = Segment((A32, K32), (A32, L32))
N33 = Segment((A33, K33), (A33, L33))
N34 = Segment((A34, K34), (A34, L34))
N35 = Segment((A35, K35), (A35, L35))
N36 = Segment((A36, K36), (A36, L36))
C38: C8 + C15 + C22 + C29 + C36
D38: D8 + D15 + D22 + D29 + D36
E38: E8 + E15 + E22 + E29 + E36
F38: F8 + F15 + F22 + F29 + F36
G38: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F38))
H38: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F38))
I38: C38 / F38
J38 = If(G38 ≤ I38 ≤ H38, 0, 1)
K38: $I38 - (2 * sqrt((($I38 * (1 - $I38))) / $F38))
L38: $I38 + (2 * sqrt((($I38 * (1 - $I38))) / $F38))
A38: 32
N38_1 = Segment((A38, K38), (A38, L38))
N38 = Segment((A38, K38), (A38, L38))
J36 = If(G36 ≤ I36 ≤ H36, 0, 1)
I1: J8 + J15 + J22 + J29 + J36
J1: Sum[J3:J36] - I1
f(x) = G1
N3 = Segment(($A3, K3), ($A3, L3))
M3 = Segment(($A3, G3), ($A3, H3))
M4 = Segment(($A4, G4), ($A4, H4))
M5 = Segment(($A5, G5), ($A5, H5))
M6 = Segment(($A6, G6), ($A6, H6))
M7 = Segment(($A7, G7), ($A7, H7))
M8 = Segment(($A8, G8), ($A8, H8))
M10 = Segment(($A10, G10), ($A10, H10))
M11 = Segment(($A11, G11), ($A11, H11))
M12 = Segment(($A12, G12), ($A12, H12))
M13 = Segment(($A13, G13), ($A13, H13))
M14 = Segment(($A14, G14), ($A14, H14))
M15 = Segment(($A15, G15), ($A15, H15))
M17 = Segment(($A17, G17), ($A17, H17))
M18 = Segment(($A18, G18), ($A18, H18))
M19 = Segment(($A19, G19), ($A19, H19))
M20 = Segment(($A20, G20), ($A20, H20))
M21 = Segment(($A21, G21), ($A21, H21))
M22 = Segment(($A22, G22), ($A22, H22))
M24 = Segment(($A24, G24), ($A24, H24))
M25 = Segment(($A25, G25), ($A25, H25))
M26 = Segment(($A26, G26), ($A26, H26))
M27 = Segment(($A27, G27), ($A27, H27))
M28 = Segment(($A28, G28), ($A28, H28))
M29 = Segment(($A29, G29), ($A29, H29))
M31 = Segment(($A31, G31), ($A31, H31))
M32 = Segment(($A32, G32), ($A32, H32))
M33 = Segment(($A33, G33), ($A33, H33))
M34 = Segment(($A34, G34), ($A34, H34))
M35 = Segment(($A35, G35), ($A35, H35))
M36 = Segment(($A36, G36), ($A36, H36))
M38 = Segment(($A38, G38), ($A38, H38))
relh: (A3:A38, I3:I38)