Author: Mag. Kurt Söser

Anzahl der Unfälle

absolute Häufigkeit

relative Häufigkeit

Balkendiagramm

SUMME

MITTELWERT

VARIANZ

Standardabweichung

kumuliert

kumuliert

Treppenfunktion

A2 = 0
A3 = 1
A4 = 2
A5 = 3
A6 = 4
A7 = 5
A8 = 6
A9 = 7
A10 = 8
A11 = 9
A12 = 10
A13 = 11
A14 = 12
A15 = 13
A16 = 14
A17 = 15
A18 = 16
A19 = 17
A20 = 18
A21 = 19
A22 = 20
B2 = 6
B3 = 17
B4 = 23
B5 = 20
B6 = 14
B7 = 9
B8 = 4
B9 = 1
B10 = 1
B11 = 1
B12 = 1
B13 = 1
B14 = 1
B15 = 0
B16 = 0
B17 = 0
B18 = 0
B19 = 1
B20 = 0
B21 = 0
B22 = 0
B23 = Sum(B2:B22)
C2: B2 / $B$23
C3: B3 / $B$23
C4: B4 / $B$23
C5: B5 / $B$23
C6: B6 / $B$23
C7: B7 / $B$23
C8: B8 / $B$23
C9: B9 / $B$23
C10: B10 / $B$23
C11: B11 / $B$23
C12: B12 / $B$23
C13: B13 / $B$23
C14: B14 / $B$23
C15: B15 / $B$23
C16: B16 / $B$23
C17: B17 / $B$23
C18: B18 / $B$23
C19: B19 / $B$23
C20: B20 / $B$23
C21: B21 / $B$23
C22: B22 / $B$23
L_1: {A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22}
L_2: {B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22}
b = false
E2: A2 * B2
E3: A3 * B3
E4: A4 * B4
E5: A5 * B5
E6: A6 * B6
E7: A7 * B7
E8: A8 * B8
E9: A9 * B9
E10: A10 * B10
E11: A11 * B11
E12: A12 * B12
E13: A13 * B13
E14: A14 * B14
E15: A15 * B15
E16: A16 * B16
E17: A17 * B17
E18: A18 * B18
E19: A19 * B19
E20: A20 * B20
E21: A21 * B21
E22: A22 * B22
C23 = Sum(C2:C22)
E23 = Sum(E2:E22)
B24: E23 / B23
F2: (A2 - $B$24)^(2.0) * B2
F3: (A3 - $B$24)^(2.0) * B3
F4: (A4 - $B$24)^(2.0) * B4
F5: (A5 - $B$24)^(2.0) * B5
F6: (A6 - $B$24)^(2.0) * B6
F7: (A7 - $B$24)^(2.0) * B7
F8: (A8 - $B$24)^(2.0) * B8
F9: (A9 - $B$24)^(2.0) * B9
F10: (A10 - $B$24)^(2.0) * B10
F11: (A11 - $B$24)^(2.0) * B11
F12: (A12 - $B$24)^(2.0) * B12
F13: (A13 - $B$24)^(2.0) * B13
F14: (A14 - $B$24)^(2.0) * B14
F15: (A15 - $B$24)^(2.0) * B15
F16: (A16 - $B$24)^(2.0) * B16
F17: (A17 - $B$24)^(2.0) * B17
F18: (A18 - $B$24)^(2.0) * B18
F19: (A19 - $B$24)^(2.0) * B19
F20: (A20 - $B$24)^(2.0) * B20
F21: (A21 - $B$24)^(2.0) * B21
F22: (A22 - $B$24)^(2.0) * B22
F23 = Sum(F2:F22)
B25: F23 / B23
B26: sqrt(B25)
L_3: {C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22}
Σ = BarChart(L_1, L_3)
P_3: (A4, C4)
P_1: (A2, C2)
P_2: (A3, C3)
P_4: (A5, C5)
P_5: (A6, C6)
P_6: (A7, C7)
P_7: (A8, C8)
P_8: (A9, C9)
P_9: (A10, C10)
P_{10}: (A11, C11)
P_{11}: (A12, C12)
P_{12}: (A13, C13)
P_{13}: (A14, C14)
P_{14}: (A15, C15)
P_{15}: (A16, C16)
P_{16}: (A17, C17)
P_{17}: (A18, C18)
P_{18}: (A19, C19)
P_{19}: (A20, C20)
P_{20}: (A21, C21)
P_{21}: (A22, C22)
p = 6.4E-4 (slider from 0 to 0.0010, step 1.0E-5)
n = 4500 (slider from 0 to 20000, step 10)
λ = 3.22
g(x) = (p * n)^(x) / x! * exp(-(p) * n)
D2: C2
D3: D2 + C3
D4: D3 + C4
D5: D4 + C5
D6: D5 + C6
D7: D6 + C7
D8: D7 + C8
D9: D8 + C9
D10: D9 + C10
D11: D10 + C11
D12: D11 + C12
D13: D12 + C13
D14: D13 + C14
D15: D14 + C15
D16: D15 + C16
D17: D16 + C17
D18: D17 + C18
D19: D18 + C19
D20: D19 + C20
D21: D20 + C21
D22: D21 + C22
L_4: {D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12, D13, D14, D15, D16, D17, D18, D19, D20, D21, D22}
Liste1 = Sequence((Element[L_1, k], Element[L_4, k]), k, 1.0, 20.0)
a = true
c = BarChart(L_1, L_4)
d = true