Pos

Summe

start

stop

reset

Konfidenzintervalle

Konfidenzintervall freirubbeln

Prognoseintervalle

kumuliert

jens

martina

andrea

wolfgang

adrian

annett

juliane

birgit

ute

anica

martin

ute

corinna

ronald

barbara

nicole

cathrin

andreas

lars

Ina

B3: 2
C3: 8
D3: 18
B4 = 3
C4: 23
D4: 6
B5 = 4
B6 = 5
C5: 17
D5: 22
C6: 15
D6: 20
B8 = 7
C8: 21
D8: 21
B9 = 8
C9: 19
D9: 23
B10 = 9
C10: 15
D10: 21
B11 = 10
C11: 15
D11: 19
B12 = 11
C12: 16
D12: 26
B13 = 12
C13: 20
D13: 24
B14 = 13
C14: 12
D14: 26
B15 = 14
C15: 13
D15: 21
B16 = 15
C16: 14
D16: 12
B17 = 16
C17: 16
D17: 21
B18 = 17
C18: 17
D18: 25
B7 = 6
C7: 20
D7: 23
I = Segment((0, 0), (0, 1))
p = 0.501 (slider from 0 to 1, step 0.001)
modell: (0, p)
n = CountIf(x > 0, CellRange(I2,I50,"numeric"))
f(x) = If[0 < x < n, p]
X = Sequence(i, i, 1, n)
auswahl: {"oben", "2+3", "4+5"}
d = SelectedIndex(auswahl)
rh = If(d ≟ 1, Sequence[(Cell[3, i] + Cell[4, i] + Cell[5, i]) / Cell[9, i], i, 2, n + 1], If[d ≟ 2, Sequence[(Cell[4, i] + Cell[5, i]) / Cell[9, i], i, 2, n + 1], Sequence[(Cell[6, i] + Cell[7, i]) / Cell[9, i], i, 2, n + 1]])
Datenpunkte: (X, rh)
N = Sequence(Cell[3, i] + Cell[4, i], i, 2, n + 1)
nummer = 0 (slider from 0 to n, step 1)
Q: (nummer, p)
PIu = Sequence(p - (2 * sqrt(((p * (1 - p))) / N(i))), i, 1, n)
PIo = Sequence(p + (2 * sqrt(((p * (1 - p))) / N(i))), i, 1, n)
imPI_{1} = Sequence(If[PIu(i) ≤ rh(i) ≤ PIo(i), true, false], i, 1, n)
Spur: (nummer, p)
KIu = Sequence((rh(i) + 2 / N(i) - (2 * sqrt(1 / (N(i))^(2) + (rh(i) * (1 - rh(i)) / N(i))))) / (1 + 4 / N(i)), i, 1, n)
KIo = Sequence((rh(i) + 2 / N(i) + (2 * sqrt(1 / (N(i))^(2) + (rh(i) * (1 - rh(i)) / N(i))))) / (1 + 4 / N(i)), i, 1, n)
KI = Sequence(Segment[(i, KIu(i)), (i, KIo(i))], i, 1, n)
kija = true
a = false
imPI = Sum(imPI_{1})
Text1 = LaTeX(imPI, true, true)
PI = Sequence(Segment[(i, Max[-1, PIu(i)]), (i, Min[2, PIo(i)])], i, 1, n)
D19: 21
D20: 18
D21: 28
D22: 21
D23: 0
D24: 0
D25: 0
D26: 0
D27: 0
D28: 0
D29: 0
D30: 0
D31: 0
D32: 0
D33: 0
D34: 0
D35: 0
D36: 0
D37: 0
D38: 0
D39: 0
D40: 0
C19: 13
C20: 23
C21: 22
C22: 15
C23: 0
C24: 0
C25: 0
C26: 0
C27: 0
C28: 0
C29: 0
C30: 0
C31: 0
C32: 0
C33: 0
C34: 0
C35: 0
C36: 0
C37: 0
C38: 0
C39: 0
C40: 0
B19 = 18
B20 = 19
B21 = 20
B22 = 21
B23 = 22
B24 = 23
B25 = 24
B26 = 25
B27 = 26
B28 = 27
B29 = 28
B30 = 29
B31 = 30
B32 = 31
B33 = 32
B34 = 33
B35 = 34
B36 = 35
B37 = 36
B38 = 37
B39 = 38
B40 = 39
M = Sum(CellRange(D2,D40,"numeric"))
L = Sum(CellRange(C2,C40,"numeric"))
Load: round(M / (L + M), 3)
b = false
C41: 0
D41: 0
B41 = 40
S11 = NaN
O = (0, 0)
B2: 1
C1: 1
D1: 2
E1 = 3
F1 = 4
G1 = 5
H1 = 6
I2 = Sum(CellRange(C2,H2,"numeric"))
H3: 5
I3 = Sum(CellRange(C3,H3,"numeric"))
H4: 13
I4 = Sum(CellRange(C4,H4,"numeric"))
H5: 23
I5 = Sum(CellRange(C5,H5,"numeric"))
H6: 19
I6 = Sum(CellRange(C6,H6,"numeric"))
H7: 14
I7 = Sum(CellRange(C7,H7,"numeric"))
H8: 15
I8 = Sum(CellRange(C8,H8,"numeric"))
H9: 22
I9 = Sum(CellRange(C9,H9,"numeric"))
H10: 18
I10 = Sum(CellRange(C10,H10,"numeric"))
H11: 20
I11 = Sum(CellRange(C11,H11,"numeric"))
H12: 18
I12 = Sum(CellRange(C12,H12,"numeric"))
H13: 16
I13 = Sum(CellRange(C13,H13,"numeric"))
H14: 16
I14 = Sum(CellRange(C14,H14,"numeric"))
H15: 25
I15 = Sum(CellRange(C15,H15,"numeric"))
H16: 30
I16 = Sum(CellRange(C16,H16,"numeric"))
H17: 14
I17 = Sum(CellRange(C17,H17,"numeric"))
H18: 17
I18 = Sum(CellRange(C18,H18,"numeric"))
H19: 19
I19 = Sum(CellRange(C19,H19,"numeric"))
H20: 13
I20 = Sum(CellRange(C20,H20,"numeric"))
H21: 15
I21 = Sum(CellRange(C21,H21,"numeric"))
H22: 19
I22 = Sum(CellRange(C22,H22,"numeric"))
H23: 0
I23 = Sum(CellRange(C23,H23,"numeric"))
H24: 0
I24 = Sum(CellRange(C24,H24,"numeric"))
H25: 0
I25 = Sum(CellRange(C25,H25,"numeric"))
H26: 0
I26 = Sum(CellRange(C26,H26,"numeric"))
H27: 0
I27 = Sum(CellRange(C27,H27,"numeric"))
H28: 0
I28 = Sum(CellRange(C28,H28,"numeric"))
H29: 0
I29 = Sum(CellRange(C29,H29,"numeric"))
H30: 0
I30 = Sum(CellRange(C30,H30,"numeric"))
H31: 0
I31 = Sum(CellRange(C31,H31,"numeric"))
H32: 0
I32 = Sum(CellRange(C32,H32,"numeric"))
H33: 0
I33 = Sum(CellRange(C33,H33,"numeric"))
H34: 0
I34 = Sum(CellRange(C34,H34,"numeric"))
H35: 0
I35 = Sum(CellRange(C35,H35,"numeric"))
H36: 0
I36 = Sum(CellRange(C36,H36,"numeric"))
H37: 0
I37 = Sum(CellRange(C37,H37,"numeric"))
H38: 0
I38 = Sum(CellRange(C38,H38,"numeric"))
H39: 0
I39 = Sum(CellRange(C39,H39,"numeric"))
H40: 0
I40 = Sum(CellRange(C40,H40,"numeric"))
H41: 0
I41 = Sum(CellRange(C41,H41,"numeric"))
E3: 3
F3: 14
G3: 4
E4: 15
F4: 15
G4: 18
E5: 8
F5: 18
G5: 12
E6: 10
F6: 28
G6: 13
E7: 8
F7: 26
G7: 9
E8: 15
F8: 11
G8: 16
E9: 7
F9: 20
G9: 9
E10: 15
F10: 19
G10: 12
E11: 15
F11: 34
G11: 11
E12: 26
F12: 8
G12: 6
E13: 16
F13: 18
G13: 6
E14: 11
F14: 25
G14: 10
E15: 9
F15: 23
G15: 9
E16: 9
F16: 19
G16: 15
E17: 16
F17: 22
G17: 7
E18: 7
F18: 25
G18: 9
E19: 12
F19: 32
G19: 3
E20: 10
F20: 28
G20: 8
E21: 13
F21: 14
G21: 8
E22: 11
F22: 20
G22: 15
E23: 0
F23: 0
G23: 0
E24: 0
F24: 0
G24: 0
E25: 0
F25: 0
G25: 0
E26: 0
F26: 0
G26: 0
E27: 0
F27: 0
G27: 0
E28: 0
F28: 0
G28: 0
E29: 0
F29: 0
G29: 0
E30: 0
F30: 0
G30: 0
E31: 0
F31: 0
G31: 0
E32: 0
F32: 0
G32: 0
E33: 0
F33: 0
G33: 0
E34: 0
F34: 0
G34: 0
E35: 0
F35: 0
G35: 0
E36: 0
F36: 0
G36: 0
E37: 0
F37: 0
G37: 0
E38: 0
F38: 0
G38: 0
E39: 0
F39: 0
G39: 0
E40: 0
F40: 0
G40: 0
E41: 0
F41: 0
G41: 0
C2 = Sum(CellRange(C3,C41,"numeric"))
D2 = Sum(CellRange(D3,D41,"numeric"))
E2 = Sum(CellRange(E3,E41,"numeric"))
F2 = Sum(CellRange(F3,F41,"numeric"))
G2 = Sum(CellRange(G3,G41,"numeric"))
H2 = Sum(CellRange(H3,H41,"numeric"))
A = (25, 1.4)
UL: (-1, 0)
UR: (1, 0)
Vieleck1, g, h, i, j, k, l, B, C, D, E = Polygon(UL, UR, 6)
e = Circle(UL, UR, B)
m = Segment(UR, D)
q = Segment(C, UL)
r = Segment(E, B)
h_1: round(C2 / I2, 4)
h_2: round(D2 / I2, 4)
h_3: round(E2 / I2, 4)
h_4: round(F2 / I2, 4)
h_5: round(G2 / I2, 4)
h_6: round(H2 / I2, 4)
Text3: "" + h_1 + ""
Text4: "" + h_2 + ""
Text5: "" + h_3 + ""
Text6: "" + h_4 + ""
Text7: "" + h_5 + ""
Text8: "" + h_6 + ""
F = Intersect(m, q)
c = CircleSector(F, B, E)
s = CircleSector(F, D, E)
t = CircleSector(F, B, C)
c_1 = CircleSector(F, E, UL)
d_1 = CircleSector(F, UR, B)