{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Feuil1","index":0,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,1,10,3]]}
[]
[null,null,"Loi à simuler :",null,null,null,null,null,null,"Comparaison :"]
[null,"Loi =","Normale",null,null,null,null,null,"Théorique","Empirique","Erreur (%)"]
[null,"Moyenne =",100,null,null,null,null,"Moyenne =",{"$f":"Moyenne","v":100},{"$f":"AVERAGE(Mat)","v":100.52673542046449},{"$f":"IF(Moyenne=0,\"\",(J4-Moyenne)/Moyenne)","v":5.2673542046449027E-3}]
[null,"Incertitude (k=2) =",0.8,null,null,null,null,"Ecart-type =",{"$f":"IF(Loi=\"Normale\",stdev,(stdev)/SQRT(3))","v":0.8},{"$f":"STDEV(Mat)","v":{"$error":"#DIV/0!"}},{"$f":"(J5-I5)/I5","v":{"$error":"#DIV/0!"}}]
[null,"Nb d'itérations =",1,"(max 1000000)"]
[null,"Nb de résultats =",10,"(2 à 10)"]
[null,"EMT = ",1]
[null,"Sélectionner les paramètres de la loi et le nombre de répétitions de la mesure. Choisir le nombre de résultats pour l'historique et l'EMT. Lancer le test."]
[]
[]
[]
[null,null,"Résultats expérimentaux :"]
[null,"Min =",{"$f":"MIN(Mat)","v":100.52673542046449}]
[null,"Max =",{"$f":"MAX(Mat)","v":100.52673542046449}]
[null,"C =",{"$f":"INT(SQRT(N))","v":1},{"$f":"IF(C16=1,\"classe\",\"classes\")","v":"classe"}]
[null,"It =",{"$f":"(Max-Min)/C16","v":0},"(Largeur d'intervalle)"]
[null,"Moyenne =",{"$f":"J4","v":100.52673542046449}]
[null,"Ecart-type =",{"$f":"J5","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[null,null,"www.acei-services.com"]
[]
[]
[]
[null,"Tirage","Classes","Fréquences","Loi théorique"]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev/2)","v":100.52673542046449},{"$f":"Min+0*It","v":100.52673542046449},{"$f":"FREQUENCY(B31:B31,C31:C31)/N","v":1},null,null,null,null,1,{"$f":"Moyenne-$C$8","v":99},{"$f":"Moyenne+$C$8","v":101},100.05849062383444]
[null,null,{"$f":"Min+1*It","v":100.52673542046449},0,null,null,null,null,2,99,101,100.491853207086]
[null,null,null,null,null,null,null,null,3,99,101,100.46349103893331]
[null,null,null,null,null,{"$f":"Moyenne+(-2)/5*3*stdev","v":99.04},{"$f":"NORMDIST(F34,Moyenne,stdev,FALSE)/INT(SQRT(N))*(Max-Min)","v":0},null,4,99,101,100.18885429050863]
[null,null,null,null,null,{"$f":"Moyenne+(-1)/5*3*stdev","v":99.52},0,null,5,99,101,99.900762735383253]
[null,null,null,null,null,{"$f":"Moyenne+(0)/5*3*stdev","v":100},0,null,6,99,101,99.978513801091523]
[null,null,null,null,null,{"$f":"Moyenne+(1)/5*3*stdev","v":100.48},0,null,7,99,101,99.523703673516025]
[null,null,null,null,null,{"$f":"Moyenne+(2)/5*3*stdev","v":100.96},0,null,8,99,101,100.21101923063364]
[null,null,null,null,null,{"$f":"Moyenne+(3)/5*3*stdev","v":101.44},0,null,9,99,101,100.06040295055564]
[null,null,null,null,null,{"$f":"Moyenne+(4)/5*3*stdev","v":101.92},0,null,10,99,101,99.429420429262777]
[null,null,null,null,null,{"$f":"Moyenne+(5)/5*3*stdev","v":102.4},0]