x_{quer}

s_n

s_{n-1}

s_{n}²

s_{n-1}²

im Mittel

σ²=

σ=

x_i

p_i

μ=

B4: 0
C4: 0
D4: 0
D5: 1
D6: 2
D7: 0
D8: 1
D9: 2
D10: 0
D11: 1
D12: 2
D13: 0
D14: 1
D15: 2
D16: 0
D17: 1
D18: 2
D19: 0
D20: 1
D21: 2
D22: 0
D23: 1
D24: 2
D25: 0
D26: 1
D27: 2
D28: 0
D29: 1
D30: 2
C5: 0
C6: 0
C7: 1
C8: 1
C9: 1
C10: 2
C11: 2
C12: 2
C13: 0
C14: 0
C15: 0
C16: 1
C17: 1
C18: 1
C19: 2
C20: 2
C21: 2
C22: 0
C23: 0
C24: 0
C25: 1
C26: 1
C27: 1
C28: 2
C29: 2
C30: 2
B5: 0
B6: 0
B7: 0
B8: 0
B9: 0
B10: 0
B11: 0
B12: 0
B13: 1
B14: 1
B15: 1
B16: 1
B17: 1
B18: 1
B19: 1
B20: 1
B21: 1
B22: 2
B23: 2
B24: 2
B25: 2
B26: 2
B27: 2
B28: 2
B29: 2
B30: 2
F4 = mean(B4:D4)
G4 = stdevp(B4:D4)
H4 = stdev(B4:D4)
F5 = mean(B5:D5)
G5 = stdevp(B5:D5)
H5 = stdev(B5:D5)
F6 = mean(B6:D6)
G6 = stdevp(B6:D6)
H6 = stdev(B6:D6)
F7 = mean(B7:D7)
G7 = stdevp(B7:D7)
H7 = stdev(B7:D7)
F8 = mean(B8:D8)
G8 = stdevp(B8:D8)
H8 = stdev(B8:D8)
F9 = mean(B9:D9)
G9 = stdevp(B9:D9)
H9 = stdev(B9:D9)
F10 = mean(B10:D10)
G10 = stdevp(B10:D10)
H10 = stdev(B10:D10)
F11 = mean(B11:D11)
G11 = stdevp(B11:D11)
H11 = stdev(B11:D11)
F12 = mean(B12:D12)
G12 = stdevp(B12:D12)
H12 = stdev(B12:D12)
F13 = mean(B13:D13)
G13 = stdevp(B13:D13)
H13 = stdev(B13:D13)
F14 = mean(B14:D14)
G14 = stdevp(B14:D14)
H14 = stdev(B14:D14)
F15 = mean(B15:D15)
G15 = stdevp(B15:D15)
H15 = stdev(B15:D15)
F16 = mean(B16:D16)
G16 = stdevp(B16:D16)
H16 = stdev(B16:D16)
F17 = mean(B17:D17)
G17 = stdevp(B17:D17)
H17 = stdev(B17:D17)
F18 = mean(B18:D18)
G18 = stdevp(B18:D18)
H18 = stdev(B18:D18)
F19 = mean(B19:D19)
G19 = stdevp(B19:D19)
H19 = stdev(B19:D19)
F20 = mean(B20:D20)
G20 = stdevp(B20:D20)
H20 = stdev(B20:D20)
F21 = mean(B21:D21)
G21 = stdevp(B21:D21)
H21 = stdev(B21:D21)
F22 = mean(B22:D22)
G22 = stdevp(B22:D22)
H22 = stdev(B22:D22)
F23 = mean(B23:D23)
G23 = stdevp(B23:D23)
H23 = stdev(B23:D23)
F24 = mean(B24:D24)
G24 = stdevp(B24:D24)
H24 = stdev(B24:D24)
F25 = mean(B25:D25)
G25 = stdevp(B25:D25)
H25 = stdev(B25:D25)
F26 = mean(B26:D26)
G26 = stdevp(B26:D26)
H26 = stdev(B26:D26)
F27 = mean(B27:D27)
G27 = stdevp(B27:D27)
H27 = stdev(B27:D27)
F28 = mean(B28:D28)
G28 = stdevp(B28:D28)
H28 = stdev(B28:D28)
F29 = mean(B29:D29)
G29 = stdevp(B29:D29)
H29 = stdev(B29:D29)
F30 = mean(B30:D30)
G30 = stdevp(B30:D30)
H30 = stdev(B30:D30)
G2 = Sum(($E4:$E30 * G4:G30))
H2 = Sum(($E4:$E30 * H4:H30))
I4: G4^(2)
J4: H4^(2)
I5: G5^(2)
J5: H5^(2)
I6: G6^(2)
J6: H6^(2)
I7: G7^(2)
J7: H7^(2)
I8: G8^(2)
J8: H8^(2)
I9: G9^(2)
J9: H9^(2)
I10: G10^(2)
J10: H10^(2)
I11: G11^(2)
J11: H11^(2)
I12: G12^(2)
J12: H12^(2)
I13: G13^(2)
J13: H13^(2)
I14: G14^(2)
J14: H14^(2)
I15: G15^(2)
J15: H15^(2)
I16: G16^(2)
J16: H16^(2)
I17: G17^(2)
J17: H17^(2)
I18: G18^(2)
J18: H18^(2)
I19: G19^(2)
J19: H19^(2)
I20: G20^(2)
J20: H20^(2)
I21: G21^(2)
J21: H21^(2)
I22: G22^(2)
J22: H22^(2)
I23: G23^(2)
J23: H23^(2)
I24: G24^(2)
J24: H24^(2)
I25: G25^(2)
J25: H25^(2)
I26: G26^(2)
J26: H26^(2)
I27: G27^(2)
J27: H27^(2)
I28: G28^(2)
J28: H28^(2)
I29: G29^(2)
J29: H29^(2)
I30: G30^(2)
J30: H30^(2)
I2 = Sum(($E4:$E30 * I4:I30))
J2 = Sum(($E4:$E30 * J4:J30))
A4: 1
A5: 2
A6 = 3
A7 = 4
A8 = 5
A9 = 6
A10 = 7
A11 = 8
A12 = 9
A13 = 10
A14 = 11
A15 = 12
A16 = 13
A17 = 14
A18 = 15
A19 = 16
A20 = 17
A21 = 18
A22 = 19
A23 = 20
A24 = 21
A25 = 22
A26 = 23
A27 = 24
A28 = 25
A29 = 26
A30 = 27
B1: 0
C1: 1
D1: 2
B2: 1 / 4
C2: 1 / 2
p: B2:D2
E4: ((Element[p, B4 + 1] * Element[p, C4 + 1]) * Element[p, D4 + 1])
E5: ((Element[p, B5 + 1] * Element[p, C5 + 1]) * Element[p, D5 + 1])
E6: ((Element[p, B6 + 1] * Element[p, C6 + 1]) * Element[p, D6 + 1])
E7: ((Element[p, B7 + 1] * Element[p, C7 + 1]) * Element[p, D7 + 1])
E8: ((Element[p, B8 + 1] * Element[p, C8 + 1]) * Element[p, D8 + 1])
E9: ((Element[p, B9 + 1] * Element[p, C9 + 1]) * Element[p, D9 + 1])
E10: ((Element[p, B10 + 1] * Element[p, C10 + 1]) * Element[p, D10 + 1])
E11: ((Element[p, B11 + 1] * Element[p, C11 + 1]) * Element[p, D11 + 1])
E12: ((Element[p, B12 + 1] * Element[p, C12 + 1]) * Element[p, D12 + 1])
E13: ((Element[p, B13 + 1] * Element[p, C13 + 1]) * Element[p, D13 + 1])
E14: ((Element[p, B14 + 1] * Element[p, C14 + 1]) * Element[p, D14 + 1])
E15: ((Element[p, B15 + 1] * Element[p, C15 + 1]) * Element[p, D15 + 1])
E16: ((Element[p, B16 + 1] * Element[p, C16 + 1]) * Element[p, D16 + 1])
E17: ((Element[p, B17 + 1] * Element[p, C17 + 1]) * Element[p, D17 + 1])
E18: ((Element[p, B18 + 1] * Element[p, C18 + 1]) * Element[p, D18 + 1])
E19: ((Element[p, B19 + 1] * Element[p, C19 + 1]) * Element[p, D19 + 1])
E20: ((Element[p, B20 + 1] * Element[p, C20 + 1]) * Element[p, D20 + 1])
E21: ((Element[p, B21 + 1] * Element[p, C21 + 1]) * Element[p, D21 + 1])
E22: ((Element[p, B22 + 1] * Element[p, C22 + 1]) * Element[p, D22 + 1])
E23: ((Element[p, B23 + 1] * Element[p, C23 + 1]) * Element[p, D23 + 1])
E24: ((Element[p, B24 + 1] * Element[p, C24 + 1]) * Element[p, D24 + 1])
E25: ((Element[p, B25 + 1] * Element[p, C25 + 1]) * Element[p, D25 + 1])
E26: ((Element[p, B26 + 1] * Element[p, C26 + 1]) * Element[p, D26 + 1])
E27: ((Element[p, B27 + 1] * Element[p, C27 + 1]) * Element[p, D27 + 1])
E28: ((Element[p, B28 + 1] * Element[p, C28 + 1]) * Element[p, D28 + 1])
E29: ((Element[p, B29 + 1] * Element[p, C29 + 1]) * Element[p, D29 + 1])
E30: ((Element[p, B30 + 1] * Element[p, C30 + 1]) * Element[p, D30 + 1])
H1 = stdevp(B1:D1, p)
J1: H1^(2)
F1 = mean(B1:D1, p)
F2 = Sum(($E4:$E30 * F4:F30))
D2: 1 - B2 - C2