classic-12

schicht-10

krokant

royal

noire

58 von 60 = 96% der classic Nougats 
sind übergewichtig (>10g... “+”). 
Es sollten 50% sein.
h(+) sollte in [0.375;0,625] liegen.

A2: 10.27
B2: 10.49
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()
A3: 10.73
A4: 10.4300000000000
A5: 10.43
A6: 10.16
A7: 10.76
A8: 10.75
A9: 10.47
A10: 10.5
A11: 10.43
A12: 10.42
A13: 10.61
A14: 10.47
A15: 10.44
A16: 10.35
A17: 10.36
A18: 10.92
A19: 9.95
A20: 10.28
A21: 10.52
A22: 10.3
A23: 10.35
A24: 10.59
A25: 10.65
A26: 10.36
A27: 10.67
A28: 10.28
A29: 10.8
A30: 10.33
A31: 10.12
A32: 10.31
A33: 10
A34: 10.82
A35: 10.27
A36: 10.27
A37: 10.41
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()
B3: 10.42
B4: 10.39
B5: 10.43
B6: 10.35
B7: 10.44
B8: 10.39
B9: 10.51
B10: 10.48
B11: 10.24
B12: 10.53
B13: 10.38
B14: 10.44
B15: 10.61
B16: 10.57
B17: 10.61
B18: 10.26
B19: 10.36
B20: 10.27
B21: 10.29
B22: 11.01
B23: 10.26
B24: 10.63
B25: 10.42
B26: 10.5
B27: 10.43
B28: 10.45
B29: 10.50
B30: 10.69
B31: 10.26
C2: 11.15
C3: 11.12
C4: 11.01
C5: 11.39
C6: 10.93
C7: 10.5
C8: 11.15
C9: 11.43
C10: 11.25
C11: 11.78
C12: 10.92
C13: 10.66
C14: 11.97
C15: 11.2
C16: 10.58
C17: 10.79
C18: 11.5
C19: 11.61
C20: 10.9
C21: 10.97
C22: 10.68
C23: 10.94
C24: 10.6
C25: 11.96
C26: 10.73
C27: 11.12
C28: 11.69
C29: 11.51
C30: 10.76
C31: 10.81
C32: 11.41
C33: 11.01
C34: 10.97
F2 = If($A2 < B2, -1, If[$A2 ≟ B2, 0, 1])
F3 = If($A3 < B3, -1, If[$A3 ≟ B3, 0, 1])
F4 = If($A4 < B4, -1, If[$A4 ≟ B4, 0, 1])
F5 = If($A5 < B5, -1, If[$A5 ≟ B5, 0, 1])
F6 = If($A6 < B6, -1, If[$A6 ≟ B6, 0, 1])
F7 = If($A7 < B7, -1, If[$A7 ≟ B7, 0, 1])
F8 = If($A8 < B8, -1, If[$A8 ≟ B8, 0, 1])
F9 = If($A9 < B9, -1, If[$A9 ≟ B9, 0, 1])
F10 = If($A10 < B10, -1, If[$A10 ≟ B10, 0, 1])
F11 = If($A11 < B11, -1, If[$A11 ≟ B11, 0, 1])
F12 = If($A12 < B12, -1, If[$A12 ≟ B12, 0, 1])
F13 = If($A13 < B13, -1, If[$A13 ≟ B13, 0, 1])
F14 = If($A14 < B14, -1, If[$A14 ≟ B14, 0, 1])
F15 = If($A15 < B15, -1, If[$A15 ≟ B15, 0, 1])
F16 = If($A16 < B16, -1, If[$A16 ≟ B16, 0, 1])
F17 = If($A17 < B17, -1, If[$A17 ≟ B17, 0, 1])
F18 = If($A18 < B18, -1, If[$A18 ≟ B18, 0, 1])
F19 = If($A19 < B19, -1, If[$A19 ≟ B19, 0, 1])
F20 = If($A20 < B20, -1, If[$A20 ≟ B20, 0, 1])
F21 = If($A21 < B21, -1, If[$A21 ≟ B21, 0, 1])
F22 = If($A22 < B22, -1, If[$A22 ≟ B22, 0, 1])
F23 = If($A23 < B23, -1, If[$A23 ≟ B23, 0, 1])
F24 = If($A24 < B24, -1, If[$A24 ≟ B24, 0, 1])
F25 = If($A25 < B25, -1, If[$A25 ≟ B25, 0, 1])
F26 = If($A26 < B26, -1, If[$A26 ≟ B26, 0, 1])
F27 = If($A27 < B27, -1, If[$A27 ≟ B27, 0, 1])
F28 = If($A28 < B28, -1, If[$A28 ≟ B28, 0, 1])
F29 = If($A29 < B29, -1, If[$A29 ≟ B29, 0, 1])
F30 = If($A30 < B30, -1, If[$A30 ≟ B30, 0, 1])
F31 = If($A31 < B31, -1, If[$A31 ≟ B31, 0, 1])
G2 = If($A2 < C2, -1, If[$A2 ≟ C2, 0, 1])
G3 = If($A3 < C3, -1, If[$A3 ≟ C3, 0, 1])
G4 = If($A4 < C4, -1, If[$A4 ≟ C4, 0, 1])
G5 = If($A5 < C5, -1, If[$A5 ≟ C5, 0, 1])
G6 = If($A6 < C6, -1, If[$A6 ≟ C6, 0, 1])
G7 = If($A7 < C7, -1, If[$A7 ≟ C7, 0, 1])
G8 = If($A8 < C8, -1, If[$A8 ≟ C8, 0, 1])
G9 = If($A9 < C9, -1, If[$A9 ≟ C9, 0, 1])
G10 = If($A10 < C10, -1, If[$A10 ≟ C10, 0, 1])
G11 = If($A11 < C11, -1, If[$A11 ≟ C11, 0, 1])
G12 = If($A12 < C12, -1, If[$A12 ≟ C12, 0, 1])
G13 = If($A13 < C13, -1, If[$A13 ≟ C13, 0, 1])
G14 = If($A14 < C14, -1, If[$A14 ≟ C14, 0, 1])
G15 = If($A15 < C15, -1, If[$A15 ≟ C15, 0, 1])
G16 = If($A16 < C16, -1, If[$A16 ≟ C16, 0, 1])
G17 = If($A17 < C17, -1, If[$A17 ≟ C17, 0, 1])
G18 = If($A18 < C18, -1, If[$A18 ≟ C18, 0, 1])
G19 = If($A19 < C19, -1, If[$A19 ≟ C19, 0, 1])
G20 = If($A20 < C20, -1, If[$A20 ≟ C20, 0, 1])
G21 = If($A21 < C21, -1, If[$A21 ≟ C21, 0, 1])
G22 = If($A22 < C22, -1, If[$A22 ≟ C22, 0, 1])
G23 = If($A23 < C23, -1, If[$A23 ≟ C23, 0, 1])
G24 = If($A24 < C24, -1, If[$A24 ≟ C24, 0, 1])
G25 = If($A25 < C25, -1, If[$A25 ≟ C25, 0, 1])
G26 = If($A26 < C26, -1, If[$A26 ≟ C26, 0, 1])
G27 = If($A27 < C27, -1, If[$A27 ≟ C27, 0, 1])
G28 = If($A28 < C28, -1, If[$A28 ≟ C28, 0, 1])
G29 = If($A29 < C29, -1, If[$A29 ≟ C29, 0, 1])
G30 = If($A30 < C30, -1, If[$A30 ≟ C30, 0, 1])
G31 = If($A31 < C31, -1, If[$A31 ≟ C31, 0, 1])
F1 = CountIf(x ≟ 1, F2:F39)
G1 = CountIf(x ≟ 1, G2:G39)
G32 = If($A32 < C32, -1, If[$A32 ≟ C32, 0, 1])
G33 = If($A33 < C33, -1, If[$A33 ≟ C33, 0, 1])
G34 = If($A34 < C34, -1, If[$A34 ≟ C34, 0, 1])
a = CountIf(x ≟ true, A2:A31 < C2:C31)
A39: 10.09
A40: 10.33
A41: 10.45
A42: 10.63
A43: 10.17
A44: 10.81
A45: 10.28
A46: 10.39
A47: 10.47
A48: 10.14
A49: 10.26
A50: 10.31
A51: 10.42
A52: 10.41
A53: 10.17
A54: 10.30
A55: 10.59
A56: 10.21
A57: 10.43
A58: 10.51
A59: 10.49
A60: 10.66
A61: 10.81
A38: 10.22
C35: 11.4
C36: 10.6
C37: 11.49
D2: 11.1
D3: 10.71
D4: 11
D5: 10.55
D6: 11.12
D7: 10.46
D8: 10.73
D9: 11
D10: 11
D11: 11.35
D12: 10.78
D13: 10.3
D14: 10.47
D15: 10.95
D16: 10.42
D17: 10.59
D18: 10.96
D19: 11.18
D20: 11.07
D21: 10.67
D22: 10.53
D23: 11.07
D24: 10.4
D25: 10.57
D26: 10.83
D27: 10.96
D28: 10.95
D29: 10.74
D30: 10.81
D31: 10.27
D32: 10.67
D33: 10.39
D34: 10.40
D35: 10.65
D36: 10.31
D37: 11.19
H2: 10.8
H3: 9.92
H4: 11.26
H5: 10.36
H6: 11.05
H7: 10.51
H8: 10.22
H9: 10.83
H10: 10.37
H11: 10.84
punktschicht: (B2:B31, (E2:E31 * 0.02) - 0.3)
punktkrokant: (C2:C37, (E2:E37 * 0.02) - 0.5)
punktclassic: (A2:A61, (E2:E61 * 0.03) - 0.1)
punktroyal: (D2:D37, (E2:E37 * 0.02) - 0.7)
punktnoire: (H2:H11, (E2:E11 * 0.02) - 0.9)
royal = BoxPlot(-0.8, 0.02, D2:D37, true)
noire = BoxPlot(-1, 0.02, H2:H11, true)
classic = BoxPlot(-0.2, 0.02, A2:A61, true)
schicht = BoxPlot(-0.4, 0.02, B2:B31, true)
krokant = BoxPlot(-0.6, 0.02, C2:C37, true)