cm

gut

noch ok

schlecht

sehr schlecht

t: chi^2

Yusof re

Yusof li

Felix re

Felix li

Julia re

Julia li

Anna re

Anna li

Lea re

Lea li

Catherin re

Catherin li

Paul re

Paul li

Anne li

Anne re

Dominik re

Dominik li

Stefanie re

Stefanie li

Lukas re

Lukas li

Luise re

Luise li

Antonia re

Antonia re

Anna Z. re

Anna Z. li

s:Σ|h_i-20|

u: max(h_i)-min(h_i)

g: max(|h_i-20|)

a: Ausreisser

#s

#t

#u

#g

#a

C1: 1
D1: 2
E1: 3
F1: 4
G1: 5
H1: 6
B2: 16.5
C2: 37
D2: 42
E2: 15
F2: 9
G2: 12
H2: 5
I2: 120
B3: 16.5
C3: 23
D3: 20
E3: 18
F3: 21
G3: 15
H3: 23
I3: 120
B4: 16.7
C4: 18
D4: 21
E4: 26
F4: 17
G4: 11
H4: 27
I4: 120
B5: 16.7
C5: 22
D5: 13
E5: 22
F5: 23
G5: 15
H5: 25
I5: 120
B6: 14.2
C6: 21
D6: 22
E6: 10
F6: 9
G6: 31
H6: 27
I6: 120
B7: 14.2
C7: 18
D7: 23
E7: 24
F7: 18
G7: 17
H7: 20
I7: 120
B8: 12.7
C8: 4
D8: 18
E8: 45
F8: 1
G8: 29
H8: 23
I8: 120
B9: 12.7
C9: 33
D9: 9
E9: 22
F9: 7
G9: 11
H9: 38
I9: 120
B10: 11.8
C10: 0
D10: 33
E10: 24
F10: 9
G10: 19
H10: 35
I10: 120
B11: 11.8
C11: 28
D11: 50
E11: 38
F11: 0
G11: 0
H11: 4
I11: 120
B12: 18.8
C12: 15
D12: 17
E12: 8
F12: 20
G12: 17
H12: 43
I12: 120
B13: 18.8
C13: 14
D13: 7
E13: 16
F13: 7
G13: 30
H13: 46
I13: 120
B14: 16.5
C14: 32
D14: 26
E14: 14
F14: 36
G14: 5
H14: 7
I14: 120
B15: 16.5
C15: 30
D15: 21
E15: 17
F15: 26
G15: 19
H15: 7
I15: 120
B16: 16.5
C16: 24
D16: 15
E16: 13
F16: 19
G16: 27
H16: 22
I16: 120
B17: 16.5
C17: 33
D17: 30
E17: 20
F17: 13
G17: 13
H17: 11
I17: 120
B18: 17.1
C18: 1
D18: 26
E18: 39
F18: 7
G18: 22
H18: 25
I18: 120
B19: 17.1
C19: 16
D19: 22
E19: 21
F19: 49
G19: 6
H19: 6
I19: 120
B20: 17
C20: 37
D20: 35
E20: 23
F20: 13
G20: 5
H20: 7
I20: 120
B21: 17
C21: 5
D21: 1
E21: 2
F21: 88
G21: 15
H21: 9
I21: 120
B22: 15.6
C22: 16
D22: 27
E22: 20
F22: 20
G22: 17
H22: 19
I22: 120
B23: 15.6
C23: 22
D23: 14
E23: 23
F23: 18
G23: 25
H23: 18
I23: 120
B24: 16.2
C24: 14
D24: 40
E24: 35
F24: 5
G24: 4
H24: 22
I24: 120
B25: 16.2
C25: 30
D25: 19
E25: 14
F25: 42
G25: 14
H25: 1
I25: 120
B26: 13.5
C26: 7
D26: 5
E26: 16
F26: 30
G26: 31
H26: 31
I26: 120
B27: 13.5
C27: 37
D27: 9
E27: 13
F27: 27
G27: 10
H27: 24
I27: 120
B28: 18.1
C28: 16
D28: 24
E28: 31
F28: 18
G28: 4
H28: 27
I28: 120
B29: 18.1
C29: 18
D29: 23
E29: 20
F29: 17
G29: 9
H29: 33
I29: 120
L2: 1
J3: 1
K4: 1
J5: 1
L6: 1
J7: 1
M8: 1
M9: 1
L10: 1
M11: 1
L12: 1
L13: 1
L14: 1
L15: 1
K16: 1
L17: 1
L18: 1
L19: 1
L20: 1
M21: 1
K22: 1
K23: 1
L24: 1
L25: 1
M26: 1
L27: 1
M28: 1
L29: 1
P3: Sum[(C3:H3 - 20)^(2)] / 20
P4: Sum[(C4:H4 - 20)^(2)] / 20
P5: Sum[(C5:H5 - 20)^(2)] / 20
P6: Sum[(C6:H6 - 20)^(2)] / 20
P7: Sum[(C7:H7 - 20)^(2)] / 20
P8: Sum[(C8:H8 - 20)^(2)] / 20
P9: Sum[(C9:H9 - 20)^(2)] / 20
P10: Sum[(C10:H10 - 20)^(2)] / 20
P11: Sum[(C11:H11 - 20)^(2)] / 20
P12: Sum[(C12:H12 - 20)^(2)] / 20
P13: Sum[(C13:H13 - 20)^(2)] / 20
P14: Sum[(C14:H14 - 20)^(2)] / 20
P15: Sum[(C15:H15 - 20)^(2)] / 20
P16: Sum[(C16:H16 - 20)^(2)] / 20
P17: Sum[(C17:H17 - 20)^(2)] / 20
P18: Sum[(C18:H18 - 20)^(2)] / 20
P19: Sum[(C19:H19 - 20)^(2)] / 20
P20: Sum[(C20:H20 - 20)^(2)] / 20
P21: Sum[(C21:H21 - 20)^(2)] / 20
P22: Sum[(C22:H22 - 20)^(2)] / 20
P23: Sum[(C23:H23 - 20)^(2)] / 20
P24: Sum[(C24:H24 - 20)^(2)] / 20
P25: Sum[(C25:H25 - 20)^(2)] / 20
P26: Sum[(C26:H26 - 20)^(2)] / 20
P27: Sum[(C27:H27 - 20)^(2)] / 20
P28: Sum[(C28:H28 - 20)^(2)] / 20
P29: Sum[(C29:H29 - 20)^(2)] / 20
O2 = Sum(abs(C2:H2 - 20))
O3 = Sum(abs(C3:H3 - 20))
O4 = Sum(abs(C4:H4 - 20))
O5 = Sum(abs(C5:H5 - 20))
O6 = Sum(abs(C6:H6 - 20))
O7 = Sum(abs(C7:H7 - 20))
O8 = Sum(abs(C8:H8 - 20))
O9 = Sum(abs(C9:H9 - 20))
O10 = Sum(abs(C10:H10 - 20))
O11 = Sum(abs(C11:H11 - 20))
O12 = Sum(abs(C12:H12 - 20))
O13 = Sum(abs(C13:H13 - 20))
O14 = Sum(abs(C14:H14 - 20))
O15 = Sum(abs(C15:H15 - 20))
O16 = Sum(abs(C16:H16 - 20))
O17 = Sum(abs(C17:H17 - 20))
O18 = Sum(abs(C18:H18 - 20))
O19 = Sum(abs(C19:H19 - 20))
O20 = Sum(abs(C20:H20 - 20))
O21 = Sum(abs(C21:H21 - 20))
O22 = Sum(abs(C22:H22 - 20))
O23 = Sum(abs(C23:H23 - 20))
O24 = Sum(abs(C24:H24 - 20))
O25 = Sum(abs(C25:H25 - 20))
O26 = Sum(abs(C26:H26 - 20))
O27 = Sum(abs(C27:H27 - 20))
O28 = Sum(abs(C28:H28 - 20))
O29 = Sum(abs(C29:H29 - 20))
Q2: Max[C2:H2] - Min[C2:H2]
Q3: Max[C3:H3] - Min[C3:H3]
Q4: Max[C4:H4] - Min[C4:H4]
Q5: Max[C5:H5] - Min[C5:H5]
Q6: Max[C6:H6] - Min[C6:H6]
Q7: Max[C7:H7] - Min[C7:H7]
Q8: Max[C8:H8] - Min[C8:H8]
Q9: Max[C9:H9] - Min[C9:H9]
Q10: Max[C10:H10] - Min[C10:H10]
Q11: Max[C11:H11] - Min[C11:H11]
Q12: Max[C12:H12] - Min[C12:H12]
Q13: Max[C13:H13] - Min[C13:H13]
Q14: Max[C14:H14] - Min[C14:H14]
Q15: Max[C15:H15] - Min[C15:H15]
Q16: Max[C16:H16] - Min[C16:H16]
Q17: Max[C17:H17] - Min[C17:H17]
Q18: Max[C18:H18] - Min[C18:H18]
Q19: Max[C19:H19] - Min[C19:H19]
Q20: Max[C20:H20] - Min[C20:H20]
Q21: Max[C21:H21] - Min[C21:H21]
Q22: Max[C22:H22] - Min[C22:H22]
Q23: Max[C23:H23] - Min[C23:H23]
Q24: Max[C24:H24] - Min[C24:H24]
Q25: Max[C25:H25] - Min[C25:H25]
Q26: Max[C26:H26] - Min[C26:H26]
Q27: Max[C27:H27] - Min[C27:H27]
Q28: Max[C28:H28] - Min[C28:H28]
Q29: Max[C29:H29] - Min[C29:H29]
R2 = Max(abs(C2:H2 - 20))
R3 = Max(abs(C3:H3 - 20))
R4 = Max(abs(C4:H4 - 20))
R5 = Max(abs(C5:H5 - 20))
R6 = Max(abs(C6:H6 - 20))
R7 = Max(abs(C7:H7 - 20))
R8 = Max(abs(C8:H8 - 20))
R9 = Max(abs(C9:H9 - 20))
R10 = Max(abs(C10:H10 - 20))
R11 = Max(abs(C11:H11 - 20))
R12 = Max(abs(C12:H12 - 20))
R13 = Max(abs(C13:H13 - 20))
R14 = Max(abs(C14:H14 - 20))
R15 = Max(abs(C15:H15 - 20))
R16 = Max(abs(C16:H16 - 20))
R17 = Max(abs(C17:H17 - 20))
R18 = Max(abs(C18:H18 - 20))
R19 = Max(abs(C19:H19 - 20))
R20 = Max(abs(C20:H20 - 20))
R21 = Max(abs(C21:H21 - 20))
R22 = Max(abs(C22:H22 - 20))
R23 = Max(abs(C23:H23 - 20))
R24 = Max(abs(C24:H24 - 20))
R25 = Max(abs(C25:H25 - 20))
R26 = Max(abs(C26:H26 - 20))
R27 = Max(abs(C27:H27 - 20))
R28 = Max(abs(C28:H28 - 20))
R29 = Max(abs(C29:H29 - 20))
P2: Sum[(C2:H2 - 20)^(2)] / 20
S2: Sum[C2:H2 > 29] + Sum[C2:H2 < 11]
S4: Sum[C4:H4 > 29] + Sum[C4:H4 < 11]
S6: Sum[C6:H6 > 29] + Sum[C6:H6 < 11]
S8: Sum[C8:H8 > 29] + Sum[C8:H8 < 11]
S9: Sum[C9:H9 > 29] + Sum[C9:H9 < 11]
S10: Sum[C10:H10 > 29] + Sum[C10:H10 < 11]
S11: Sum[C11:H11 > 29] + Sum[C11:H11 < 11]
S12: Sum[C12:H12 > 29] + Sum[C12:H12 < 11]
S13: Sum[C13:H13 > 29] + Sum[C13:H13 < 11]
S14: Sum[C14:H14 > 29] + Sum[C14:H14 < 11]
S15: Sum[C15:H15 > 29] + Sum[C15:H15 < 11]
S16: Sum[C16:H16 > 29] + Sum[C16:H16 < 11]
S17: Sum[C17:H17 > 29] + Sum[C17:H17 < 11]
S18: Sum[C18:H18 > 29] + Sum[C18:H18 < 11]
S19: Sum[C19:H19 > 29] + Sum[C19:H19 < 11]
S20: Sum[C20:H20 > 29] + Sum[C20:H20 < 11]
S21: Sum[C21:H21 > 29] + Sum[C21:H21 < 11]
S22: Sum[C22:H22 > 29] + Sum[C22:H22 < 11]
S23: Sum[C23:H23 > 29] + Sum[C23:H23 < 11]
S24: Sum[C24:H24 > 29] + Sum[C24:H24 < 11]
S25: Sum[C25:H25 > 29] + Sum[C25:H25 < 11]
S26: Sum[C26:H26 > 29] + Sum[C26:H26 < 11]
S27: Sum[C27:H27 > 29] + Sum[C27:H27 < 11]
S28: Sum[C28:H28 > 29] + Sum[C28:H28 < 11]
S29: Sum[C29:H29 > 29] + Sum[C29:H29 < 11]
S3: Sum[C3:H3 > 29] + Sum[C3:H3 < 11]
S5: Sum[C5:H5 > 29] + Sum[C5:H5 < 11]
S7: Sum[C7:H7 > 29] + Sum[C7:H7 < 11]
T2 = CountIf(x ≤ Q2, Q$2:Q$29)
T3 = CountIf(x ≤ Q3, Q$2:Q$29)
T4 = CountIf(x ≤ Q4, Q$2:Q$29)
T5 = CountIf(x ≤ Q5, Q$2:Q$29)
T6 = CountIf(x ≤ Q6, Q$2:Q$29)
T7 = CountIf(x ≤ Q7, Q$2:Q$29)
T8 = CountIf(x ≤ Q8, Q$2:Q$29)
T9 = CountIf(x ≤ Q9, Q$2:Q$29)
T10 = CountIf(x ≤ Q10, Q$2:Q$29)
T11 = CountIf(x ≤ Q11, Q$2:Q$29)
T12 = CountIf(x ≤ Q12, Q$2:Q$29)
T13 = CountIf(x ≤ Q13, Q$2:Q$29)
T14 = CountIf(x ≤ Q14, Q$2:Q$29)
T15 = CountIf(x ≤ Q15, Q$2:Q$29)
T16 = CountIf(x ≤ Q16, Q$2:Q$29)
T17 = CountIf(x ≤ Q17, Q$2:Q$29)
T18 = CountIf(x ≤ Q18, Q$2:Q$29)
T19 = CountIf(x ≤ Q19, Q$2:Q$29)
T20 = CountIf(x ≤ Q20, Q$2:Q$29)
T21 = CountIf(x ≤ Q21, Q$2:Q$29)
T22 = CountIf(x ≤ Q22, Q$2:Q$29)
T23 = CountIf(x ≤ Q23, Q$2:Q$29)
T24 = CountIf(x ≤ Q24, Q$2:Q$29)
T25 = CountIf(x ≤ Q25, Q$2:Q$29)
T26 = CountIf(x ≤ Q26, Q$2:Q$29)
T27 = CountIf(x ≤ Q27, Q$2:Q$29)
T28 = CountIf(x ≤ Q28, Q$2:Q$29)
T29 = CountIf(x ≤ Q29, Q$2:Q$29)
U2 = CountIf(x ≤ R2, R$2:R$29)
U3 = CountIf(x ≤ R3, R$2:R$29)
U4 = CountIf(x ≤ R4, R$2:R$29)
U5 = CountIf(x ≤ R5, R$2:R$29)
U6 = CountIf(x ≤ R6, R$2:R$29)
U7 = CountIf(x ≤ R7, R$2:R$29)
U8 = CountIf(x ≤ R8, R$2:R$29)
U9 = CountIf(x ≤ R9, R$2:R$29)
U10 = CountIf(x ≤ R10, R$2:R$29)
U11 = CountIf(x ≤ R11, R$2:R$29)
U12 = CountIf(x ≤ R12, R$2:R$29)
U13 = CountIf(x ≤ R13, R$2:R$29)
U14 = CountIf(x ≤ R14, R$2:R$29)
U15 = CountIf(x ≤ R15, R$2:R$29)
U16 = CountIf(x ≤ R16, R$2:R$29)
U17 = CountIf(x ≤ R17, R$2:R$29)
U18 = CountIf(x ≤ R18, R$2:R$29)
U19 = CountIf(x ≤ R19, R$2:R$29)
U20 = CountIf(x ≤ R20, R$2:R$29)
U21 = CountIf(x ≤ R21, R$2:R$29)
U22 = CountIf(x ≤ R22, R$2:R$29)
U23 = CountIf(x ≤ R23, R$2:R$29)
U24 = CountIf(x ≤ R24, R$2:R$29)
U25 = CountIf(x ≤ R25, R$2:R$29)
U26 = CountIf(x ≤ R26, R$2:R$29)
U27 = CountIf(x ≤ R27, R$2:R$29)
U28 = CountIf(x ≤ R28, R$2:R$29)
U29 = CountIf(x ≤ R29, R$2:R$29)
V2 = CountIf(x ≤ S2, S$2:S$29)
W2 = CountIf(x ≤ T2, T$2:T$29)
X2 = CountIf(x ≤ U2, U$2:U$29)
V3 = CountIf(x ≤ S3, S$2:S$29)
W3 = CountIf(x ≤ T3, T$2:T$29)
X3 = CountIf(x ≤ U3, U$2:U$29)
V4 = CountIf(x ≤ S4, S$2:S$29)
W4 = CountIf(x ≤ T4, T$2:T$29)
X4 = CountIf(x ≤ U4, U$2:U$29)
V5 = CountIf(x ≤ S5, S$2:S$29)
W5 = CountIf(x ≤ T5, T$2:T$29)
X5 = CountIf(x ≤ U5, U$2:U$29)
V6 = CountIf(x ≤ S6, S$2:S$29)
W6 = CountIf(x ≤ T6, T$2:T$29)
X6 = CountIf(x ≤ U6, U$2:U$29)
V7 = CountIf(x ≤ S7, S$2:S$29)
W7 = CountIf(x ≤ T7, T$2:T$29)
X7 = CountIf(x ≤ U7, U$2:U$29)
V8 = CountIf(x ≤ S8, S$2:S$29)
W8 = CountIf(x ≤ T8, T$2:T$29)
X8 = CountIf(x ≤ U8, U$2:U$29)
V9 = CountIf(x ≤ S9, S$2:S$29)
W9 = CountIf(x ≤ T9, T$2:T$29)
X9 = CountIf(x ≤ U9, U$2:U$29)
V10 = CountIf(x ≤ S10, S$2:S$29)
W10 = CountIf(x ≤ T10, T$2:T$29)
X10 = CountIf(x ≤ U10, U$2:U$29)
V11 = CountIf(x ≤ S11, S$2:S$29)
W11 = CountIf(x ≤ T11, T$2:T$29)
X11 = CountIf(x ≤ U11, U$2:U$29)
V12 = CountIf(x ≤ S12, S$2:S$29)
W12 = CountIf(x ≤ T12, T$2:T$29)
X12 = CountIf(x ≤ U12, U$2:U$29)
V13 = CountIf(x ≤ S13, S$2:S$29)
W13 = CountIf(x ≤ T13, T$2:T$29)
X13 = CountIf(x ≤ U13, U$2:U$29)
V14 = CountIf(x ≤ S14, S$2:S$29)
W14 = CountIf(x ≤ T14, T$2:T$29)
X14 = CountIf(x ≤ U14, U$2:U$29)
V15 = CountIf(x ≤ S15, S$2:S$29)
W15 = CountIf(x ≤ T15, T$2:T$29)
X15 = CountIf(x ≤ U15, U$2:U$29)
V16 = CountIf(x ≤ S16, S$2:S$29)
W16 = CountIf(x ≤ T16, T$2:T$29)
X16 = CountIf(x ≤ U16, U$2:U$29)
V17 = CountIf(x ≤ S17, S$2:S$29)
W17 = CountIf(x ≤ T17, T$2:T$29)
X17 = CountIf(x ≤ U17, U$2:U$29)
V18 = CountIf(x ≤ S18, S$2:S$29)
W18 = CountIf(x ≤ T18, T$2:T$29)
X18 = CountIf(x ≤ U18, U$2:U$29)
V19 = CountIf(x ≤ S19, S$2:S$29)
W19 = CountIf(x ≤ T19, T$2:T$29)
X19 = CountIf(x ≤ U19, U$2:U$29)
V20 = CountIf(x ≤ S20, S$2:S$29)
W20 = CountIf(x ≤ T20, T$2:T$29)
X20 = CountIf(x ≤ U20, U$2:U$29)
V21 = CountIf(x ≤ S21, S$2:S$29)
W21 = CountIf(x ≤ T21, T$2:T$29)
X21 = CountIf(x ≤ U21, U$2:U$29)
V22 = CountIf(x ≤ S22, S$2:S$29)
W22 = CountIf(x ≤ T22, T$2:T$29)
X22 = CountIf(x ≤ U22, U$2:U$29)
V23 = CountIf(x ≤ S23, S$2:S$29)
W23 = CountIf(x ≤ T23, T$2:T$29)
X23 = CountIf(x ≤ U23, U$2:U$29)
V24 = CountIf(x ≤ S24, S$2:S$29)
W24 = CountIf(x ≤ T24, T$2:T$29)
X24 = CountIf(x ≤ U24, U$2:U$29)
V25 = CountIf(x ≤ S25, S$2:S$29)
W25 = CountIf(x ≤ T25, T$2:T$29)
X25 = CountIf(x ≤ U25, U$2:U$29)
V26 = CountIf(x ≤ S26, S$2:S$29)
W26 = CountIf(x ≤ T26, T$2:T$29)
X26 = CountIf(x ≤ U26, U$2:U$29)
V27 = CountIf(x ≤ S27, S$2:S$29)
W27 = CountIf(x ≤ T27, T$2:T$29)
X27 = CountIf(x ≤ U27, U$2:U$29)
V28 = CountIf(x ≤ S28, S$2:S$29)
W28 = CountIf(x ≤ T28, T$2:T$29)
X28 = CountIf(x ≤ U28, U$2:U$29)
V29 = CountIf(x ≤ S29, S$2:S$29)
W29 = CountIf(x ≤ T29, T$2:T$29)
X29 = CountIf(x ≤ U29, U$2:U$29)