{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Aléa","Liste","Proba 36 fois","100 fois"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Aléa","index":0,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,14,24,14],[26,14,43,14]]}
[]
[null,null,null,"Tirage aléatoire",null,null,null,null,null,null,null,"1 000 000 fois 36 tirages",null,null,null,1000000]
[]
[null,"N°","Dé 1","Dé 2","Dé 3",null,"Egalité",null,"nb de Oui","nb de n",null,"Comptage du nombre de \"n\" (le prof qui gagne) à chaque groupe de 36 tirages"]
[null,1,{"$f":"1+INT(6*RAND())","v":4},{"$f":"1+INT(6*RAND())","v":1},1,null,{"$f":"IF(OR(C5=D5,C5=E5,D5=E5),\"Oui\",\"n\")","v":"Oui"},null,{"$f":"COUNTIF($G$5:$G$40,\"Oui\")","v":18},{"$f":"COUNTIF($G$5:$G$40,\"n\")","v":18}]
[null,2,{"$f":"1+INT(6*RAND())","v":4},5,1,null,{"$f":"IF(OR(C6=D6,C6=E6,D6=E6),\"Oui\",\"n\")","v":"n"},null,null,null,null,"X = k =","nb","Théorie","Cumuls partiels"]
[null,3,6,2,1,null,"n",null,"% de Oui","% de n",null,null,null,null,null,null,null,"Début",null,"2020-07-23T19:55:19"]
[null,4,3,5,2,null,"n",null,{"$f":"100*I5/36","v":50},{"$f":"100*J5/36","v":50},null,0,0,{"$f":"1000000*'Proba 36 fois'!D27","v":2.0961837406379272E-7},{"$f":"SUM(N8:N25)","v":200508.29335795733},null,null,"Fin",null,"2020-07-23T21:22:13"]
[null,5,5,4,4,null,"Oui",null,null,null,null,1,0,{"$f":"1000000*'Proba 36 fois'!D28","v":9.4328268328706767E-6}]
[null,6,3,2,2,null,"Oui",null,null,null,null,2,0,{"$f":"1000000*'Proba 36 fois'!D29","v":2.0634308696904611E-4},null,null,null,"Cumul des \"Oui\"",null,16002445]
[null,7,2,4,4,null,"Oui",null,null,null,null,3,0,{"$f":"1000000*'Proba 36 fois'!D30","v":2.9231937320614854E-3},null,null,null,"Moyenne du % des Oui",null,{"$f":"100*T10/36/P2","v":44.451236111111115}]
[null,8,1,2,4,null,"n",null,null,null,null,4,0,{"$f":"1000000*'Proba 36 fois'!D31","v":3.014543536188408E-2},null,null,null,"Théorie : 4/9",null,{"$f":"400/9","v":44.444444444444443}]
[null,9,4,6,5,null,"n",null,null,null,null,5,0,{"$f":"1000000*'Proba 36 fois'!D32","v":0.24116348289507269}]
[null,10,5,4,1,null,"n",null,null,null,null,6,1,{"$f":"1000000*'Proba 36 fois'!D33","v":1.5575141603640108}]
[null,11,4,2,6,null,"n",null,null,null,null,7,8,{"$f":"1000000*'Proba 36 fois'!D34","v":8.3438258590929166}]
[null,12,2,4,4,null,"Oui",null,null,null,null,8,42,{"$f":"1000000*'Proba 36 fois'!D35","v":37.807960924014793},null,null,null,"Conclusions"]
[null,13,5,3,1,null,"n",null,null,null,null,9,151,{"$f":"1000000*'Proba 36 fois'!D36","v":147.03095914894641}]
[null,14,5,4,4,null,"Oui",null,null,null,null,10,520,{"$f":"1000000*'Proba 36 fois'!D37","v":496.22948712769414},null,null,null,"Pour un lancer des trois dés, le prof a 5 chances sur 9 de gagner, 55,56 %"]
[null,15,3,3,1,null,"Oui",null,null,null,null,11,1478,{"$f":"1000000*'Proba 36 fois'!D38","v":1466.1325756045514},null,null,null,"Pour 36 lancers des trois dés,"]
[null,16,1,3,3,null,"Oui",null,null,null,null,12,3851,{"$f":"1000000*'Proba 36 fois'!D39","v":3818.0535823035193},null,null,null,null,"Le prof perd dans ",null,20,"% des cas"]
[null,17,5,2,3,null,"n",null,null,null,null,13,8760,{"$f":"1000000*'Proba 36 fois'!D40","v":8810.8928822388898},null,null,null,null,"Le gain est nul dans ",null,11,"% des cas"]
[null,18,3,6,1,null,"n",null,null,null,null,14,18194,{"$f":"1000000*'Proba 36 fois'!D41","v":18093.797883169151},null,null,null,null,"Le prof a un gain positif dans",null,69,"% des cas"]
[null,19,2,4,3,null,"n",null,null,null,null,15,33240,{"$f":"1000000*'Proba 36 fois'!D42","v":33171.962785810108}]
[null,20,1,3,6,null,"n",null,null,null,null,16,54763,{"$f":"1000000*'Proba 36 fois'!D43","v":54422.75144546973}]
[null,21,5,5,1,null,"Oui",null,null,null,null,17,79709,{"$f":"1000000*'Proba 36 fois'!D44","v":80033.458008043715}]
[null,22,4,4,5,null,"Oui",null,null,null,null,18,105308,{"$f":"1000000*'Proba 36 fois'!D45","v":105599.70153839102},{"$f":"N26","v":105599.70153839102}]
[null,23,5,2,5,null,"Oui",null,null,null,null,19,125266,{"$f":"1000000*'Proba 36 fois'!D46","v":125052.27813756834},{"$f":"SUM(N27:N44)","v":693892.00510365225}]
[null,24,6,3,5,null,"n",null,null,null,null,20,133249,{"$f":"1000000*'Proba 36 fois'!D47","v":132868.04552116638}]
[null,25,3,1,3,null,"Oui",null,null,null,null,21,126300,{"$f":"1000000*'Proba 36 fois'!D48","v":126540.99573444419}]
[null,26,1,3,4,null,"n",null,null,null,null,22,108152,{"$f":"1000000*'Proba 36 fois'!D49","v":107847.43954640131}]
[null,27,3,5,6,null,"n",null,null,null,null,23,81751,{"$f":"1000000*'Proba 36 fois'!D50","v":82057.83443747925}]
[null,28,1,3,4,null,"n",null,null,null,null,24,55300,{"$f":"1000000*'Proba 36 fois'!D51","v":55559.992067043255}]
[null,29,1,5,5,null,"Oui",null,null,null,null,25,33273,{"$f":"1000000*'Proba 36 fois'!D52","v":33335.995240225966}]
[null,30,3,3,3,null,"Oui",null,null,null,null,26,17612,{"$f":"1000000*'Proba 36 fois'!D53","v":17629.612867427189}]
[null,31,1,5,1,null,"Oui",null,null,null,null,27,8269,{"$f":"1000000*'Proba 36 fois'!D54","v":8161.8578089940711}]
[null,32,1,1,6,null,"Oui",null,null,null,null,28,3252,{"$f":"1000000*'Proba 36 fois'!D55","v":3279.3178696851191}]
[null,33,5,2,6,null,"n",null,null,null,null,29,1134,{"$f":"1000000*'Proba 36 fois'!D56","v":1130.7992654086615}]
[null,34,3,5,1,null,"n",null,null,null,null,30,332,{"$f":"1000000*'Proba 36 fois'!D57","v":329.81645241085954}]
[null,35,3,3,2,null,"Oui",null,null,null,null,31,77,{"$f":"1000000*'Proba 36 fois'!D58","v":79.794303002627316}]
[null,36,2,2,6,null,"Oui",null,null,null,null,32,7,{"$f":"1000000*'Proba 36 fois'!D59","v":15.584824805200649}]
[null,null,null,null,null,null,null,null,null,null,null,33,1,{"$f":"1000000*'Proba 36 fois'!D60","v":2.361337091697068}]
[null,null,null,null,null,null,null,null,null,null,null,34,0,{"$f":"1000000*'Proba 36 fois'!D61","v":0.26044159099600034}]
[null,null,null,null,null,null,null,null,null,null,null,35,0,{"$f":"1000000*'Proba 36 fois'!D62","v":1.8602970785428594E-2}]
[null,null,null,null,null,null,null,null,null,null,null,36,0,{"$f":"1000000*'Proba 36 fois'!D63","v":6.4593648560515922E-4}]

