Würfeln mit Quadern

Klasse:

Datum:

0,2l  Würfelbecher

Ergebnisse 5er-Gruppen:

schei-

Erfolg

Name

absolute H.

relative H.

absolute H.

relative H.

absolute H.

relative H.

absolute H.

relative H.

absolute H.

relative H.

absolute H.

relative H.

alle zusammen

Schei-

Erfolg

absolute H.

relative 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

Anteil

Patrick

Daniel

Binoy

Tobias

Michael

Paula

Elaine

Marie

Marga

Sandra

Hares

Edris

Christian

Sineat

Alice

Carsten

Franca

Anka

Jenni

Kathi

Ursula

Thomas

Björn

Ute

Annette

Ines

Jessi

<- Prognose

<- Prognose

<- Prognose

<- Prognose

G51 = Sum(G46:G50)
G43 = Sum(G38:G42)
G35 = Sum(G30:G34)
G27 = Sum(G22:G26)
G19 = Sum(G14:G18)
G11 = Sum(G6:G10)
F51 = Sum(F46:F50)
F43 = Sum(F38:F42)
F35 = Sum(F30:F34)
F27 = Sum(F22:F26)
F19 = Sum(F14:F18)
F11 = Sum(F6:F10)
E51 = Sum(E46:E50)
E43 = Sum(E38:E42)
E35 = Sum(E30:E34)
E27 = Sum(E22:E26)
E19 = Sum(E14:E18)
E11 = Sum(E6:E10)
D51 = Sum(D46:D50)
D43 = Sum(D38:D42)
D35 = Sum(D30:D34)
D27 = Sum(D22:D26)
D19 = Sum(D14:D18)
D11 = Sum(D6:D10)
C51 = Sum(C46:C50)
C43 = Sum(C38:C42)
C35 = Sum(C30:C34)
C27 = Sum(C22:C26)
C19 = Sum(C14:C18)
C11 = Sum(C6:C10)
B51 = Sum(B46:B50)
B43 = Sum(B38:B42)
B35 = Sum(B30:B34)
B27 = Sum(B22:B26)
B19 = Sum(B14:B18)
B11 = Sum(B6:B10)
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: 10
C6: 6
D6: 28
E6: 41
F6: 4
G6: 11
J6: 2
K6: 1
L6: 4
M6: 6
N6: 2
O6: 1
P6: 9
B7: 6
C7: 7
D7: 35
E7: 45
F7: 4
G7: 3
J7: 5
K7: 2
L7: 6
M7: 2
N7: 3
O7: 2
P7: 6
B8: 7
C8: 4
D8: 37
E8: 34
F8: 1
G8: 17
J8: 3
K8: 0
L8: 6
M8: 8
N8: 2
O8: 0
P8: 6
B9: 3
C9: 6
D9: 48
E9: 33
F9: 6
G9: 4
J9: 1
K9: 3
L9: 4
M9: 4
N9: 2
O9: 1
P9: 9
B10: 12
C10: 0
D10: 28
E10: 42
F10: 7
G10: 11
J10: 2
K10: 3
L10: 7
M10: 5
N10: 0
O10: 0
P10: 8
B14: 11
C14: 6
D14: 34
E14: 32
F14: 7
G14: 10
J14: 5
K14: 2
L14: 4
M14: 3
N14: 0
O14: 2
P14: 9
B15: 14
C15: 10
D15: 28
E15: 24
F15: 9
G15: 15
J15: 4
K15: 1
L15: 4
M15: 2
N15: 0
O15: 1
P15: 10
B16: 4
C16: 6
D16: 41
E16: 32
F16: 11
G16: 6
J16: 3
K16: 3
L16: 6
M16: 2
N16: 1
O16: 2
P16: 8
B17: 10
C17: 6
D17: 34
E17: 29
F17: 7
G17: 14
J17: 2
K17: 1
L17: 8
M17: 3
N17: 2
O17: 2
P17: 6
B18: 7
C18: 4
D18: 30
E18: 37
F18: 4
G18: 18
J18: 3
K18: 6
L18: 8
M18: 2
N18: 0
O18: 1
P18: 7
B22: 8
C22: 5
D22: 38
E22: 35
F22: 5
G22: 9
J22: 0
K22: 0
L22: 5
M22: 9
N22: 0
O22: 0
P22: 8
B23: 8
C23: 7
D23: 26
E23: 41
F23: 8
G23: 10
J23: 0
K23: 2
L23: 6
M23: 8
N23: 1
O23: 1
P23: 6
B24: 11
C24: 7
D24: 30
E24: 30
F24: 7
G24: 15
J24: 1
K24: 1
L24: 4
M24: 6
N24: 1
O24: 1
P24: 7
B25: 8
C25: 12
D25: 36
E25: 29
F25: 7
G25: 8
J25: 3
K25: 2
L25: 2
M25: 1
N25: 0
O25: 0
P25: 14
B26: 13
C26: 5
D26: 34
E26: 31
F26: 9
G26: 8
J26: 0
K26: 2
L26: 6
M26: 5
N26: 0
O26: 1
P26: 8
J59: 1
K59: 2
L59: 3
M59: 4
N59: 5
O59: 6
P59: 6
B60: 0.11
C60: 0.08
D60: 0.31
E60: D60
F60: C60
G60: B60
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)
H19 = Sum(B19:G19)
H20 = Sum(B20:G20)
H27 = Sum(B27:G27)
H28 = Sum(B28:G28)
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)
b = Sum(G30:G34)
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)
Q27 = Sum(J27:P27)
J27 = Sum(J22:J26)
J28: J27 / $Q27
K27 = Sum(K22:K26)
K28: K27 / $Q27
L27 = Sum(L22:L26)
L28: L27 / $Q27
M27 = Sum(M22:M26)
M28: M27 / $Q27
N27 = Sum(N22:N26)
N28: N27 / $Q27
O27 = Sum(O22:O26)
O28: O27 / $Q27
P27 = Sum(P22:P26)
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: 12
L34: 4
M30: 3
M34: 4
N30: 0
N34: 0
O30: 2
O34: 0
J30: 1
J34: 0
L38: 3
L42: 8
M38: 5
M42: 5
N38: 3
N42: 1
O38: 1
O42: 0
K38: 2
K42: 2
c = Sum(K38:K42)
P38: 7
P42: 7
d = Sum(P38:P42)
K39: 1
P39: 8
Q39 = Sum(K39:P39)
K40: 4
P40: 5
Q40 = Sum(K40:P40)
K41: 2
P41: 5
Q41 = Sum(K41:P41)
Q42 = Sum(K42:P42)
J38: 2
J42: 2
L39: 7
M39: 4
N39: 0
O39: 2
J39: 0
L40: 10
M40: 4
N40: 2
O40: 0
J40: 5
L41: 9
M41: 8
N41: 1
O41: 0
J41: 2
L46: 4
L50: 0
M46: 3
M50: 0
N46: 0
N50: 0
O46: 2
O50: 0
K46: 2
K50: 0
P46: 9
P50: 0
K47: 1
P47: 10
K48: 0
P48: 0
K49: 0
P49: 0
J46: 5
J50: 0
L47: 4
M47: 2
N47: 0
O47: 1
J47: 4
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: 10
B31: 9
B32: 12
B33: 17
B34: 11
C30: 12
C31: 12
C32: 9
C33: 6
C34: 8
D30: 32
D31: 34
D32: 21
D33: 24
D34: 23
E30: 29
E31: 25
E32: 38
E33: 30
E34: 34
F30: 5
F31: 10
F32: 13
F33: 14
F34: 11
G30: 12
G31: 10
G32: 7
G33: 9
G34: 13
B38: 11
B39: 14
B40: 19
B41: 11
B42: 8
C38: 7
C39: 15
C40: 10
C41: 8
C42: 11
D38: 29
D39: 31
D40: 24
D41: 29
D42: 30
E38: 31
E39: 22
E40: 24
E41: 28
E42: 33
F38: 11
F39: 7
F40: 8
F41: 8
F42: 8
G38: 11
G39: 11
G40: 15
G41: 16
G42: 10
B46: 13
B47: 12
B48: 0
B49: 0
B50: 0
C46: 10
C47: 8
C48: 0
C49: 0
C50: 0
D46: 23
D47: 27
D48: 0
D49: 0
D50: 0
E46: 36
E47: 38
E48: 0
E49: 0
E50: 0
F46: 6
F47: 7
F48: 0
F49: 0
F50: 0
G46: 12
G47: 8
G48: 0
G49: 0
G50: 0
H52 = Sum(B52:G52)
H43 = Sum(B43:G43)
H55: H11 + H19 + H27 + H35 + H43 + H51
J35 = Sum(J30:J34)
J43 = Sum(J38:J42)
J55: J11 + J19 + J27 + J35 + J43
K35 = Sum(K30:K34)
K43 = Sum(K38:K42)
K55: K11 + K19 + K27 + K35 + K43
L35 = Sum(L30:L34)
L43 = Sum(L38:L42)
L55: L11 + L19 + L27 + L35 + L43
M35 = Sum(M30:M34)
M43 = Sum(M38:M42)
M55: M11 + M19 + M27 + M35 + M43
N35 = Sum(N30:N34)
N43 = Sum(N38:N42)
N55: N11 + N19 + N27 + N35 + N43
O35 = Sum(O30:O34)
O43 = Sum(O38:O42)
O55: O11 + O19 + O27 + O35 + O43
P35 = Sum(P30:P34)
P43 = Sum(P38:P42)
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: 2
P31: 9
Q31 = Sum(J31:P31)
J32: 1
P32: 6
Q32 = Sum(J32:P32)
J33: 3
P33: 9
Q33 = Sum(J33:P33)
P34: 3
Q34 = Sum(J34:P34)
Q35 = Sum(J35:P35)
Q36 = Sum(J36:P36)
K30: 1
K34: 0
K31: 0
K32: 2
K33: 0
L31: 6
L32: 8
L33: 6
M31: 4
M32: 4
M33: 3
N31: 0
N32: 2
N33: 0
O31: 1
O32: 1
O33: 3
P30: 6
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
h1: B68:G68
h2: h1 / (((B68 * C68) * D68))^(1 / 3)
A: B55:G55
J36: J35 / $Q35
K36: K35 / $Q35
L36: L35 / $Q35
M36: M35 / $Q35
N36: N35 / $Q35
O36: O35 / $Q35
P36: P35 / $Q35
J44: J43 / $Q43
K44: K43 / $Q43
L44: L43 / $Q43
M44: M43 / $Q43
N44: N43 / $Q43
O44: O43 / $Q43
P44: P43 / $Q43
J52: J51 / $Q51
K51 = Sum(K46:K50)
K52: K51 / $Q51
L52: L51 / $Q51
M52: M51 / $Q51
N52: N51 / $Q51
O52: O51 / $Q51
P51 = Sum(P46:P50)
P52: P51 / $Q51
H44 = Sum(B44:G44)
H38 = Sum(B38:G38)
H39 = Sum(B39:G39)
H40 = Sum(B40:G40)
H41 = Sum(B41:G41)
H42 = Sum(B42:G42)
B12: B11 / $H11
C12: C11 / $H11
D12: D11 / $H11
E12: E11 / $H11
F12: F11 / $H11
G12: G11 / $H11
B20: B19 / $H19
C20: C19 / $H19
D20: D19 / $H19
E20: E19 / $H19
F20: F19 / $H19
G20: G19 / $H19
B28: B27 / $H27
C28: C27 / $H27
D28: D27 / $H27
E28: E27 / $H27
F28: F27 / $H27
G28: G27 / $H27
i: B35 / $H35
C36: C35 / $H35
D36: D35 / $H35
E36: E35 / $H35
F36: F35 / $H35
j: G35 / $H35
B36: B35 / $H35
G36: G35 / $H35
C44: C43 / $H43
D44: D43 / $H43
E44: E43 / $H43
F44: F43 / $H43
B44: B43 / $H43
G44: G43 / $H43
C52: C51 / $H51
D52: D51 / $H51
E52: E51 / $H51
F52: F51 / $H51
k: B51 / $H51
l: G51 / $H51
B52: B51 / $H51
G52: G51 / $H51
H56 = Sum(B56:G56)
C55: C11 + C19 + C27 + C35 + C43 + C51
C56: C55 / $H55
D55: D11 + D19 + D27 + D35 + D43 + D51
D56: D55 / $H55
E55: E11 + E19 + E27 + E35 + E43 + E51
E56: E55 / $H55
F55: F11 + F19 + F27 + F35 + F43 + F51
F56: F55 / $H55
B55: B11 + B19 + B27 + B35 + B43 + B51
B56: B55 / $H55
G55: G11 + G19 + G27 + G35 + G43 + G51
G56: G55 / $H55
J70: B70
K70: (C70 * (1 - B70))
L70: ((D70 * (1 - B70)) * (1 - C70))
M70: (((E70 * (1 - B70)) * (1 - C70)) * (1 - D70))
N70: ((((F70 * (1 - B70)) * (1 - C70)) * (1 - D70)) * (1 - E70))
P70: ((((((1 - B70) * (1 - C70)) * (1 - D70)) * (1 - E70)) * (1 - F70)) * (1 - G70))
O70: (((((G70 * (1 - B70)) * (1 - C70)) * (1 - D70)) * (1 - E70)) * (1 - F70))