{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Une propriété de la règle de Bayes"]
[]
[null,"Faire varier"]
[null,"les a priori"]
[null,"et observer la colonne de l'a posteriori"]
[]
["P_VIH","Proportion de porteurs de VIH  "]
[null,"dans la population"]
["Test_Pos","Le test est positif"]
["VIH","être porteur de VIH"]
["non VIH","Ne pas être porteur de VIH",null,null,"Faux positif"]
[null,null,"A PRIORI","P( Test_Pos | VIH )","P( Test_Pos | non VIH )"]
[null,null,null,0.999,0.001]
[null,"FAUX…",null,"P_VIH","P( VIH | VIH_Pos )","A POSTERIORI"]
[null,"Faux négatif",null,0.0001,0.09083469721767595]
[null,"P( Test_Nég | VIH )",null,0.0002,0.1665555185061687]
[null,0.0010000000000000009,null,0.0003,0.23064491303678616]
[null,"Faux positif",null,0.0004,0.28559176672384223]
[null,"P( Test_Pos | non VIH )",null,0.0005,0.33322214809873246]
[null,0.001,null,0.0006,0.37490617963472606]
[null,null,null,0.0007,0.41169198163193216]
[null,null,null,0.0008,0.44439501779359436]
[null,null,null,0.0009,0.4736592561373933]
[null,null,null,0.001,0.5]
[null,null,null,0.0011,0.5238344932786728]