Fuß

Summe

<-p

Gruppe 1

Gruppe 2

Gruppe 3

Gruppe 4

Johanna

von

bis

h

zweifel

k-von

k-bis

Konfidenzintervalle  einzeln (blau) / Gruppen (rot) / alle zusammen (schwarz)
je mehr Versuche desto kleiner

Prognoseintrvalle für angesetzte Wahrscheinlichkeit  p
(einzeln / Gruppen / alle zusammen)

Antonia

Mirjam

Sarah

Julia

Julia

Sophia

Salvatore

Theresa

Jana

Alicia

Luisa

Lea Maria

María

Thomas

Carmen

Moritz

Lara

Peer

Anna-Sophie

Sebastian

Catrina

Carina

Gruppe 5

Gruppe 6

alle

g = Segment((0, 0), (0, 1))
P = Point(g)
G1: y(P)
A3: 1
C3: 35
A4: 2
C4: 47
A5: 3
C5: 40
A6: 4
C6: 50
A9: 6
C9: 44
D9: 0
E9: 0
F9: 100
A10: 7
C10: 49
D10: 0
E10: 0
F10: 100
A11: 8
C11: 51
D11: 0
E11: 0
F11: 100
A12: 9
C12: 41
D12: 0
E12: 0
F12: 100
A15: 11
C15: 49
D15: 0
E15: 0
F15: 100
A16: 12
C16: 48
D16: 0
E16: 0
F16: 100
A17: 13
C17: 40
D17: 0
E17: 0
F17: 100
A18: 14
C18: 57
D18: 0
E18: 0
F18: 100
A21: 16
C21: 45
D21: 0
E21: 0
F21: 100
A22: 17
C22: 45
D22: 0
E22: 0
F22: 100
A23: 18
C23: 40
D23: 0
E23: 0
F23: 100
A24: 19
C24: 39
D24: 0
E24: 0
F24: 100
A27: 21
A28: 22
A29: 23
C27: 41
D27: 0
E27: 0
F27: 100
C28: 52
D28: 0
E28: 0
F28: 100
C29: 44
D29: 0
E29: 0
F29: 100
F3: 100
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)
F4: 100
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)
F5: 100
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)
F6: 100
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)
F7 = Sum(F3:F6)
G7: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F7))
H7: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F7))
C7 = Sum(C3:C6)
I7: C7 / F7
J7 = If(G7 ≤ I7 ≤ H7, 0, 1)
G9: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F9))
H9: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F9))
I9: C9 / F9
J9 = If(G9 ≤ I9 ≤ H9, 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)
F13 = Sum(F9:F12)
G13: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F13))
H13: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F13))
C13 = Sum(C9:C12)
I13: C13 / F13
J13 = If(G13 ≤ I13 ≤ H13, 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)
G16: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F16))
H16: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F16))
I16: C16 / F16
J16 = If(G16 ≤ I16 ≤ H16, 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)
F19 = Sum(F15:F18)
G19: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F19))
H19: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F19))
C19 = Sum(C15:C18)
I19: C19 / F19
J19 = If(G19 ≤ I19 ≤ H19, 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)
G23: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F23))
H23: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F23))
I23: C23 / F23
J23 = If(G23 ≤ I23 ≤ H23, 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)
F25 = Sum(F21:F24)
G25: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F25))
H25: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F25))
C25 = Sum(C21:C24)
I25: C25 / F25
J25 = If(G25 ≤ I25 ≤ H25, 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)
F30: 100
G30: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F30))
H30: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F30))
C30: 49
I30: C30 / F30
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))
K9: $I9 - (2 * sqrt((($I9 * (1 - $I9))) / $F9))
L9: $I9 + (2 * sqrt((($I9 * (1 - $I9))) / $F9))
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))
K15: $I15 - (2 * sqrt((($I15 * (1 - $I15))) / $F15))
L15: $I15 + (2 * sqrt((($I15 * (1 - $I15))) / $F15))
K16: $I16 - (2 * sqrt((($I16 * (1 - $I16))) / $F16))
L16: $I16 + (2 * sqrt((($I16 * (1 - $I16))) / $F16))
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))
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))
K23: $I23 - (2 * sqrt((($I23 * (1 - $I23))) / $F23))
L23: $I23 + (2 * sqrt((($I23 * (1 - $I23))) / $F23))
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))
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))
K30: $I30 - (2 * sqrt((($I30 * (1 - $I30))) / $F30))
L30: $I30 + (2 * sqrt((($I30 * (1 - $I30))) / $F30))
A7: 31
N8_1 = Segment((A7, K7), (A7, L7))
N10 = Segment((A10, K10), (A10, L10))
N11 = Segment((A11, K11), (A11, L11))
N12 = Segment((A12, K12), (A12, L12))
A13: 32
N13 = Segment((A13, K13), (A13, L13))
A19: 33
A25: 34
A30: 24
N16 = Segment((A16, K16), (A16, L16))
N17 = Segment((A17, K17), (A17, L17))
N18 = Segment((A18, K18), (A18, L18))
N19 = Segment((A19, K19), (A19, L19))
N22 = Segment((A22, K22), (A22, L22))
N23 = Segment((A23, K23), (A23, L23))
N24 = Segment((A24, K24), (A24, L24))
N25 = Segment((A25, K25), (A25, L25))
N28 = Segment((A28, K28), (A28, L28))
N29 = Segment((A29, K29), (A29, L29))
N30 = Segment((A30, K30), (A30, L30))
F33: 100
G33: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F33))
H33: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F33))
C33: 46
I33: C33 / F33
J33 = If(G33 ≤ I33 ≤ H33, 0, 1)
K33: $I33 - (2 * sqrt((($I33 * (1 - $I33))) / $F33))
L33: $I33 + (2 * sqrt((($I33 * (1 - $I33))) / $F33))
A33: 26
N38_1 = Segment((A33, K33), (A33, L33))
J30 = If(G30 ≤ I30 ≤ H30, 0, 1)
I1: J7 + J13 + J19 + J25 + J30
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))
M9 = Segment(($A9, G9), ($A9, H9))
M10 = Segment(($A10, G10), ($A10, H10))
M11 = Segment(($A11, G11), ($A11, H11))
M12 = Segment(($A12, G12), ($A12, H12))
M13 = Segment(($A13, G13), ($A13, H13))
M15 = Segment(($A15, G15), ($A15, H15))
M16 = Segment(($A16, G16), ($A16, H16))
M17 = Segment(($A17, G17), ($A17, H17))
M18 = Segment(($A18, G18), ($A18, H18))
M19 = Segment(($A19, G19), ($A19, H19))
M21 = Segment(($A21, G21), ($A21, H21))
M22 = Segment(($A22, G22), ($A22, H22))
M23 = Segment(($A23, G23), ($A23, H23))
M24 = Segment(($A24, G24), ($A24, H24))
M25 = Segment(($A25, G25), ($A25, H25))
M27 = Segment(($A27, G27), ($A27, H27))
M28 = Segment(($A28, G28), ($A28, H28))
M29 = Segment(($A29, G29), ($A29, H29))
M30 = Segment(($A30, G30), ($A30, H30))
M33 = Segment(($A33, G33), ($A33, H33))
relh: (A3:A38, I3:I38)
C34: 31
C35: 52
D34: 0
E34: 0
F31 = Sum(F27:F30)
C31 = Sum(C27:C30)
D3: 0
E3: 0
D4: 0
E4: 0
D5: 0
E5: 0
D6: 0
E6: 0
D7: 0
E7: 0
D8: 0
E8: 0
D13: 0
E13: 0
D14: 0
E14: 0
D19: 0
E19: 0
D20: 0
E20: 0
D25: 0
E25: 0
D26: 0
E26: 0
D30: 0
E30: 0
D31: 0
E31: 0
D32: 0
E32: 0
D33: 0
E33: 0
D35: 0
E35: 0
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)
K31: $I31 - (2 * sqrt((($I31 * (1 - $I31))) / $F31))
L31: $I31 + (2 * sqrt((($I31 * (1 - $I31))) / $F31))
C36 = Sum(C33:C35)
F34: 100
F35: 100
F36: 300
G34: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F34))
G35: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F35))
G36: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F36))
H34: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F34))
H35: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F35))
H36: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F36))
I34: C34 / F34
I35: C35 / F35
I36: C36 / F36
K34: $I34 - (2 * sqrt((($I34 * (1 - $I34))) / $F34))
K35: $I35 - (2 * sqrt((($I35 * (1 - $I35))) / $F35))
K36: $I36 - (2 * sqrt((($I36 * (1 - $I36))) / $F36))
L34: $I34 + (2 * sqrt((($I34 * (1 - $I34))) / $F34))
L35: $I35 + (2 * sqrt((($I35 * (1 - $I35))) / $F35))
L36: $I36 + (2 * sqrt((($I36 * (1 - $I36))) / $F36))
A31: 35
M31 = Segment(($A31, G31), ($A31, H31))
A34: 27
A35: 28
A36: 36
N9 = Segment(($A9, K9), ($A9, L9))
N15 = Segment(($A15, K15), ($A15, L15))
N21 = Segment(($A21, K21), ($A21, L21))
N31 = Segment((A31, K31), (A31, L31))
N27 = Segment(($A27, K27), ($A27, L27))
N34 = Segment((A34, K34), (A34, L34))
N35 = Segment((A35, K35), (A35, L35))
N36 = Segment((A36, K36), (A36, L36))
M34 = Segment(($A34, G34), ($A34, H34))
M35 = Segment(($A35, G35), ($A35, H35))
M36 = Segment(($A36, G36), ($A36, H36))
N33 = Segment(($A33, K33), ($A33, L33))
N4 = Segment(($A4, K4), ($A4, L4))
N5 = Segment(($A5, K5), ($A5, L5))
N6 = Segment(($A6, K6), ($A6, L6))
N7 = Segment(($A7, K7), ($A7, L7))
A38: 38
C38: C7 + C13 + C19 + C25 + C31 + C36
F38: F7 + F13 + F19 + F25 + F31 + F36
H38: $G$1 + (2 * sqrt((($G$1 * (1 - $G$1))) / F38))
I38: C38 / F38
G38: $G$1 - (2 * sqrt((($G$1 * (1 - $G$1))) / F38))
K38: $I38 - (2 * sqrt((($I38 * (1 - $I38))) / $F38))
L38: $I38 + (2 * sqrt((($I38 * (1 - $I38))) / $F38))
N38 = Segment((A38, K38), (A38, L38))
M38 = Segment(($A38, G38), ($A38, H38))
J34 = If(G34 ≤ I34 ≤ H34, 0, 1)
J35 = If(G35 ≤ I35 ≤ H35, 0, 1)
J36 = If(G36 ≤ I36 ≤ H36, 0, 1)
D36: 0
E36: 0