{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[7,1,9,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":99.610562704271345},{"$f":"IF(Moyenne=0,\"\",(J4-Moyenne)/Moyenne)","v":-3.8943729572865492E-3}]
[null,{"$f":"IF(Loi=\"Normale\",\"Ecart-type =\",\"Variation =\")","v":"Ecart-type ="},1,null,null,null,null,"Ecart-type =",{"$f":"IF(Loi=\"Normale\",stdev,(stdev)/SQRT(3))","v":1},{"$f":"STDEV(Mat)","v":0.90879498401707526},{"$f":"(J5-I5)/I5","v":-9.1205015982924742E-2}]
[null,"Nb d'itérations =",10,"(max 1000000)"]
[]
[null,"Sélectionner la loi (normale ou uniforme), ses paramètres et le nombre de simulations.\nTaper F9 pour faire une nouvelle simulation."]
[]
[]
[]
[null,null,"Résultats expérimentaux :"]
[null,"Min =",{"$f":"MIN(Mat)","v":97.98702241552995}]
[null,"Max =",{"$f":"MAX(Mat)","v":100.92624753274502}]
[null,"C =",{"$f":"MAX(INT(8*stdev+8),INT(SQRT(N)))","v":16},{"$f":"IF(C15=1,\"classe\",\"classes\")","v":"classes"}]
[null,"It =",{"$f":"MAX(8*stdev,(Max-Min))/NbClasses","v":0.5},"(Largeur d'intervalle)"]
[null,"Moyenne =",{"$f":"J4","v":99.610562704271345}]
[null,"Ecart-type =",{"$f":"J5","v":0.90879498401707526}]
[]
[]
[]
[]
[null,null,"www.lametrologie.com"]
[]
[]
[]
[]
[]
[]
[null,"Tirage","Classes","Fréquences","Loi théorique"]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":100.92624753274502},{"$f":"Moyenne-4*stdev+0*It","v":96},{"$f":"FREQUENCY(B31:B40,C31:C46)/N","v":0},{"$f":"NORMDIST(C31,Moyenne,stdev,FALSE)*It","v":6.6915112882442684E-5}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":99.478297252781829},{"$f":"Moyenne-4*stdev+1*It","v":96.5},0,{"$f":"NORMDIST(C32,Moyenne,stdev,FALSE)*It","v":4.3634134752288008E-4}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":99.989795930093408},{"$f":"Moyenne-4*stdev+2*It","v":97},0,{"$f":"NORMDIST(C33,Moyenne,stdev,FALSE)*It","v":2.2159242059690038E-3}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":99.273190490217587},{"$f":"Moyenne-4*stdev+3*It","v":97.5},0,{"$f":"NORMDIST(C34,Moyenne,stdev,FALSE)*It","v":8.7641502467842702E-3}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":97.98702241552995},{"$f":"Moyenne-4*stdev+4*It","v":98},0.1,{"$f":"NORMDIST(C35,Moyenne,stdev,FALSE)*It","v":2.6995483256594031E-2}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":100.00069006069629},{"$f":"Moyenne-4*stdev+5*It","v":98.5},0,{"$f":"NORMDIST(C36,Moyenne,stdev,FALSE)*It","v":6.4758797832945872E-2}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":99.619194296461131},{"$f":"Moyenne-4*stdev+6*It","v":99},0.1,{"$f":"NORMDIST(C37,Moyenne,stdev,FALSE)*It","v":0.12098536225957168}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":98.538203696905953},{"$f":"Moyenne-4*stdev+7*It","v":99.5},0.3,{"$f":"NORMDIST(C38,Moyenne,stdev,FALSE)*It","v":0.17603266338214976}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":99.470303477567313},{"$f":"Moyenne-4*stdev+8*It","v":100},0.2,{"$f":"NORMDIST(C39,Moyenne,stdev,FALSE)*It","v":0.19947114020071635}]
[null,{"$f":"NORMINV(RAND(),Moyenne,stdev)","v":100.82268188971486},{"$f":"Moyenne-4*stdev+9*It","v":100.5},0.1,{"$f":"NORMDIST(C40,Moyenne,stdev,FALSE)*It","v":0.17603266338214976}]
[null,null,{"$f":"Moyenne-4*stdev+10*It","v":101},0.2,{"$f":"NORMDIST(C41,Moyenne,stdev,FALSE)*It","v":0.12098536225957168}]
[null,null,{"$f":"Moyenne-4*stdev+11*It","v":101.5},0,{"$f":"NORMDIST(C42,Moyenne,stdev,FALSE)*It","v":6.4758797832945872E-2}]
[null,null,{"$f":"Moyenne-4*stdev+12*It","v":102},0,{"$f":"NORMDIST(C43,Moyenne,stdev,FALSE)*It","v":2.6995483256594031E-2}]
[null,null,{"$f":"Moyenne-4*stdev+13*It","v":102.5},0,{"$f":"NORMDIST(C44,Moyenne,stdev,FALSE)*It","v":8.7641502467842702E-3}]
[null,null,{"$f":"Moyenne-4*stdev+14*It","v":103},0,{"$f":"NORMDIST(C45,Moyenne,stdev,FALSE)*It","v":2.2159242059690038E-3}]
[null,null,{"$f":"Moyenne-4*stdev+15*It","v":103.5},0,{"$f":"NORMDIST(C46,Moyenne,stdev,FALSE)*It","v":4.3634134752288008E-4}]
[null,null,{"$f":"Moyenne-4*stdev+16*It","v":104},0,{"$f":"NORMDIST(C47,Moyenne,stdev,FALSE)*It","v":6.6915112882442684E-5}]

{"sheet":"Feuil2","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Commentaire"]
["1.2","Le programme génère une loi rectangle ou normale à chaque rafraîchissement. Un tableau compare les moyennes et écarts-types théoriques et expérimentaux.\nProblème : les courbes expérimentale et théoriques ne sont pas sur la même échelle. Prochaine version : une seule échelle d'abscisse."]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}