{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Module1","Chiffres","théorie"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":0,"reason":"part_missing"}],"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":"Chiffres","index":1,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[8,3,8,4]]}
[]
[]
[]
[null,null,null," "]
[null,null,null,null,null,"2 mêmes couleurs +15€"]
[null,null,"Gains",{"$f":"D15+E15","v":620},null,"sinon on perd 5€"]
[null,null,"Gains moy",{"$f":"D6/D9","v":6.2}]
[]
[null,null,null,100]
[]
["1er Jeton","2ème Jeton","Résultat"]
[2,1,0]
[2,1,0,"Nbre de 1","Nbre de 0"]
[1,1,1,{"$f":"COUNTIF(C:C,1)","v":56},{"$f":"COUNTIF(C:C,0)","v":44}]
[2,1,0,{"$f":"D14*15","v":840},{"$f":"E14*-5","v":-220},{"$f":"(D15+E15)","v":620},"gain"]
[1,1,1,null,null,{"$f":"F15/D9","v":6.2},"gain moyen"]
[1,1,1]
[1,1,1]
[1,2,0]
[1,1,1]
[1,1,1]
[2,2,1]
[1,1,1]
[1,2,0]
[1,1,1]
[1,2,0]
[1,1,1]
[2,2,1]
[2,1,0]
[1,2,0]
[1,1,1]
[1,2,0]
[1,2,0]
[1,1,1]
[1,2,0]
[2,2,1]
[1,2,0]
[2,1,0]
[2,1,0]
[1,1,1]
[2,1,0]
[2,1,0]
[1,2,0]
[1,1,1]
[1,2,0]
[2,2,1]
[1,1,1]
[1,1,1]
[1,1,1]
[1,1,1]
[1,1,1]
[2,1,0]
[1,1,1]
[1,1,1]
[2,2,1]
[1,1,1]
[1,1,1]
[1,2,0]
[1,2,0]
[1,1,1]
[2,1,0]
[1,1,1]
[1,1,1]
[1,1,1]
[1,1,1]
[1,2,0]
[1,1,1]
[1,2,0]
[1,1,1]
[1,2,0]
[2,1,0]
[2,2,1]
[1,1,1]
[2,1,0]
[1,1,1]
[2,2,1]
[1,1,1]
[1,1,1]
[1,2,0]
[1,2,0]
[1,1,1]
[1,2,0]
[2,1,0]
[1,2,0]
[1,2,0]
[2,1,0]
[1,1,1]
[2,2,1]
[1,2,0]
[1,2,0]
[1,1,1]
[1,1,1]
[2,2,1]
[1,1,1]
[1,1,1]
[1,2,0]
[1,1,1]
[1,1,1]
[1,2,0]
[1,2,0]
[1,1,1]
[1,1,1]
[2,1,0]
[2,1,0]
[1,2,0]
[1,2,0]
[1,1,1]
[1,2,0]
[2,2,1]
[1,1,1]
[1,1,1]

{"sheet":"théorie","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Un sac contient 3 jetons jaunes et 7 jetons mauves. On tire au hasard un jeton du sac. On note sa couleur et on le remet dans le sac. On réitère une fois ce tirage. Si on obtient deux jetons de même couleur, on gagne 15 €, sinon on perd 5 €."]
["1. On souhaite simuler cette expérience aléatoire."]
["a. Expliquer pourquoi, avec un tableur, la formule =ENT(ALEA()+0.3 renvoie 0 avec la probabilité 0.7 et 1 avec la probabilité 0.3."]
["b. Simuler 10 000 expériences."]
["c. Conjecturer alors une valeur approchée du gain moyen pas expérience à ce jeu."]
["2.a. Déterminer la loi de probabilité de la variable aléatoire donnant la gain à ce jeu."]
["b. Quel est le gain moyen ?"]
[]
[]
["proba pour tirer 1 jaune",null,{"$f":"3/10","v":0.3},null,"proba pour tirer 1 mauve",null,{"$f":"7/10","v":0.7}]
["proba pour tirer 2 jaunes",null,{"$f":"(3/10)^2","v":0.09},null,"proba pour tirer 2 mauves",null,{"$f":"(0.7)^2","v":0.48999999999999994}]
[]
["proba pour tirer 2 jaunes et 2 mauves",null,null,{"$f":"C11+G11","v":0.57999999999999996},"gains",{"$f":"D13*15","v":8.6999999999999993}]
["proba pour 2 couleurs non identiques",null,null,{"$f":"1-D13","v":0.42000000000000004},"perte",{"$f":"-D14*5","v":-2.1}]
[null,null,null,null,"bilan",{"$f":"F13+F14","v":6.6},"gain moyen"]