{"sheet":"Liste","index":1,"n_rows":220,"n_cols":10,"rows_kept":220,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Liste des jetés de dés"]
[]
[null,null,"Dé 1","Dé 2","Dé 3",null,"Egalité",null,"nb de Oui","nb de n"]
[null,null,1,1,1,null,{"$f":"IF(OR(C5=D5,C5=E5,D5=E5),\"Oui\",\"n\")","v":"Oui"},null,{"$f":"COUNTIF($G$5:$G$220,\"Oui\")","v":96},{"$f":"COUNTIF($G$5:$G$220,\"n\")","v":120}]
[null,null,1,1,2,null,{"$f":"IF(OR(C6=D6,C6=E6,D6=E6),\"Oui\",\"n\")","v":"Oui"}]
[null,null,1,1,3,null,{"$f":"IF(OR(C7=D7,C7=E7,D7=E7),\"Oui\",\"n\")","v":"Oui"},null,null,"% de Oui"]
[null,null,1,1,4,null,"Oui",null,null,{"$f":"100*I5/216","v":44.444444444444443}]
[null,null,1,1,5,null,"Oui"]
[null,null,1,1,6,null,"Oui"]
[null,null,1,2,1,null,"Oui"]
[null,null,1,2,2,null,"Oui"]
[null,null,1,2,3,null,"n"]
[null,null,1,2,4,null,"n"]
[null,null,1,2,5,null,"n"]
[null,null,1,2,6,null,"n"]
[null,null,1,3,1,null,"Oui"]
[null,null,1,3,2,null,"n"]
[null,null,1,3,3,null,"Oui"]
[null,null,1,3,4,null,"n"]
[null,null,1,3,5,null,"n"]
[null,null,1,3,6,null,"n"]
[null,null,1,4,1,null,"Oui"]
[null,null,1,4,2,null,"n"]
[null,null,1,4,3,null,"n"]
[null,null,1,4,4,null,"Oui"]
[null,null,1,4,5,null,"n"]
[null,null,1,4,6,null,"n"]
[null,null,1,5,1,null,"Oui"]
[null,null,1,5,2,null,"n"]
[null,null,1,5,3,null,"n"]
[null,null,1,5,4,null,"n"]
[null,null,1,5,5,null,"Oui"]
[null,null,1,5,6,null,"n"]
[null,null,1,6,1,null,"Oui"]
[null,null,1,6,2,null,"n"]
[null,null,1,6,3,null,"n"]
[null,null,1,6,4,null,"n"]
[null,null,1,6,5,null,"n"]
[null,null,1,6,6,null,"Oui"]
[null,null,2,1,1,null,"Oui"]
[null,null,2,1,2,null,"Oui"]
[null,null,2,1,3,null,"n"]
[null,null,2,1,4,null,"n"]
[null,null,2,1,5,null,"n"]
[null,null,2,1,6,null,"n"]
[null,null,2,2,1,null,"Oui"]
[null,null,2,2,2,null,"Oui"]
[null,null,2,2,3,null,"Oui"]
[null,null,2,2,4,null,"Oui"]
[null,null,2,2,5,null,"Oui"]
[null,null,2,2,6,null,"Oui"]
[null,null,2,3,1,null,"n"]
[null,null,2,3,2,null,"Oui"]
[null,null,2,3,3,null,"Oui"]
[null,null,2,3,4,null,"n"]
[null,null,2,3,5,null,"n"]
[null,null,2,3,6,null,"n"]
[null,null,2,4,1,null,"n"]
[null,null,2,4,2,null,"Oui"]
[null,null,2,4,3,null,"n"]
[null,null,2,4,4,null,"Oui"]
[null,null,2,4,5,null,"n"]
[null,null,2,4,6,null,"n"]
[null,null,2,5,1,null,"n"]
[null,null,2,5,2,null,"Oui"]
[null,null,2,5,3,null,"n"]
[null,null,2,5,4,null,"n"]
[null,null,2,5,5,null,"Oui"]
[null,null,2,5,6,null,"n"]
[null,null,2,6,1,null,{"$f":"IF(OR(C71=D71,C71=E71,D71=E71),\"Oui\",\"n\")","v":"n"}]
[null,null,2,6,2,null,"Oui"]
[null,null,2,6,3,null,"n"]
[null,null,2,6,4,null,"n"]
[null,null,2,6,5,null,"n"]
[null,null,2,6,6,null,"Oui"]
[null,null,3,1,1,null,"Oui"]
[null,null,3,1,2,null,"n"]
[null,null,3,1,3,null,"Oui"]
[null,null,3,1,4,null,"n"]
[null,null,3,1,5,null,"n"]
[null,null,3,1,6,null,"n"]
[null,null,3,2,1,null,"n"]
[null,null,3,2,2,null,"Oui"]
[null,null,3,2,3,null,"Oui"]
[null,null,3,2,4,null,"n"]
[null,null,3,2,5,null,"n"]
[null,null,3,2,6,null,"n"]
[null,null,3,3,1,null,"Oui"]
[null,null,3,3,2,null,"Oui"]
[null,null,3,3,3,null,"Oui"]
[null,null,3,3,4,null,"Oui"]
[null,null,3,3,5,null,"Oui"]
[null,null,3,3,6,null,"Oui"]
[null,null,3,4,1,null,"n"]
[null,null,3,4,2,null,"n"]
[null,null,3,4,3,null,"Oui"]
[null,null,3,4,4,null,"Oui"]
[null,null,3,4,5,null,"n"]
[null,null,3,4,6,null,"n"]
[null,null,3,5,1,null,"n"]
[null,null,3,5,2,null,"n"]
[null,null,3,5,3,null,"Oui"]
[null,null,3,5,4,null,"n"]
[null,null,3,5,5,null,"Oui"]
[null,null,3,5,6,null,"n"]
[null,null,3,6,1,null,"n"]
[null,null,3,6,2,null,"n"]
[null,null,3,6,3,null,"Oui"]
[null,null,3,6,4,null,"n"]
[null,null,3,6,5,null,"n"]
[null,null,3,6,6,null,"Oui"]
[null,null,4,1,1,null,"Oui"]
[null,null,4,1,2,null,"n"]
[null,null,4,1,3,null,"n"]
[null,null,4,1,4,null,"Oui"]
[null,null,4,1,5,null,"n"]
[null,null,4,1,6,null,"n"]
[null,null,4,2,1,null,"n"]
[null,null,4,2,2,null,"Oui"]
[null,null,4,2,3,null,"n"]
[null,null,4,2,4,null,"Oui"]
[null,null,4,2,5,null,"n"]
[null,null,4,2,6,null,"n"]
[null,null,4,3,1,null,"n"]
[null,null,4,3,2,null,"n"]
[null,null,4,3,3,null,"Oui"]
[null,null,4,3,4,null,"Oui"]
[null,null,4,3,5,null,"n"]
[null,null,4,3,6,null,"n"]
[null,null,4,4,1,null,"Oui"]
[null,null,4,4,2,null,"Oui"]
[null,null,4,4,3,null,"Oui"]
[null,null,4,4,4,null,"Oui"]
[null,null,4,4,5,null,{"$f":"IF(OR(C135=D135,C135=E135,D135=E135),\"Oui\",\"n\")","v":"Oui"}]
[null,null,4,4,6,null,"Oui"]
[null,null,4,5,1,null,"n"]
[null,null,4,5,2,null,"n"]
[null,null,4,5,3,null,"n"]
[null,null,4,5,4,null,"Oui"]
[null,null,4,5,5,null,"Oui"]
[null,null,4,5,6,null,"n"]
[null,null,4,6,1,null,"n"]
[null,null,4,6,2,null,"n"]
[null,null,4,6,3,null,"n"]
[null,null,4,6,4,null,"Oui"]
[null,null,4,6,5,null,"n"]
[null,null,4,6,6,null,"Oui"]
[null,null,5,1,1,null,"Oui"]
[null,null,5,1,2,null,"n"]
[null,null,5,1,3,null,"n"]
[null,null,5,1,4,null,"n"]
[null,null,5,1,5,null,"Oui"]
[null,null,5,1,6,null,"n"]
[null,null,5,2,1,null,"n"]
[null,null,5,2,2,null,"Oui"]
[null,null,5,2,3,null,"n"]
[null,null,5,2,4,null,"n"]
[null,null,5,2,5,null,"Oui"]
[null,null,5,2,6,null,"n"]
[null,null,5,3,1,null,"n"]
[null,null,5,3,2,null,"n"]
[null,null,5,3,3,null,"Oui"]
[null,null,5,3,4,null,"n"]
[null,null,5,3,5,null,"Oui"]
[null,null,5,3,6,null,"n"]
[null,null,5,4,1,null,"n"]
[null,null,5,4,2,null,"n"]
[null,null,5,4,3,null,"n"]
[null,null,5,4,4,null,"Oui"]
[null,null,5,4,5,null,"Oui"]
[null,null,5,4,6,null,"n"]
[null,null,5,5,1,null,"Oui"]
[null,null,5,5,2,null,"Oui"]
[null,null,5,5,3,null,"Oui"]
[null,null,5,5,4,null,"Oui"]
[null,null,5,5,5,null,"Oui"]
[null,null,5,5,6,null,"Oui"]
[null,null,5,6,1,null,"n"]
[null,null,5,6,2,null,"n"]
[null,null,5,6,3,null,"n"]
[null,null,5,6,4,null,"n"]
[null,null,5,6,5,null,"Oui"]
[null,null,5,6,6,null,"Oui"]
[null,null,6,1,1,null,"Oui"]
[null,null,6,1,2,null,"n"]
[null,null,6,1,3,null,"n"]
[null,null,6,1,4,null,"n"]
[null,null,6,1,5,null,"n"]
[null,null,6,1,6,null,"Oui"]
[null,null,6,2,1,null,"n"]
[null,null,6,2,2,null,"Oui"]
[null,null,6,2,3,null,"n"]
[null,null,6,2,4,null,"n"]
[null,null,6,2,5,null,"n"]
[null,null,6,2,6,null,"Oui"]
[null,null,6,3,1,null,"n"]
[null,null,6,3,2,null,"n"]
[null,null,6,3,3,null,{"$f":"IF(OR(C199=D199,C199=E199,D199=E199),\"Oui\",\"n\")","v":"Oui"}]
[null,null,6,3,4,null,"n"]
[null,null,6,3,5,null,"n"]
[null,null,6,3,6,null,"Oui"]
[null,null,6,4,1,null,"n"]
[null,null,6,4,2,null,"n"]
[null,null,6,4,3,null,"n"]
[null,null,6,4,4,null,"Oui"]
[null,null,6,4,5,null,"n"]
[null,null,6,4,6,null,"Oui"]
[null,null,6,5,1,null,"n"]
[null,null,6,5,2,null,"n"]
[null,null,6,5,3,null,"n"]
[null,null,6,5,4,null,"n"]
[null,null,6,5,5,null,"Oui"]
[null,null,6,5,6,null,"Oui"]
[null,null,6,6,1,null,"Oui"]
[null,null,6,6,2,null,"Oui"]
[null,null,6,6,3,null,"Oui"]
[null,null,6,6,4,null,"Oui"]
[null,null,6,6,5,null,"Oui"]
[null,null,6,6,6,null,"Oui"]

{"sheet":"Proba 36 fois","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Proba que x = k (loi binomiale)"]
[]
[null,"Voir : ","https://www.youtube.com/watch?v=rPUlc-Jn28Y "]
[]
[]
[]
[null,null,"Sur n épreuves à 2 issues avec succès du prof = 5/9 et succès de l'élève = 4/9"]
[]
[null,null,"Donc calculer ",null,"pour","n = 36"]
[null,null,null,null,null,"p = 5/9",null,null,"Somme des proba pour X = 0 à X = 17",null,null,null,{"$f":"SUM(D27:D44)","v":0.20050829335795733}]
[null,null,null,null,null,"(1 - p) = 4/9",null,null,"Proba que X = 18",null,null,null,{"$f":"D45","v":0.10559970153839102}]
[null,null,null,null,null,null,null,null,"Somme des proba pour X = 19 à X = 36",null,null,null,{"$f":"SUM(D46:D63)","v":0.69389200510365256}]
[null,null,null,null,"avec ","k de 0 à 36"]
[null,null,null,null,null,"n - k de 36 à 0"]
[]
[null,null,null,null,"et avec "]
[]
[]
[null,null,null,null,"C’est-à-dire :"]
[]
[]
[]
[null,null,null,null,null,"Cumul"]
[null,null,"k",null,"Cumul","inverse"]
[]
[null,null,0,{"$f":"FACT(36)/FACT(C27)/FACT(36-C27)*(5/9)^C27*(4/9)^(36-C27)","v":2.0961837406379272E-13},{"$f":"D27","v":2.0961837406379272E-13},{"$f":"F28+D27","v":1.0000000000000007}]
[null,null,1,{"$f":"FACT(36)/FACT(C28)/FACT(36-C28)*(5/9)^C28*(4/9)^(36-C28)","v":9.4328268328706761E-12},{"$f":"E27+D28","v":9.6424452069344696E-12},{"$f":"F29+D28","v":0.99999999999979095}]
[null,null,2,2.0634308696904611E-10,{"$f":"E28+D29","v":2.1598553217598058E-10},{"$f":"F30+D29","v":0.99999999999035816}]
[null,null,3,2.9231937320614854E-9,3.1391792642374659E-9,{"$f":"F31+D30","v":0.9999999997840151}]
[null,null,4,3.0145435361884079E-8,3.3284614626121546E-8,{"$f":"F32+D31","v":0.99999999686082142}]
[null,null,5,2.4116348289507269E-7,2.7444809752119425E-7,{"$f":"F33+D32","v":0.99999996671538605}]
[null,null,6,1.5575141603640107E-6,1.8319622578852051E-6,{"$f":"F34+D33","v":0.9999997255519032}]
[null,null,7,8.3438258590929173E-6,1.0175788116978122E-5,{"$f":"F35+D34","v":0.99999816803774288}]
[null,null,8,3.7807960924014796E-5,4.7983749040992918E-5,{"$f":"F36+D35","v":0.99998982421188376}]
[null,null,9,1.4703095914894642E-4,1.9501470818993934E-4,{"$f":"F37+D36","v":0.99995201625095975}]
[null,null,10,4.9622948712769413E-4,6.9124419531763352E-4,{"$f":"F38+D37","v":0.99980498529181083}]
[null,null,11,1.4661325756045514E-3,2.1573767709221849E-3,{"$f":"F39+D38","v":0.99930875580468315}]
[null,null,12,3.8180535823035193E-3,5.9754303532257042E-3,{"$f":"F40+D39","v":0.99784262322907857}]
[null,null,13,8.8108928822388903E-3,1.4786323235464595E-2,{"$f":"F41+D40","v":0.9940245696467751}]
[null,null,14,1.8093797883169151E-2,3.2880121118633747E-2,{"$f":"F42+D41","v":0.98521367676453619}]
[null,null,15,3.3171962785810111E-2,6.6052083904443865E-2,{"$f":"F43+D42","v":0.96711987888136708}]
[null,null,16,5.4422751445469729E-2,0.1204748353499136,{"$f":"F44+D43","v":0.93394791609555694}]
[null,null,17,8.003345800804372E-2,0.20050829335795733,{"$f":"F45+D44","v":0.87952516465008723}]
[null,null,18,0.10559970153839102,0.30610799489634832,{"$f":"F46+D45","v":0.7994917066420435}]
[null,null,19,0.12505227813756833,0.43116027303391669,{"$f":"F47+D46","v":0.69389200510365245}]
[null,null,20,0.13286804552116638,0.56402831855508306,{"$f":"F48+D47","v":0.56883972696608409}]
[null,null,21,0.12654099573444419,0.69056931428952728,{"$f":"F49+D48","v":0.43597168144491771}]
[null,null,22,0.1078474395464013,0.79841675383592858,{"$f":"F50+D49","v":0.3094306857104735}]
[null,null,23,8.2057834437479243E-2,0.88047458827340785,{"$f":"F51+D50","v":0.20158324616407217}]
[null,null,24,5.5559992067043255E-2,0.93603458034045106,{"$f":"F52+D51","v":0.11952541172659292}]
[null,null,25,3.3335995240225964E-2,0.96937057558067707,{"$f":"F53+D52","v":6.396541965954966E-2}]
[null,null,26,1.7629612867427188E-2,0.98700018844810422,{"$f":"F54+D53","v":3.0629424419323693E-2}]
[null,null,27,8.1618578089940712E-3,0.99516204625709825,{"$f":"F55+D54","v":1.2999811551896504E-2}]
[null,null,28,3.279317869685119E-3,0.99844136412678341,{"$f":"F56+D55","v":4.8379537429024322E-3}]
[null,null,29,1.1307992654086615E-3,0.99957216339219213,{"$f":"F57+D56","v":1.5586358732173132E-3}]
[null,null,30,3.2981645241085956E-4,0.99990197984460294,{"$f":"F58+D57","v":4.2783660780865162E-4}]
[null,null,31,7.9794303002627318E-5,0.99998177414760558,{"$f":"F59+D58","v":9.802015539779206E-5}]
[null,null,32,1.5584824805200649E-5,0.99999735897241082,{"$f":"F60+D59","v":1.8225852395164749E-5}]
[null,null,33,2.361337091697068E-6,0.99999972030950257,{"$f":"F61+D60","v":2.641027589964102E-6}]
[null,null,34,2.6044159099600033E-7,0.99999998075109353,{"$f":"F62+D61","v":2.7969049826703406E-7}]
[null,null,35,1.8602970785428593E-8,0.99999999935406436,{"$f":"F63+D62","v":1.9248907271033754E-8}]
[null,null,36,6.4593648560515924E-10,1.0000000000000009,{"$f":"D63","v":6.4593648560515924E-10}]

{"sheet":"100 fois","index":3,"n_rows":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":false,"merged":[[8,7,57,7],[59,7,108,7]]}
[]
[null,null,"Et si on jouait 100 fois !"]
[]
[]
[]
[null,null,null,null,null,null,null,"Cumuls"]
[null,null,"k",null,null,null,null,"partiels"]
[]
[null,null,0,{"$f":"FACT(100)/FACT(C9)/FACT(100-C9)","v":1},{"$f":"(5/9)^C9","v":1},{"$f":"(4/9)^(100-C9)","v":6.0498998981937206E-36},{"$f":"FACT(100)/FACT(C9)/FACT(100-C9)*(5/9)^C9*(4/9)^(100-C9)","v":6.0498998981937206E-36},{"$f":"SUM(G9:G58)","v":0.11173239955099412}]
[null,null,1,{"$f":"FACT(100)/FACT(C10)/FACT(100-C10)","v":100.00000000000003},{"$f":"(5/9)^C10","v":0.55555555555555558},{"$f":"(4/9)^(100-C10)","v":1.3612274770935872E-35},{"$f":"FACT(100)/FACT(C10)/FACT(100-C10)*(5/9)^C10*(4/9)^(100-C10)","v":7.5623748727421529E-34}]
[null,null,2,4950.0000000000009,0.30864197530864201,3.0627618234605715E-35,4.6792194525092078E-32]
[null,null,3,161699.99999999997,0.17146776406035669,6.8912141027862857E-35,1.9106812764412592E-30]
[null,null,4,3921225.0000000028,9.5259868922420388E-2,1.5505231731269142E-34,5.791752619212572E-29]
[null,null,5,75287520.000000015,5.2922149401344661E-2,3.4886771395355575E-34,1.390020628611017E-27]
[null,null,6,1192052400.000001,2.9401194111858146E-2,7.8495235639550055E-34,2.7510824941259731E-26]
[null,null,7,16007560800.000011,1.6333996728810082E-2,1.7661428018898758E-33,4.617888472282882E-25]
[null,null,8,186087894300.00009,9.074442627116713E-3,3.9738213042522216E-33,6.7103691862860649E-24]
[null,null,9,1902231808400,5.0413570150648407E-3,8.9410979345674989E-33,8.5743606269210785E-23]
[null,null,10,17310309456440.016,2.8007538972582451E-3,2.0117470352776875E-32,9.7533352131227381E-22]
[null,null,11,141629804643600,1.5559743873656919E-3,4.5264308293747963E-32,9.9750019225118808E-21]
[null,null,12,1050421051106700.5,8.6443021520316216E-4,1.0184469366093292E-31,9.2476580323287278E-20]
[null,null,13,7110542499799204,4.8023900844620124E-4,2.2915056073709911E-31,7.8249414119704643E-19]
[null,null,14,4.4186942677323592E+16,2.6679944913677846E-4,5.1558876165847306E-31,6.07830270394134E-18]
[null,null,15,2.5333847134998877E+17,1.4822191618709914E-4,1.1600747137315641E-30,4.3561169378246284E-17]
[null,null,16,1.3458606290468147E+18,8.2345508992832865E-5,2.6101681058960196E-30,2.8927339040241663E-16]
[null,null,17,6.6501348729372006E+18,4.5747504996018263E-5,5.8728782382660448E-30,1.7866885877796324E-15]
[null,null,18,3.0664510802988204E+19,2.5415280553343479E-5,1.3213976036098602E-29,1.0298274499007604E-14]
[null,null,19,1.3234157293921228E+20,1.4119600307413045E-5,2.9731446081221854E-29,5.5556480849909457E-14]
[null,null,20,5.3598337040380985E+20,7.8442223930072485E-6,6.6895753682749168E-29,2.8125468430266675E-13]
[null,null,21,2.0418414110621316E+21,4.3579013294484712E-6,1.5051544578618565E-28,1.3393080204888887E-12]
[null,null,22,7.3320668851776594E+21,2.4210562941380397E-6,3.3865975301891776E-28,6.0116666828762664E-12]
[null,null,23,2.4865270306254661E+22,1.3450312745211332E-6,7.6198444429256482E-28,2.5484239199149374E-11]
[null,null,24,7.9776075565900367E+22,7.4723959695618519E-7,1.7144649996582713E-27,1.0220241762158867E-10]
[null,null,25,2.4251926972033712E+23,4.1513310942010287E-7,3.8575462492311109E-27,3.8836918696203701E-10]
[null,null,26,6.9957481650097234E+23,2.3062950523339053E-7,8.6794790607699987E-27,1.4003696645265758E-9]
[null,null,27,1.9173532007804428E+24,1.281275029074392E-7,1.9528827886732497E-26,4.7975627395817882E-9]
[null,null,28,4.9988137020347265E+24,7.1181946059688438E-8,4.3939862745148123E-26,1.5634914285244221E-8]
[null,null,29,1.241084781194829E+25,3.9545525588715804E-8,9.8864691176583279E-26,4.8522147781792438E-8]
[null,null,30,2.9372339821610947E+25,2.1969736438175447E-8,2.224455551473124E-25,1.4354468718780262E-7]
[null,null,31,6.6324638306863446E+25,1.2205409132319692E-8,5.0050249908145291E-25,4.0516645577202355E-7]
[null,null,32,1.430125013491743E+26,6.7807828512887183E-9,1.1261306229332691E-24,1.0920502128230324E-6]
[null,null,33,2.9469242702254069E+26,3.7671015840492885E-9,2.5337939015998558E-24,2.8128566087865967E-6]
[null,null,34,5.807174297208895E+26,2.0928342133607158E-9,5.7010362785996752E-24,6.9287276760552243E-6]
[null,null,35,1.0950671531879631E+27,1.1626856740892867E-9,1.2827331626849269E-23,1.6332000950701603E-5]
[null,null,36,1.9772045821449335E+27,6.4593648560515924E-10,2.8861496160410857E-23,3.6860418812347368E-5]
[null,null,37,3.4200295474939398E+27,3.5885360311397737E-10,6.4938366360924447E-23,7.9698202837507866E-5]
[null,null,38,5.6700489866346885E+27,1.9936311284109856E-10,1.4611132431208001E-22,1.6516403877509854E-4]
[null,null,39,9.0139240300346341E+27,1.1075728491172143E-10,3.2875047970217999E-22,3.2821058987359328E-4]
[null,null,40,1.374623414580281E+28,6.1531824950956352E-11,7.39688579329905E-22,6.2565143694653697E-4]
[null,null,41,2.0116440213369981E+28,3.4184347194975751E-11,1.6642993034922866E-21,1.1444843358778126E-3]
[null,null,42,2.8258808871162574E+28,1.8991303997208754E-11,3.7446734328576448E-21,2.0096599945473486E-3]
[null,null,43,3.8116532895986722E+28,1.0550724442893753E-11,8.4255152239297002E-21,3.3883802233647146E-3]
[null,null,44,4.9378235797073733E+28,5.8615135793854186E-12,1.8957409253841826E-20,5.4868657026076384E-3]
[null,null,45,6.1448471214136243E+28,3.2563964329918993E-12,4.2654170821144116E-20,8.5351244262785557E-3]
[null,null,46,7.3470998190815046E+28,1.8091091294399441E-12,9.5971884347574272E-20,1.2756300093622839E-2]
[null,null,47,8.4413487283064076E+28,1.0050606274666355E-12,2.1593673978204208E-19,1.8320218219564706E-2]
[null,null,48,9.3206558875049897E+28,5.5836701525924205E-13,4.8585766450959474E-19,2.5285717855128374E-2]
[null,null,49,9.8913082887808039E+28,3.1020389736624558E-13,1.0931797451465883E-18,3.354227878741519E-2]
[null,null,50,1.0089134454556424E+29,1.723354985368031E-13,2.4596544265798238E-18,4.2766405453954381E-2,{"$f":"G59","v":4.2766405453954381E-2}]
[null,null,51,9.8913082887808039E+28,9.5741943631557296E-14,5.5342224598046033E-18,5.2409810605336241E-2,{"$f":"SUM(G60:G109)","v":0.84550119499505272}]
[null,null,52,9.3206558875049897E+28,5.3189968684198505E-14,1.2452000534560357E-17,6.1732709607247027E-2]
[null,null,53,8.4413487283064058E+28,2.9549982602332499E-14,2.801700120276081E-17,6.9886086347826837E-2]
[null,null,54,7.3470998190815037E+28,1.6416657001295834E-14,6.3038252706211831E-17,7.6033473572867202E-2]
[null,null,55,6.1448471214136243E+28,9.1203650007199086E-15,1.418360685889766E-16,7.9489540553452101E-2]
[null,null,56,4.9378235797073733E+28,5.0668694448443944E-15,3.191311543251974E-16,7.984440457377999E-2]
[null,null,57,3.8116532895986722E+28,2.8149274693579964E-15,7.180450972316942E-16,7.7042846518559582E-2]
[null,null,58,2.8258808871162569E+28,1.5638485940877763E-15,1.6156014687713121E-15,7.139746552366516E-2]
[null,null,59,2.0116440213369981E+28,8.688047744932091E-16,3.635103304735452E-15,6.3531643050719053E-2]
[null,null,60,1.374623414580281E+28,4.8266931916289388E-16,8.1789824356547662E-15,5.4266611772489134E-2]
[null,null,61,9.0139240300346352E+27,2.6814962175716331E-16,1.8402710480223226E-14,4.4480829321712455E-2]
[null,null,62,5.6700489866346885E+27,1.4897201208731295E-16,4.1406098580502261E-14,3.4974845636023898E-2]
[null,null,63,3.4200295474939398E+27,8.2762228937396083E-17,9.3163721806130089E-14,2.6369923297002152E-2]
[null,null,64,1.9772045821449332E+27,4.5979016076331158E-17,2.0961837406379272E-13,1.9056389882599202E-2]
[null,null,65,{"$f":"FACT(100)/FACT(C74)/FACT(100-C74)","v":1.0950671531879631E+27},{"$f":"(5/9)^C74","v":2.5543897820183979E-17},{"$f":"(4/9)^(100-C74)","v":4.7164134164353364E-13},{"$f":"FACT(100)/FACT(C74)/FACT(100-C74)*(5/9)^C74*(4/9)^(100-C74)","v":1.3192885303337913E-2}]
[null,null,66,5.8071742972088957E+26,1.4191054344546657E-17,1.0611930186979508E-12,8.7452838185005134E-3]
[null,null,67,2.9469242702254069E+26,7.8839190803036983E-18,2.3876842920703892E-12,5.5473815266607685E-3]
[null,null,68,1.4301250134917432E+26,4.3799550446131659E-18,5.3722896571583759E-12,3.3651395290405436E-3]
[null,null,69,6.6324638306863446E+25,2.4333083581184255E-18,1.2087651728606347E-11,1.9508055240814745E-3]
[null,null,70,2.9372339821610947E+25,1.3518379767324588E-18,2.7197216389364282E-11,1.0799102008308161E-3]
[null,null,71,1.2410847811948288E+25,7.510210981846993E-19,6.1193736876069632E-11,5.7037510607261404E-4]
[null,null,72,4.9988137020347265E+24,4.172339434359441E-19,1.3768590797115669E-10,2.8716802215461476E-4]
[null,null,73,1.9173532007804428E+24,2.3179663524219117E-19,3.0979329293510259E-10,1.3768329829330845E-4]
[null,null,74,6.9957481650097234E+23,1.28775908467884E-19,6.9703490910398087E-10,6.2794747532421105E-5]
[null,null,75,2.4251926972033716E+23,7.1542171371046676E-20,1.5683285454839568E-9,2.7211057264049152E-5]
[null,null,76,7.9776075565900367E+22,3.9745650761692596E-20,3.5287392273389029E-9,1.1188757098704418E-5]
[null,null,77,2.4865270306254661E+22,2.2080917089829221E-20,7.9396632615125323E-9,4.3592560124822413E-6]
[null,null,78,7.3320668851776594E+21,1.2267176161016235E-20,1.78642423384032E-8,1.6067770558828786E-6]
[null,null,79,2.0418414110621316E+21,6.8150978672312416E-21,4.0194545261407193E-8,5.59321127047837E-7]
[null,null,80,5.3598337040380985E+20,3.7861654817951345E-21,9.0437726838166197E-8,1.8352724481257166E-7]
[null,null,81,1.3234157293921228E+20,2.1034252676639636E-21,2.0348488538587396E-7,5.6644211361904824E-8]
[null,null,82,3.0664510802988204E+19,1.1685695931466465E-21,4.5784099211821645E-7,1.6406097802990727E-8]
[null,null,83,6.6501348729372006E+18,6.4920532952591473E-22,1.030142232265987E-6,4.4474361514131489E-9]
[null,null,84,1.3458606290468147E+18,3.6066962751439713E-22,2.3178200225984708E-6,1.1250954549705884E-9]
[null,null,85,2.5333847134998877E+17,2.0037201528577619E-22,5.2150950508465602E-6,2.6472834234602104E-10]
[null,null,86,4.4186942677323584E+16,1.1131778626987567E-22,1.1733963864404761E-5,5.7716935104510364E-11]
[null,null,87,7110542499799205,6.1843214594375369E-23,2.6401418694910709E-5,1.1609728325619909E-11]
[null,null,88,1050421051106700.4,3.4357341441319656E-23,5.9403192063549106E-5,2.1438418783104949E-12]
[null,null,89,141629804643600,1.9087411911844251E-23,1.3365718214298551E-4,3.6132166488379111E-13]
[null,null,90,17310309456440.016,1.0604117728802364E-23,3.0072865982171739E-4,5.5201921023912591E-14]
[null,null,91,1902231808400,5.8911765160013139E-24,6.7663948459886411E-4,7.5826814593286456E-15]
[null,null,92,186087894300.00006,3.2728758422229518E-24,1.5224388403474443E-3,9.2723006975486194E-16]
[null,null,93,16007560800.000013,1.8182643567905291E-24,3.4254873907817499E-3,9.9702158038157265E-17]
[null,null,94,1192052400.000001,1.0101468648836273E-24,7.7073466292589378E-3,9.2807859875944272E-18]
[null,null,95,75287520,5.6119270271312622E-25,1.7341529915832609E-2,7.3269363059955926E-19]
[null,null,96,3921225.0000000033,3.1177372372951459E-25,3.9018442310623375E-2,4.7701408242158854E-20]
[null,null,97,161699.99999999997,1.732076242941748E-25,8.77914951989026E-2,2.4588354763999392E-21]
[null,null,98,4950.0000000000009,9.6226457941208221E-26,0.19753086419753085,9.4088092209181386E-23]
[null,null,99,100.00000000000003,5.3459143300671237E-26,0.44444444444444442,2.3759619244742777E-24]
[null,null,100,1,2.9699524055928468E-26,1,2.9699524055928468E-26]
[]
[null,null,null,null,null,null,{"$f":"SUM(G9:G109)","v":1.0000000000000009}]