gestichen

gehäuft

A2: 12.3
B2: 19.6
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:B281, 10)
histogold = Histogram(false, klasslist, B2:B281, true, 1 / 280)
goldtabelle = FrequencyTable(histogold)
A3: 9.90000000000001
A4: 11
A5: 9.80000000000001
A6: 9.70000000000001
A7: 11.2
A8: 7
A9: 9.70000000000001
A10: 7.50000000000001
A11: 9.20000000000001
A12: 7.70000000000001
A13: 8.50000000000001
A14: 7.70000000000001
A15: 6.80000000000001
A16: 8.90000000000001
A17: 8.70000000000001
A18: 8.40000000000001
A19: 6.90000000000001
A20: 6.90000000000001
A21: 8
A22: 12.3
A23: 9.90000000000001
A24: 11
A25: 9.80000000000001
A26: 9.70000000000001
A27: 11.2
A28: 7
A29: 9.70000000000001
A30: 7.50000000000001
A31: 9.20000000000001
A32: 7.70000000000001
A33: 8.50000000000001
A34: 7.70000000000001
A35: 6.80000000000001
A36: 8.90000000000001
A37: 8.70000000000001
A38: 8.40000000000001
A39: 6.90000000000001
A40: 6.90000000000001
A41: 8
A42: 10
A43: 11
A44: 10
A45: 10
A46: 12
A47: 9
A48: 10
A49: 10
A50: 11
A51: 10
A52: 11
A53: 11
A54: 12
A55: 12
A56: 11
A57: 10
A58: 12
A59: 11
A60: 12
A61: 12
A62: 4.2
A63: 6
A64: 8.30000000000001
A65: 6.50000000000001
A66: 5.80000000000001
A67: 6.20000000000001
A68: 8
A69: 10.1
A70: 8
A71: 6
A72: 8
A73: 10
A74: 8.10000000000001
A75: 10.2
A76: 8.50000000000001
A77: 9.20000000000001
A78: 10.2
A79: 10.3
A80: 8.90000000000001
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()
mittelblau = mean(A2:A281)
B: (mittelblau, -0.2)
B3: 19.1
B4: 17.4
B5: 20
B6: 19.6
B7: 19.7
B8: 20.7
B9: 17.2
B10: 19.6
B11: 20.2
B12: 13.2
B13: 14.3
B14: 14.3
B15: 14.3
B16: 14.8
B17: 14.9
B18: 13.8
B19: 14.4
B20: 14.1
B21: 13.2
B22: 19.6
B23: 19.1
B24: 17.4
mittelgold = mean(B2:B281)
G: (mittelgold, -0.4)
B25: 20
B26: 19.6
B27: 19.7
B28: 20.7
B29: 17.2
B30: 19.6
B31: 20.2
B32: 13.2
B33: 14.3
B34: 14.3
B35: 14.3
B36: 14.8
B37: 14.9
B38: 13.8
B39: 14.4
B40: 14.1
B41: 13.2
B42: 22
B43: 21
B44: 21
B45: 22
B46: 22
B47: 24
B48: 24
B49: 22
B50: 22
B51: 24
B52: 23
B53: 25
B54: 24
B55: 24
B56: 25
B57: 25
B58: 23
B59: 23
B60: 24
B61: 23
boxalle = BoxPlot(-0.6, 0.02, A2:B201, true)
σblau = stdevp(A2:A281)
μblau = mean(A2:A281)
fiblau = Normal(μblau, σblau, x, false)
histoblau = Histogram(klasslist, A2:A281, true, 1 / 280)
B62: 16.1
B63: 18.5
B64: 18.2
B65: 16
B66: 16.4
B67: 16.5
B68: 14.4
B69: 15.8
B70: 12.3
B71: 15.9
B72: 18
B73: 18.5
B74: 18.3
B75: 14.5
B76: 18.6
B77: 18.9
B78: 18.3
B79: 19
B80: 17
B81: 16.7
B82: 24.8
B83: 22.5
B84: 21.4
B85: 25.9
B86: 26.1
B87: 26
B88: 25.5
B89: 24.7
B90: 25.2
B91: 24.2
B92: 24.9
B93: 22.3
B94: 25.1
B95: 24
B96: 24.3
B97: 24.8
B98: 21.7
B99: 24.4
B100: 23.2
B101: 24.4
B102: 13.2
B103: 11.3
B104: 12.7
B105: 12.6
B106: 11.4
B107: 11.8
B108: 12.6
B109: 11.7
B110: 11.4
B111: 11.8
B112: 12.6
B113: 11.6
B114: 13.9
B115: 13.3
B116: 12.2
B117: 14.6
B118: 13.2
B119: 13.7
B120: 12.4
B121: 11.4
B122: 10
B123: 10
B124: 10
B125: 9
B126: 9
B127: 10
B128: 10
B129: 10
B130: 10
B131: 10
B132: 9
B133: 10
B134: 9
B135: 10
B136: 11
B137: 10
B138: 11
B139: 10
B140: 10
B141: 10
B142: 19.1
B143: 19.3
B144: 20.5
B145: 19.5
B146: 20.3
B147: 19.8
B148: 21.2
B149: 20.4
B150: 20.1
B151: 19.6
B152: 17.3
B153: 17.7
B154: 18.3
B155: 16.7
B156: 17.4
B157: 17.6
B158: 17.5
B159: 17.7
B160: 17.4
B161: 17.7
B162: 18
B163: 18
B164: 19
B165: 20
B166: 18
B167: 19
B168: 20
B169: 18
B170: 18
B171: 19
B172: 16
B173: 17
B174: 17
B175: 16
B176: 18
B177: 17
B178: 19
B179: 17
B180: 17
B181: 18
blautabelle = FrequencyTable(histoblau)
σgold = stdevp(B2:B281)
μgold = mean(B2:B181)
figold = Normal(μgold, σgold, x, false)
A81: 7.80000000000001
A82: 14.2
A83: 16.7
A84: 18.1
A85: 12.6
A86: 14.3
A87: 13.5
A88: 15.9
A89: 15
A90: 15.4
A91: 16
A92: 16.3
A93: 15
A94: 16.7
A95: 15.2
A96: 16.1
A97: 18.6
A98: 15.8
A99: 15.6
A100: 16.1
A101: 18.4
A102: 8.80000000000001
A103: 8.80000000000001
A104: 8.70000000000001
A105: 8.70000000000001
A106: 9.10000000000001
A107: 9
A108: 8.70000000000001
A109: 8.60000000000001
A110: 8.90000000000001
A111: 8.40000000000001
A112: 8.70000000000001
A113: 8.60000000000001
A114: 8.80000000000001
A115: 8.80000000000001
A116: 8.80000000000001
A117: 8.90000000000001
A118: 8.60000000000001
A119: 8.80000000000001
A120: 8.70000000000001
A121: 8.60000000000001
A122: 5
A123: 6
A124: 5
A125: 6
A126: 5
A127: 4
A128: 5
A129: 4
A130: 4
A131: 4
A132: 5
A133: 5
A134: 5
A135: 5
A136: 4
A137: 6
A138: 5
A139: 4
A140: 5
A141: 4
A142: 8.50000000000001
A143: 9.50000000000001
A144: 7.50000000000001
A145: 6.90000000000001
A146: 8.40000000000001
A147: 7.20000000000001
A148: 7.40000000000001
A149: 6.80000000000001
A150: 6.90000000000001
A151: 6.40000000000001
A152: 7.40000000000001
A153: 6.60000000000001
A154: 5.90000000000001
A155: 6.70000000000001
A156: 5.80000000000001
A157: 6.80000000000001
A158: 4.90000000000001
A159: 6.30000000000001
A160: 4.8
A161: 5.60000000000001
A162: 9
A163: 9
A164: 8
A165: 10
A166: 9
A167: 8
A168: 7
A169: 9
A170: 8
A171: 8
A172: 7
A173: 8
A174: 6
A175: 7
A176: 7
A177: 8
A178: 7
A179: 6
A180: 7
A181: 8
A182: 6.80000000000001
B182: 7.40000000000001
A183: 6
B183: 7.20000000000001
A184: 5.30000000000001
B184: 7.20000000000001
A185: 5.80000000000001
B185: 7.40000000000001
A186: 5.1
B186: 7.40000000000001
A187: 4.8
B187: 7.20000000000001
A188: 5.80000000000001
B188: 7.30000000000001
A189: 5.70000000000001
B189: 6.90000000000001
A190: 5.20000000000001
B190: 7.30000000000001
A191: 5.30000000000001
B191: 7.20000000000001
A192: 5.60000000000001
B192: 7.10000000000001
A193: 5.80000000000001
B193: 6.70000000000001
A194: 5.50000000000001
B194: 6.90000000000001
A195: 5.40000000000001
B195: 7.40000000000001
A196: 4.70000000000001
B196: 6.90000000000001
A197: 5.70000000000001
B197: 7.40000000000001
A198: 5.40000000000001
B198: 7.40000000000001
A199: 5.50000000000001
B199: 7.40000000000001
A200: 5
B200: 7.30000000000001
A201: 5.70000000000001
B201: 7.40000000000001
A202: 9
B202: 17
A203: 9
B203: 19
A204: 9
B204: 19
A205: 10
B205: 18
A206: 10
B206: 17
A207: 10
B207: 20
A208: 8
B208: 19
A209: 8
B209: 18
A210: 8
B210: 17
A211: 7
B211: 17
A212: 7
B212: 18
A213: 8
B213: 18
A214: 7
B214: 17
A215: 7
B215: 17
A216: 8
B216: 18
A217: 9
B217: 19
A218: 9
B218: 18
A219: 8
B219: 17
A220: 7
B220: 17
A221: 7
B221: 17
A222: 14
B222: 20
A223: 12
B223: 20
A224: 12
B224: 20
A225: 9
B225: 19
A226: 12
B226: 18
A227: 15
B227: 21
A228: 12
B228: 19
A229: 12
B229: 20
A230: 13
B230: 19
A231: 11
B231: 17
A232: 10
B232: 18
A233: 10
B233: 20
A234: 13
B234: 17
A235: 11
B235: 18
A236: 8
B236: 17
A237: 11
B237: 14
A238: 10
B238: 19
A239: 11
B239: 19
A240: 9
B240: 19
A241: 11
B241: 17
A242: 5.20000000000001
B242: 14.3
A243: 4.40000000000001
B243: 14.6
A244: 6.10000000000001
B244: 16.1
A245: 7.50000000000001
B245: 16.7
A246: 8
B246: 13.2
A247: 7.30000000000001
B247: 16.5
A248: 5.20000000000001
B248: 15.7
A249: 7.60000000000001
B249: 16.9
A250: 6.50000000000001
B250: 14.1
A251: 9
B251: 14.9
A252: 7.30000000000001
B252: 17.6
A253: 7.60000000000001
B253: 19.4
A254: 7.10000000000001
B254: 20.3
A255: 6.80000000000001
B255: 18.8
A256: 7.40000000000001
B256: 18.1
A257: 7.80000000000001
B257: 19.5
A258: 6.50000000000001
B258: 20.4
A259: 7.40000000000001
B259: 18.2
A260: 6.30000000000001
B260: 19.7
A261: 6.80000000000001
B261: 19.9
A262: 8.70000000000001
B262: 19.9
A263: 10.6
B263: 19
A264: 9.70000000000001
B264: 19.6
A265: 9.50000000000001
B265: 19.6
A266: 9.50000000000001
B266: 18.5
A267: 10.1
B267: 18.8
A268: 9.40000000000001
B268: 19.2
A269: 11
B269: 20.4
A270: 10.4
B270: 20.7
A271: 10.2
B271: 20
A272: 7.70000000000001
B272: 19.1
A273: 6.20000000000001
B273: 17.3
A274: 10.6
B274: 17.6
A275: 7.80000000000001
B275: 17.9
A276: 10
B276: 16.5
A277: 10.1
B277: 18.6
A278: 8.50000000000001
B278: 18.3
A279: 7.20000000000001
B279: 17.4
A280: 8.10000000000001
B280: 17.3
A281: 8.40000000000001
B281: 18.3
punktblau: (A2:A281, (E2:E281 * 0.03) - 0.13)
blaueinsigma: round(CountIf[μblau - σblau < x < μblau + σblau, A2:A281] / 280, 2)
blauzweisigma: round(CountIf[μblau - (2 * σblau) < x < μblau + (2 * σblau), A2:A281] / 281, 2)
boxblau = BoxPlot(-0.2, 0.02, A2:A281, true)
boxgold = BoxPlot(-0.4, 0.02, B2:B281, true)
godzweisigma: round(CountIf[μgold - (2 * σgold) < x < μgold + (2 * σgold), B2:B281] / 280, 2)
goldeinsigma: round(CountIf[μgold - σgold < x < μgold + σgold, B2:B281] / 280, 2)
medianblau = mean(A2:A281)
mediangold = Median(B2:B281)
punktgold: (B2:B281, (E2:E281 * 0.02) - 0.3)