Anzahl der Unfälle

absolute Häufigkeit

relative Häufigkeit

Balkendiagramm

SUMME

MITTELWERT

VARIANZ

Standardabweichung

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
P_1: (A2, B2)
P_2: (A3, B3)
P_3: (A4, B4)
P_4: (A5, B5)
P_5: (A6, B6)
P_6: (A7, B7)
P_7: (A8, B8)
P_8: (A9, B9)
P_9: (A10, B10)
P_{10}: (A11, B11)
P_{11}: (A12, B12)
P_{12}: (A13, B13)
P_{13}: (A14, B14)
P_{14}: (A15, B15)
P_{15}: (A16, B16)
P_{16}: (A17, B17)
P_{17}: (A18, B18)
P_{18}: (A19, B19)
P_{19}: (A20, B20)
P_{20}: (A21, B21)
P_{21}: (A22, B22)
Liste1: {P_1, P_2, P_3, P_4, P_5, P_6, P_7, P_8, P_9, P_{10}, P_{11}, P_{12}, P_{13}, P_{14}, P_{15}, P_{16}, P_{17}, P_{18}, P_{19}, P_{20}, P_{21}}
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}
n = BarChart(L_1, L_2)
b = true
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)