{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[8,1,15,3],[4,5,4,6],[5,5,5,6],[3,5,3,6]]}
[]
[null,null,"Loi à simuler :",null,null,null,null,null,null,"Comparaison des facteurs de correction :"]
[null,"Loi =","Normale",null,null,null,"n",{"$f":"Nmin","v":2},{"$f":"H3+1","v":3},{"$f":"I3+1","v":4},5,6,7]
[null,"Variance",3,null,null,{"$f":"IF(Paramètre=\"Variance\",\"Variance expérimentale\",\"Ecart-type expérimental\")","v":"Variance expérimentale"},null,{"$f":"TRANSPOSE(C51:C56)","v":2.9171690550417999},3.0627403504586388,3.058545001381908,3.0093880984985697,3.0104451901982903,2.9864571813990377]
[null,"Nb de simulations =",6000,"(Max 30000)",null,{"$f":"IF(Paramètre=\"Variance\",\"Correction théorique\",\"Correction théorique (1/c4)\")","v":"Correction théorique"},null,{"$f":"IF(Paramètre=\"Variance\",1,TRANSPOSE(F51:F56))","v":1},1,1,1,1,1]
[null,null,"Nombre de répétitions :",null,null,"Correction expérimentale",null,{"$f":"$C$4/TRANSPOSE(C51:C56)","v":1.0283942902846313},0.97951496265452487,0.98085854504169256,0.99688039621634261,0.99653035031752157,1.0045347439385077]
[null,"De :",2]
[null,"à :",{"$f":"Nmin+5","v":7}]
[null,"Choisir un écart-type théorique et le nombre de simulations. Sélectionner les nombres min et max de réalisations servant à calculer les écart-types.\nLancer le calcul. Exemple: pour N = 5000 et un nombre min de répétitions = 2, le programme calcule 5000 fois l'écart-type de 2 valeurs distribuées selon une loi normale, 5000 fois l'écart-type de 3 valeurs, etc et renvoit les moyennes de ces écarts-types."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"www.acei-services.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2,2.9171690550417999,4.0991881103277192,3,1.2533141373154999]
[null,3,3.0627403504586388,3.0795595732675727,3,1.1283791670955126]
[null,4,3.058545001381908,2.4678825494978542,3,1.0854018818374014]
[null,5,3.0093880984985697,2.1189825699742237,3,1.0638460810704871]
[null,6,3.0104451901982903,1.9169904182167972,3,1.0509358530746116]
[null,7,2.9864571813990377,1.7032431550038909,3,1.042352025392896]