hh

Ilmenau

köln

mz

E2: random()
E3: random()
E4: random()
E5: random()
E6: random()
E7: random()
E8: random()
E9: random()
E10: random()
E11: random()
E12: random()
E13: random()
E14: random()
E15: random()
E16: random()
E17: random()
E18: random()
E19: random()
E20: random()
E21: random()
E22: random()
E23: random()
E24: random()
E25: random()
E26: random()
E27: random()
E28: random()
E29: random()
E30: random()
E31: random()
E32: random()
E33: random()
E34: random()
E35: random()
E36: random()
E37: random()
E38: random()
E39: random()
E40: random()
E41: random()
E42: random()
E43: random()
E44: random()
E45: random()
E46: random()
E47: random()
E48: random()
E49: random()
E50: random()
E51: random()
E52: random()
E53: random()
E54: random()
E55: random()
E56: random()
E57: random()
E58: random()
E59: random()
E60: random()
E61: random()
E62: random()
E63: random()
E64: random()
E65: random()
E66: random()
E67: random()
E68: random()
E69: random()
E70: random()
E71: random()
E72: random()
E73: random()
E74: random()
E75: random()
E76: random()
E77: random()
E78: random()
E79: random()
E80: random()
E81: random()
E82: random()
E83: random()
E84: random()
E85: random()
E86: random()
E87: random()
E88: random()
E89: random()
E90: random()
E91: random()
E92: random()
E93: random()
E94: random()
E95: random()
E96: random()
E97: random()
E98: random()
E99: random()
E100: random()
klasslist = Classes(A2:B201, 10)
b = mean(A2:A201)
E101: random()
E102: random()
E103: random()
E104: random()
E105: random()
E106: random()
E107: random()
E108: random()
E109: random()
E110: random()
E111: random()
E112: random()
E113: random()
E114: random()
E115: random()
E116: random()
E117: random()
E118: random()
E119: random()
E120: random()
E121: random()
E122: random()
E123: random()
E124: random()
E125: random()
E126: random()
E127: random()
E128: random()
E129: random()
E130: random()
E131: random()
E132: random()
E133: random()
E134: random()
E135: random()
E136: random()
E137: random()
E138: random()
E139: random()
E140: random()
E141: random()
E142: random()
E143: random()
E144: random()
E145: random()
E146: random()
E147: random()
E148: random()
E149: random()
E150: random()
E151: random()
E152: random()
E153: random()
E154: random()
E155: random()
E156: random()
E157: random()
E158: random()
E159: random()
E160: random()
E161: random()
E162: random()
E163: random()
E164: random()
E165: random()
E166: random()
E167: random()
E168: random()
E169: random()
E170: random()
E171: random()
E172: random()
E173: random()
E174: random()
E175: random()
E176: random()
E177: random()
E178: random()
E179: random()
E180: random()
E181: random()
E182: random()
E183: random()
E184: random()
E185: random()
E186: random()
E187: random()
E188: random()
E189: random()
E190: random()
E191: random()
E192: random()
E193: random()
E194: random()
E195: random()
E196: random()
E197: random()
E198: random()
E199: random()
E200: random()
E201: random()
boxalle = BoxPlot(-0.6, 0.02, A2:B201, true)
a = Normal(10, 0.45, false)
f = Normal(10, 0.45, x, false)
c = Integral(f, 0, 9.1)
A2 = 9.83 (slider from -5 to 10)
A3 = 10.97 (slider from -5 to 20)
A4 = 9.86 (slider from -5 to 10)
A5 = 12.23 (slider from -5 to 20)
A6 = 9.72 (slider from -5 to 10)
A7 = 9.79 (slider from -5 to 10)
A8 = 10.93 (slider from -5 to 20)
A9 = 9.68 (slider from -5 to 10)
A10 = 9.9 (slider from -5 to 10)
A11 = 11.06 (slider from -5 to 20)
A12 = 11 (slider from -5 to 20)
A13 = 10.85 (slider from -5 to 20)
A14 = 10.91 (slider from -5 to 20)
A15 = 9.87 (slider from -5 to 10)
A16 = 10.88 (slider from -5 to 20)
A17 = 9.78 (slider from -5 to 10)
A18 = 11.03 (slider from -5 to 20)
A19 = 9.81 (slider from -5 to 10)
A20 = 10.92 (slider from -5 to 20)
A21 = 11.13 (slider from -5 to 20)
A22 = 10.88 (slider from -5 to 20)
A23 = 13.52 (slider from -5 to 20)
A24 = 9.91 (slider from -5 to 10)
A25 = 9.87 (slider from -5 to 10)
A26 = 9.77000000000001 (slider from -5 to 10)
A27 = 11.03 (slider from -5 to 20)
A28 = 9.82000000000001 (slider from -5 to 10)
A29 = 9.90000000000001 (slider from -5 to 10)
A30 = 10.86 (slider from -5 to 20)
A31 = 9.78000000000001 (slider from -5 to 10)
A32 = 12.08 (slider from -5 to 20)
A33 = 9.71000000000001 (slider from -5 to 10)
A34 = 9.78000000000001 (slider from -5 to 10)
A35 = 9.80000000000001 (slider from -5 to 10)
A36 = 11.03 (slider from -5 to 20)
A37 = 10.91 (slider from -5 to 20)
A38 = 10.92 (slider from -5 to 20)
A39 = 9.76000000000001 (slider from -5 to 10)
A40 = 9.67000000000001 (slider from -5 to 10)
A41 = 9.86000000000001 (slider from -5 to 10)
A42 = 9.91000000000001 (slider from -5 to 10)
A43 = 9.83000000000001 (slider from -5 to 10)
A44 = 13.36 (slider from -5 to 20)
A45 = 13.38 (slider from -5 to 20)
A46 = 11.07 (slider from -5 to 20)
A47 = 9.97000000000001 (slider from -5 to 10)
A48 = 12.22 (slider from -5 to 20)
A49 = 12.28 (slider from -5 to 20)
A50 = 10.92 (slider from -5 to 20)
A51 = 9.85 (slider from -5 to 10)
A52 = 9.76 (slider from -5 to 10)
A53 = 12.31 (slider from -5 to 20)
A54 = 9.67 (slider from -5 to 10)
A55 = 9.82 (slider from -5 to 10)
A56 = 10.84 (slider from -5 to 20)
A57 = 9.68 (slider from -5 to 10)
A58 = 10.89 (slider from -5 to 20)
A59 = 9.89 (slider from -5 to 10)
A60 = 9.74 (slider from -5 to 10)
A61 = 12.27 (slider from -5 to 20)
A62 = 11.08 (slider from -5 to 20)
A63 = 9.72 (slider from -5 to 10)
A64 = 11.14 (slider from -5 to 20)
A65 = 11.05 (slider from -5 to 20)
A66 = 9.92 (slider from -5 to 10)
A67 = 9.77 (slider from -5 to 10)
A68 = 9.9 (slider from -5 to 10)
A69 = 10.97 (slider from -5 to 20)
A70 = 9.77 (slider from -5 to 10)
A71 = 9.84 (slider from -5 to 10)
A72 = 11.15 (slider from -5 to 20)
A73 = 9.72 (slider from -5 to 10)
A74 = 9.79 (slider from -5 to 10)
A75 = 9.8 (slider from -5 to 10)
A76 = 10.89 (slider from -5 to 20)
A77 = 11.18 (slider from -5 to 20)
A78 = 9.68 (slider from -5 to 10)
A79 = 9.74 (slider from -5 to 10)
A80 = 10.94 (slider from -5 to 20)
A81 = 13.49 (slider from -5 to 20)
A82 = 10.82 (slider from -5 to 20)
A83 = 9.73 (slider from -5 to 10)
A84 = 11.17 (slider from -5 to 20)
A85 = 9.82 (slider from -5 to 10)
A86 = 9.64 (slider from -5 to 10)
A87 = 9.79 (slider from -5 to 10)
A88 = 10.82 (slider from -5 to 20)
A89 = 12.27 (slider from -5 to 20)
A90 = 11 (slider from -5 to 20)
A91 = 9.86 (slider from -5 to 10)
A92 = 13.39 (slider from -5 to 20)
A93 = 9.77 (slider from -5 to 10)
A94 = 11.01 (slider from -5 to 20)
A95 = 9.71 (slider from -5 to 10)
A96 = 11 (slider from -5 to 20)
A97 = 9.7 (slider from -5 to 10)
A98 = 13.41 (slider from -5 to 20)
B2: 10.17
B3: 10.11
B4: 10.08
B5: 10.3
B6: 10.48
B7: 10.1
B8: 10.16
B9: 10.08
B10: 10.27
B11: 10.34
B12: 11.23
B13: 12.37
B14: 12.62
B15: 11.37
B16: 11.54
B17: 10.23
B18: 11.35
B19: 12.63
B20: 12.57
B21: 11.6
B22: 11.44
B23: 11.34
B24: 10.05
B25: 10.29
B26: 13.95
B27: 10.14
B28: 11.57
B29: 11.2
B30: 10.19
B31: 11.37
B32: 11.45
B33: 11.06
B34: 9.99000000000001
B35: 11.34
B36: 12.69
B37: 11.5
B38: 10.1
B39: 10.03
B40: 13.72
B41: 10.1
B42: 10.45
B43: 10.5
B44: 12.79
B45: 9.95000000000001
B46: 10.17
B47: 12.42
B48: 10.18
B49: 9.97000000000001
B50: 11.45
B51: 10.16
B52: 10.11
B53: 10.95
B54: 9.98000000000001
B55: 11.33
B56: 11.24
B57: 10.11
B58: 11.25
B59: 10.04
B60: 10.29
B61: 10.89
B62: 12.58
B63: 9.98000000000001
B64: 10.21
B65: 10.06
B66: 11.18
B67: 10.03
B68: 10.37
B69: 10.09
B70: 10.26
B71: 10.18
B72: 10.21
B73: 11.51
B74: 12.44
B75: 15.22
B76: 10.29
B77: 15.09
B78: 10.14
B79: 11.6
B80: 10.25
B81: 10.07
B82: 10.2
B83: 9.96000000000001
B84: 10.26
B85: 10.08
B86: 17.94
B87: 9.99000000000001
B88: 10.09
B89: 10.08
B90: 9.91000000000001
B91: 11.46
B92: 11.21
B93: 10.28
B94: 10.09
B95: 10.12
B96: 10.23
B97: 10.07
B98: 10.25
B99: 10.29
B100: 12.33
B101: 12.18
C2: 10.23
C3: 10.08
C4: 10.27
C5: 10.11
C6: 12.69
C7: 14.04
C8: 10.33
C9: 9.94
C10: 10.92
C11: 9.80
C12: 10.04
C13: 10.25
C14: 10.04
C15: 11.07
C16: 11.26
C17: 10.01
C18: 9.97
C19: 10
C20: 10.17
C21: 9.99
C22: 11.36
C23: 10.09
C24: 12.62
C25: 11.45
C26: 10.17
C27: 11.41
C28: 9.94
C29: 9.96
C30: 10.11
C31: 9.93
C32: 11.22
C33: 11.23
C34: 11.36
C35: 13.69
C36: 10.18
C37: 10.21
C38: 10.12
C39: 11.10
C40: 10.99
C41: 11.39
C42: 10.15
C43: 10.07
C44: 11.46
C45: 9.99
C46: 12.67
C47: 10.24
C48: 10
C49: 10.09
C50: 10.07
C51: 10.04
C52: 10
C53: 10.93
C54: 10.23
C55: 11.41
C56: 12.83
C57: 10.14
C58: 10.32
C59: 10.11
C60: 10.31
C61: 11.43
C62: 9.96
C63: 10.13
C64: 10.05
C65: 10.07
C66: 11.41
C67: 11.7
C68: 10.07
C69: 11.36
C70: 11.29
C71: 11.08
C72: 10.34
C73: 10.07
C74: 10.07
C75: 10.04
C76: 10
C77: 10.15
C78: 10.14
C79: 11.49
C80: 11.32
C81: 10.34
C82: 10.13
C83: 10.13
C84: 10.21
C85: 10.16
C86: 9.77
C87: 10.06
C88: 10
C89: 10.01
C90: 11.11
C91: 10.04
C92: 9.97
C93: 10.07
C94: 10.2
C95: 9.96
C96: 11.49
C97: 12.42
C98: 10
C99: 13.61
C100: 10
C101: 10.27
C102: 9.95
C103: 10
C104: 10.11
C105: 11.03
C106: 11.36
C107: 10.09
histohh = Histogram(false, klasslist, A2:A201, true, 1 / 97)
D2: 9.87
D3: 10.96
D4: 9.77
D5: 9.86
D6: 9.76
D7: 11
D8: 11.15
D9: 12.12
D10: 10.96
D11: 7.15
D12: 9.7
D13: 9.75
D14: 9.75
D15: 9.73
D16: 11.01
D17: 9.84
D18: 12.08
D19: 9.74
D20: 12.25
D21: 12.25
D22: 9.69
D23: 9.87
D24: 12.22
D25: 12.22
D26: 9.83
D27: 11.05
D28: 10.89
D29: 12.29
D30: 9.81
D31: 11
D32: 11
D33: 9.8
D34: 9.78
D35: 9.68
D36: 11.09
D37: 10.94
D38: 9.85
D39: 10.95
D40: 10.83
D41: 9.92
D42: 11.01
D43: 12.15
D44: 9.76
D45: 11.04
D46: 10.96
D47: 9.77
D48: 9.76
D49: 12.38
D50: 9.8
D51: 10.9
D52: 11.09
D53: 12.16
D54: 11.08
D55: 10.93
D56: 10.93
D57: 9.83
D58: 10
D59: 12.16
D60: 10.87
D61: 11.03
D62: 9.74
D63: 10.96
D64: 10.95
D65: 9.8
D66: 10.96
D67: 9.7
D68: 10.95
D69: 9.83
D70: 10.84
D71: 12.35
D72: 9.7
D73: 11
D74: 9.83
D75: 12.13
D76: 10.91
D77: 10.99
D78: 9.82
D79: 9.71
D80: 11
D81: 9.78
D82: 10.91
D83: 11
D84: 11
D85: 12.14
D86: 9.8
D87: 7.32
D88: 10.92
D89: 11.13
D90: 10.89
D91: 10.97
D92: 9.78
D93: 10.93
D94: 11
D95: 12.39
D96: 10.99
D97: 12.17
D98: 9.69
D99: 11.01
D100: 11.01
D101: 10.97
D102: 9.71
D103: 11.01
D104: 9.76
D105: 9.75
D106: 12.17
D107: 12.22
A110: CountIf[x ≥ 10, A2:A98] / 97
B110: CountIf[x ≥ 10, B2:B101] / 100
C110: CountIf[x ≥ 10, C2:C107] / 106
D110: CountIf[x ≥ 10, D2:D107] / 106
A112 = mean(A2:A98)
B112 = mean(B2:B101)
C112 = mean(C2:C107)
D112 = mean(D2:D107)
N: (A112, -0.2)
G: (B112, -0.4)
M: (C112, -0.6)
A: (D112, -0.8)
Text1: "" + A110 + ""
Text2: "" + B110 + ""
Text3: "" + C110 + ""
Text4: "" + D110 + ""
punkthamburg: (A2:A108, (E2:E108 * 0.03) - 0.13)
hamburg = BoxPlot(-0.2, 0.02, A2:A108, true)
punktilmenau: (B2:B107, (E2:E107 * 0.02) - 0.3)
ilmenau = BoxPlot(-0.4, 0.02, B2:B107, true)
punktköln: (C2:C201, (E2:E107 * 0.02) - 0.5)
köln = BoxPlot(-0.6, 0.02, C2:C107, true)
punktmz: (D2:D201, (E2:E107 * 0.02) - 0.7)
mainz = BoxPlot(-0.8, 0.02, D2:D107, true)
histoilmenau = Histogram(false, klasslist, A2:D107, true, 0.25)
d = Histogram(false, Classes[{A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25, A26, A27, A28, A29, A30, A31, A32, A33, A34, A35, A36, A37, A38, A39, A40, A41, A42, A43, A44, A45, A46, A47, A48, A49, A50, A51, A52, A53, A54, A55, A56, A57, A58, A59, A60, A61, A62, A63, A64, A65, A66, A67, A68, A69, A70, A71, A72, A73, A74, A75, A76, A77, A78, A79, A80, A81, A82, A83, A84, A85, A86, A87, A88, A89, A90, A91, A92, A93, A94, A95, A96, A97, A98, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, B31, B32, B33, B34, B35, B36, B37, B38, B39, B40, B41, B42, B43, B44, B45, B46, B47, B48, B49, B50, B51, B52, B53, B54, B55, B56, B57, B58, B59, B60, B61, B62, B63, B64, B65, B66, B67, B68, B69, B70, B71, B72, B73, B74, B75, B76, B77, B78, B79, B80, B81, B82, B83, B84, B85, B86, B87, B88, B89, B90, B91, B92, B93, B94, B95, B96, B97, B98, B99, B100, B101, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37, C38, C39, C40, C41, C42, C43, C44, C45, C46, C47, C48, C49, C50, C51, C52, C53, C54, C55, C56, C57, C58, C59, C60, C61, C62, C63, C64, C65, C66, C67, C68, C69, C70, C71, C72, C73, C74, C75, C76, C77, C78, C79, C80, C81, C82, C83, C84, C85, C86, C87, C88, C89, C90, C91, C92, C93, C94, C95, C96, C97, C98, C99, C100, C101, C102, C103, C104, C105, C106, C107, D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12, D13, D14, D15, D16, D17, D18, D19, D20, D21, D22, D23, D24, D25, D26, D27, D28, D29, D30, D31, D32, D33, D34, D35, D36, D37, D38, D39, D40, D41, D42, D43, D44, D45, D46, D47, D48, D49, D50, D51, D52, D53, D54, D55, D56, D57, D58, D59, D60, D61, D62, D63, D64, D65, D66, D67, D68, D69, D70, D71, D72, D73, D74, D75, D76, D77, D78, D79, D80, D81, D82, D83, D84, D85, D86, D87, D88, D89, D90, D91, D92, D93, D94, D95, D96, D97, D98, D99, D100, D101, D102, D103, D104, D105, D106, D107}, 20], {A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25, A26, A27, A28, A29, A30, A31, A32, A33, A34, A35, A36, A37, A38, A39, A40, A41, A42, A43, A44, A45, A46, A47, A48, A49, A50, A51, A52, A53, A54, A55, A56, A57, A58, A59, A60, A61, A62, A63, A64, A65, A66, A67, A68, A69, A70, A71, A72, A73, A74, A75, A76, A77, A78, A79, A80, A81, A82, A83, A84, A85, A86, A87, A88, A89, A90, A91, A92, A93, A94, A95, A96, A97, A98, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, B31, B32, B33, B34, B35, B36, B37, B38, B39, B40, B41, B42, B43, B44, B45, B46, B47, B48, B49, B50, B51, B52, B53, B54, B55, B56, B57, B58, B59, B60, B61, B62, B63, B64, B65, B66, B67, B68, B69, B70, B71, B72, B73, B74, B75, B76, B77, B78, B79, B80, B81, B82, B83, B84, B85, B86, B87, B88, B89, B90, B91, B92, B93, B94, B95, B96, B97, B98, B99, B100, B101, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37, C38, C39, C40, C41, C42, C43, C44, C45, C46, C47, C48, C49, C50, C51, C52, C53, C54, C55, C56, C57, C58, C59, C60, C61, C62, C63, C64, C65, C66, C67, C68, C69, C70, C71, C72, C73, C74, C75, C76, C77, C78, C79, C80, C81, C82, C83, C84, C85, C86, C87, C88, C89, C90, C91, C92, C93, C94, C95, C96, C97, C98, C99, C100, C101, C102, C103, C104, C105, C106, C107, D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12, D13, D14, D15, D16, D17, D18, D19, D20, D21, D22, D23, D24, D25, D26, D27, D28, D29, D30, D31, D32, D33, D34, D35, D36, D37, D38, D39, D40, D41, D42, D43, D44, D45, D46, D47, D48, D49, D50, D51, D52, D53, D54, D55, D56, D57, D58, D59, D60, D61, D62, D63, D64, D65, D66, D67, D68, D69, D70, D71, D72, D73, D74, D75, D76, D77, D78, D79, D80, D81, D82, D83, D84, D85, D86, D87, D88, D89, D90, D91, D92, D93, D94, D95, D96, D97, D98, D99, D100, D101, D102, D103, D104, D105, D106, D107}, true, 0.0024449877750611247)