Würfeln mit Quadern

Klasse:

Datum:

0,2l  Würfelbecher

Ergebnisse 5er-Gruppen:

schei-

Erfolg

Name

absolute H.

%

absolute H.

%

absolute H.

%

absolute H.

%

absolute H.

%

absolute H.

%

alle zusammen

Schei-

Erfolg

absolute H.

%

<- Realität

Schei-

Erfolg

brauchbare

Hypothese

<- Prognose

tert

nach

tern

tern

Durch-

marsch

7c Würfelbecher

Uni: freier Fall

Laplace

Zum Vergleich

Höhe

Fläche

%

B5: 1
C5: 2
D5: 3
E5: 4
F5: 5
G5: 6
J5: 1
K5: 2
L5: 3
M5: 4
N5: 5
O5: 6
P5: 6
B6: 15
C6: 10
D6: 21
E6: 26
F6: 15
G6: 13
J6: 2
K6: 1
L6: 4
M6: 6
N6: 2
O6: 1
P6: 9
B7: 15
C7: 8
D7: 30
E7: 23
F7: 11
G7: 13
J7: 5
K7: 2
L7: 6
M7: 2
N7: 3
O7: 2
P7: 6
B8: 8
C8: 6
D8: 24
E8: 37
F8: 14
G8: 11
J8: 3
K8: 0
L8: 6
M8: 8
N8: 2
O8: 0
P8: 6
B9: 11
C9: 11
D9: 23
E9: 30
F9: 9
G9: 16
J9: 1
K9: 3
L9: 4
M9: 4
N9: 2
O9: 1
P9: 9
B10: 7
C10: 13
D10: 23
E10: 39
F10: 10
G10: 8
J10: 2
K10: 3
L10: 7
M10: 5
N10: 0
O10: 0
P10: 8
B14: 15
C14: 8
D14: 29
E14: 29
F14: 9
G14: 10
J14: 5
K14: 2
L14: 4
M14: 3
N14: 0
O14: 2
P14: 9
B15: 15
C15: 9
D15: 28
E15: 21
F15: 11
G15: 16
J15: 4
K15: 1
L15: 4
M15: 2
N15: 0
O15: 1
P15: 10
B16: 14
C16: 16
D16: 27
E16: 17
F16: 13
G16: 13
J16: 3
K16: 3
L16: 6
M16: 2
N16: 1
O16: 2
P16: 8
B17: 18
C17: 6
D17: 30
E17: 22
F17: 15
G17: 9
J17: 2
K17: 1
L17: 8
M17: 3
N17: 2
O17: 2
P17: 6
B18: 11
C18: 14
D18: 35
E18: 26
F18: 5
G18: 9
J18: 3
K18: 6
L18: 8
M18: 2
N18: 0
O18: 1
P18: 7
B22: 13
C22: 9
D22: 25
E22: 33
F22: 7
G22: 13
J22: 2
K22: 2
L22: 3
M22: 5
N22: 3
O22: 1
P22: 7
B23: 13
C23: 12
D23: 25
E23: 29
F23: 6
G23: 15
J23: 0
K23: 1
L23: 7
M23: 4
N23: 0
O23: 2
P23: 8
B24: 13
C24: 11
D24: 31
E24: 26
F24: 10
G24: 9
J24: 5
K24: 4
L24: 10
M24: 4
N24: 2
O24: 0
P24: 5
B25: 10
C25: 8
D25: 36
E25: 26
F25: 11
G25: 9
J25: 2
K25: 2
L25: 9
M25: 8
N25: 1
O25: 0
P25: 5
B26: 11
C26: 6
D26: 29
E26: 34
F26: 8
G26: 12
J26: 2
K26: 2
L26: 8
M26: 5
N26: 1
O26: 0
P26: 7
H38: 0
H39: 0
H40: 0
H41: 0
H42: 0
B51: 0
C51: 0
D51: 0
E51: 0
F51: 0
G51: 0
H56: 100
J59: 1
K59: 2
L59: 3
M59: 4
N59: 5
O59: 6
P59: 6
B60: 0.12
C60: 0.1
D60: 0.28
E60: 0.28
F60: 0.1
G60: 0.12
H6 = Sum(B6:G6)
H7 = Sum(B7:G7)
H8 = Sum(B8:G8)
H9 = Sum(B9:G9)
H10 = Sum(B10:G10)
H11 = Sum(B11:G11)
H12 = Sum(B12:G12)
B11 = Sum(B6:B10)
B12: (B11 / $H11 * 100)
C11 = Sum(C6:C10)
C12: (C11 / $H11 * 100)
D11 = Sum(D6:D10)
D12: (D11 / $H11 * 100)
E11 = Sum(E6:E10)
E12: (E11 / $H11 * 100)
F11 = Sum(F6:F10)
F12: (F11 / $H11 * 100)
G11 = Sum(G6:G10)
G12: (G11 / $H11 * 100)
H19 = Sum(B19:G19)
H20 = Sum(B20:G20)
B19 = Sum(B14:B18)
B20: (B19 / $H19 * 100)
C19 = Sum(C14:C18)
C20: (C19 / $H19 * 100)
D19 = Sum(D14:D18)
D20: (D19 / $H19 * 100)
E19 = Sum(E14:E18)
E20: (E19 / $H19 * 100)
F19 = Sum(F14:F18)
F20: (F19 / $H19 * 100)
G19 = Sum(G14:G18)
G20: (G19 / $H19 * 100)
H27 = Sum(B27:G27)
H28 = Sum(B28:G28)
B27 = Sum(B22:B26)
B28: (B27 / $H27 * 100)
C27 = Sum(C22:C26)
C28: (C27 / $H27 * 100)
D27 = Sum(D22:D26)
D28: (D27 / $H27 * 100)
E27 = Sum(E22:E26)
E28: (E27 / $H27 * 100)
F27 = Sum(F22:F26)
F28: (F27 / $H27 * 100)
G27 = Sum(G22:G26)
G28: (G27 / $H27 * 100)
H14 = Sum(B14:G14)
H15 = Sum(B15:G15)
H16 = Sum(B16:G16)
H17 = Sum(B17:G17)
H18 = Sum(B18:G18)
H22 = Sum(B22:G22)
H23 = Sum(B23:G23)
H24 = Sum(B24:G24)
H25 = Sum(B25:G25)
H26 = Sum(B26:G26)
a = Sum(B30:B34)
C35 = Sum(C30:C34)
D35 = Sum(D30:D34)
E35 = Sum(E30:E34)
F35 = Sum(F30:F34)
b = Sum(G30:G34)
B35 = Sum(B30:B34)
G35 = Sum(G30:G34)
C43 = Sum(C38:C42)
D43 = Sum(D38:D42)
E43 = Sum(E38:E42)
F43 = Sum(F38:F42)
B43 = Sum(B38:B42)
G43 = Sum(G38:G42)
H43 = Sum(H38:H42)
H35 = Sum(B35:G35)
H36 = Sum(B36:G36)
H30 = Sum(B30:G30)
H31 = Sum(B31:G31)
H32 = Sum(B32:G32)
H33 = Sum(B33:G33)
H34 = Sum(B34:G34)
H51 = Sum(B51:G51)
H46 = Sum(B46:G46)
H47 = Sum(B47:G47)
H48 = Sum(B48:G48)
H49 = Sum(B49:G49)
H50 = Sum(B50:G50)
B59: 1
C59: 2
D59: 3
E59: 4
F59: 5
G59: 6
J11 = Sum(J6:J10)
K11 = Sum(K6:K10)
L11 = Sum(L6:L10)
M11 = Sum(M6:M10)
N11 = Sum(N6:N10)
O11 = Sum(O6:O10)
P11 = Sum(P6:P10)
Q11 = Sum(J11:P11)
J12: J11 / $Q11
K12: K11 / $Q11
L12: L11 / $Q11
M12: M11 / $Q11
N12: N11 / $Q11
O12: O11 / $Q11
P12: P11 / $Q11
Q6 = Sum(J6:P6)
Q7 = Sum(J7:P7)
Q8 = Sum(J8:P8)
Q9 = Sum(J9:P9)
Q10 = Sum(J10:P10)
Q12 = Sum(J12:P12)
J19 = Sum(J14:J18)
K19 = Sum(K14:K18)
L19 = Sum(L14:L18)
M19 = Sum(M14:M18)
N19 = Sum(N14:N18)
O19 = Sum(O14:O18)
P19 = Sum(P14:P18)
Q19 = Sum(J19:P19)
J20: J19 / $Q19
K20: K19 / $Q19
L20: L19 / $Q19
M20: M19 / $Q19
N20: N19 / $Q19
O20: O19 / $Q19
P20: P19 / $Q19
Q20 = Sum(J20:P20)
J27 = Sum(J22:J26)
K27 = Sum(K22:K26)
L27 = Sum(L22:L26)
M27 = Sum(M22:M26)
N27 = Sum(N22:N26)
O27 = Sum(O22:O26)
P27 = Sum(P22:P26)
Q27 = Sum(J27:P27)
J28: J27 / $Q27
K28: K27 / $Q27
L28: L27 / $Q27
M28: M27 / $Q27
N28: N27 / $Q27
O28: O27 / $Q27
P28: P27 / $Q27
Q28 = Sum(J28:P28)
Q14 = Sum(J14:P14)
Q15 = Sum(J15:P15)
Q16 = Sum(J16:P16)
Q17 = Sum(J17:P17)
Q18 = Sum(J18:P18)
Q22 = Sum(J22:P22)
Q23 = Sum(J23:P23)
Q24 = Sum(J24:P24)
Q25 = Sum(J25:P25)
Q26 = Sum(J26:P26)
L30: 0
L34: 0
L35 = Sum(L30:L34)
M30: 0
M34: 0
M35 = Sum(M30:M34)
N30: 0
N34: 0
N35 = Sum(N30:N34)
O30: 0
O34: 0
O35 = Sum(O30:O34)
K35 = Sum(K30:K34)
P35 = Sum(P30:P34)
J30: 0
J34: 0
J35 = Sum(J30:J34)
L38: 0
L42: 0
M38: 0
M42: 0
N38: 0
N42: 0
O38: 0
O42: 0
K38: 0
K42: 0
c = Sum(K38:K42)
P38: 0
P42: 0
d = Sum(P38:P42)
K39: 0
P39: 0
Q39 = Sum(K39:P39)
K40: 0
P40: 0
Q40 = Sum(K40:P40)
K41: 0
P41: 0
Q41 = Sum(K41:P41)
Q42 = Sum(K42:P42)
J38: 0
J42: 0
L39: 0
M39: 0
N39: 0
O39: 0
J39: 0
L40: 0
M40: 0
N40: 0
O40: 0
J40: 0
L41: 0
M41: 0
N41: 0
O41: 0
J41: 0
K43 = Sum(K38:K42)
L43 = Sum(L38:L42)
M43 = Sum(M38:M42)
N43 = Sum(N38:N42)
J43 = Sum(J38:J42)
O43 = Sum(O38:O42)
P43 = Sum(P38:P42)
K51: 0
P51: 0
L46: 0
L50: 0
M46: 0
M50: 0
N46: 0
N50: 0
O46: 0
O50: 0
K46: 0
K50: 0
P46: 0
P50: 0
K47: 0
P47: 0
K48: 0
P48: 0
K49: 0
P49: 0
J46: 0
J50: 0
L47: 0
M47: 0
N47: 0
O47: 0
J47: 0
L48: 0
M48: 0
N48: 0
O48: 0
J48: 0
L49: 0
M49: 0
N49: 0
O49: 0
J49: 0
e = Sum(K46:K50)
L51 = Sum(L46:L50)
M51 = Sum(M46:M50)
N51 = Sum(N46:N50)
J51 = Sum(J46:J50)
O51 = Sum(O46:O50)
f = Sum(P46:P50)
g = Sum(K47:K51)
h = Sum(P47:P51)
B30: 0
B31: 0
B32: 0
B33: 0
B34: 0
C30: 0
C31: 0
C32: 0
C33: 0
C34: 0
D30: 0
D31: 0
D32: 0
D33: 0
D34: 0
E30: 0
E31: 0
E32: 0
E33: 0
E34: 0
F30: 0
F31: 0
F32: 0
F33: 0
F34: 0
G30: 0
G31: 0
G32: 0
G33: 0
G34: 0
B38: 0
B39: 0
B40: 0
B41: 0
B42: 0
C38: 0
C39: 0
C40: 0
C41: 0
C42: 0
D38: 0
D39: 0
D40: 0
D41: 0
D42: 0
E38: 0
E39: 0
E40: 0
E41: 0
E42: 0
F38: 0
F39: 0
F40: 0
F41: 0
F42: 0
G38: 0
G39: 0
G40: 0
G41: 0
G42: 0
B46: 0
B47: 0
B48: 0
B49: 0
B50: 0
C46: 0
C47: 0
C48: 0
C49: 0
C50: 0
D46: 0
D47: 0
D48: 0
D49: 0
D50: 0
E46: 0
E47: 0
E48: 0
E49: 0
E50: 0
F46: 0
F47: 0
F48: 0
F49: 0
F50: 0
G46: 0
G47: 0
G48: 0
G49: 0
G50: 0
H44 = Sum(H39:H43)
H52 = Sum(B52:G52)
B55: B11 + B19 + B27 + B35 + B43
C55: C11 + C19 + C27 + C35 + C43
D55: D11 + D19 + D27 + D35 + D43
E55: E11 + E19 + E27 + E35 + E43
F55: F11 + F19 + F27 + F35 + F43
G55: G11 + G19 + G27 + G35 + G43
H55: H11 + H19 + H27 + H35 + H43
B56: (B55 / $H55 * 100)
C56: (C55 / $H55 * 100)
D56: (D55 / $H55 * 100)
E56: (E55 / $H55 * 100)
F56: (F55 / $H55 * 100)
G56: (G55 / $H55 * 100)
J55: J11 + J19 + J27 + J35 + J43
K55: K11 + K19 + K27 + K35 + K43
L55: L11 + L19 + L27 + L35 + L43
M55: M11 + M19 + M27 + M35 + M43
N55: N11 + N19 + N27 + N35 + N43
O55: O11 + O19 + O27 + O35 + O43
P55: P11 + P19 + P27 + P35 + P43
Q55 = Sum(J55:P55)
J56: (J55 / $Q55 * 100)
K56: (K55 / $Q55 * 100)
L56: (L55 / $Q55 * 100)
M56: (M55 / $Q55 * 100)
N56: (N55 / $Q55 * 100)
O56: (O55 / $Q55 * 100)
P56: (P55 / $Q55 * 100)
Q30 = Sum(J30:P30)
J31: 0
P31: 0
Q31 = Sum(J31:P31)
J32: 0
P32: 0
Q32 = Sum(J32:P32)
J33: 0
P33: 0
Q33 = Sum(J33:P33)
P34: 0
Q34 = Sum(J34:P34)
Q35 = Sum(J35:P35)
Q36 = Sum(J36:P36)
K30: 0
K34: 0
K31: 0
K32: 0
K33: 0
L31: 0
L32: 0
L33: 0
M31: 0
M32: 0
M33: 0
N31: 0
N32: 0
N33: 0
O31: 0
O32: 0
O33: 0
P30: 0
Summe(K31:P31) = Sum(J31:P31)
Summe(K32:P32) = Sum(J32:P32)
Summe(K33:P33) = Sum(J33:P33)
Summe(K34:P34) = Sum(J34:P34)
Q38 = Sum(J38:P38)
Q43 = Sum(J43:P43)
Q44 = Sum(J44:P44)
Q46 = Sum(J46:P46)
Q51 = Sum(J51:P51)
Q52 = Sum(J52:P52)
Q47 = Sum(J47:P47)
Q48 = Sum(J48:P48)
Q49 = Sum(J49:P49)
Q50 = Sum(J50:P50)
J60: B60
K60: (C60 * (1 - B60))
L60: ((D60 * (1 - B60)) * (1 - C60))
M60: (((E60 * (1 - B60)) * (1 - C60)) * (1 - D60))
N60: ((((F60 * (1 - B60)) * (1 - C60)) * (1 - D60)) * (1 - E60))
P60: ((((((1 - B60) * (1 - C60)) * (1 - D60)) * (1 - E60)) * (1 - F60)) * (1 - G60))
O60: (((((G60 * (1 - B60)) * (1 - C60)) * (1 - D60)) * (1 - E60)) * (1 - F60))
B63: 0.12
C63: 0.0800000000000001
D63: 0.3
E63: 0.3
F63: 0.0800000000000001
G63: 0.12
B64: 0.0800000000000001
C64: 0.04
D64: 0.38
E64: 0.38
F64: 0.04
G64: 0.0800000000000001
B65: 0.166666666666667
C65: 0.166666666666667
D65: 0.166666666666667
E65: 0.166666666666667
F65: 0.166666666666667
G65: 0.166666666666667
J64: B64
K64: (C64 * (1 - B64))
L64: ((D64 * (1 - B64)) * (1 - C64))
M64: (((E64 * (1 - B64)) * (1 - C64)) * (1 - D64))
N64: ((((F64 * (1 - B64)) * (1 - C64)) * (1 - D64)) * (1 - E64))
P64: ((((((1 - B64) * (1 - C64)) * (1 - D64)) * (1 - E64)) * (1 - F64)) * (1 - G64))
O64: (((((G64 * (1 - B64)) * (1 - C64)) * (1 - D64)) * (1 - E64)) * (1 - F64))
J65: B65
K65: (C65 * (1 - B65))
L65: ((D65 * (1 - B65)) * (1 - C65))
M65: (((E65 * (1 - B65)) * (1 - C65)) * (1 - D65))
N65: ((((F65 * (1 - B65)) * (1 - C65)) * (1 - D65)) * (1 - E65))
P65: ((((((1 - B65) * (1 - C65)) * (1 - D65)) * (1 - E65)) * (1 - F65)) * (1 - G65))
O65: (((((G65 * (1 - B65)) * (1 - C65)) * (1 - D65)) * (1 - E65)) * (1 - F65))
J63: B63
K63: (C63 * (1 - B63))
L63: ((D63 * (1 - B63)) * (1 - C63))
M63: (((E63 * (1 - B63)) * (1 - C63)) * (1 - D63))
N63: ((((F63 * (1 - B63)) * (1 - C63)) * (1 - D63)) * (1 - E63))
P63: ((((((1 - B63) * (1 - C63)) * (1 - D63)) * (1 - E63)) * (1 - F63)) * (1 - G63))
O63: (((((G63 * (1 - B63)) * (1 - C63)) * (1 - D63)) * (1 - E63)) * (1 - F63))
D68: 1
E68: 1
C68: 2.3
F68: 2.3
G68: 2
B68: 2
H68: ((B68 * C68) * D68)
B69: $H68 / B68
C69: $H68 / C68
D69: $H68 / D68
E69: $H68 / E68
F69: $H68 / F68
G69: $H68 / G68
H69 = Sum(B69:G69)
B70: B69 / $H69
C70: C69 / $H69
D70: D69 / $H69
E70: E69 / $H69
F70: F69 / $H69
G70: G69 / $H69
H70 = Sum(B70:G70)
h1: B68:G68
h2: h1 / (((B68 * C68) * D68))^(1 / 3)
A: B55:G55