{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","BNGraph","Probability tables","Bayesian network analysis","Xlstatinfo"],"not_rendered":{"charts":13,"images":23,"macros":1,"external_links":0,"defined_names":4,"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":"Data","index":0,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Age","S","E","Job","City","T"]
[25,"M","l1","lib","B","Car"]
[45,"W","l2","nonlib","S","Train"]
[60,"M","l1","lib","B","Autre"]
[45,"W","l1","nonlib","S","Car"]
[60,"M","l1","nonlib","B","Train"]
[25,"W","l1","nonlib","B","Autre"]
[45,"M","l1","nonlib","B","Car"]
[25,"W","l1","nonlib","S","Train"]
[60,"M","l2","nonlib","S","Autre"]
[60,"W","l1","nonlib","S","Car"]
[45,"M","l2","nonlib","B","Train"]
[60,"W","l1","nonlib","S","Autre"]
[45,"M","l1","nonlib","B","Car"]
[25,"W","l1","nonlib","B","Train"]
[60,"M","l2","nonlib","B","Autre"]
[45,"W","l1","lib","S","Car"]
[25,"M","l2","lib","B","Train"]
[60,"W","l1","lib","S","Autre"]
[25,"M","l2","lib","B","Car"]
[60,"W","l1","lib","S","Train"]
[60,"M","l2","lib","B","Autre"]
[45,"W","l1","lib","B","Car"]
[60,"M","l1","lib","B","Train"]
[60,"W","l1","lib","B","Autre"]
[45,"M","l1","lib","B","Car"]
[60,"W","l2","lib","B","Car"]
[60,"M","l1","nonlib","B","Car"]
[45,"W","l1","nonlib","S","Car"]
[45,"M","l2","lib","B","Car"]
[45,"W","l1","nonlib","B","Car"]
[45,"M","l2","nonlib","B","Car"]
[60,"W","l1","nonlib","S","Car"]
[25,"M","l2","lib","B","Car"]
[60,"W","l1","lib","B","Car"]
[45,"M","l1","lib","S","Car"]
[60,"W","l2","lib","B","Car"]
[25,"M","l1","lib","B","Car"]
[45,"W","l2","lib","S","Car"]
[25,"M","l2","lib","S","Car"]
[45,"W","l1","lib","B","Car"]
[25,"M","l1","nonlib","S","Autre"]
[45,"W","l1","nonlib","S","Autre"]
[25,"M","l1","nonlib","B","Autre"]
[25,"W","l1","nonlib","S","Autre"]
[60,"M","l2","nonlib","B","Train"]
[60,"W","l2","nonlib","S","Train"]
[25,"M","l1","nonlib","B","Train"]
[60,"W","l1","lib","S","Train"]
[60,"M","l1","lib","B","Train"]
[25,"W","l1","nonlib","B","Train"]

{"sheet":"BNGraph","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"<"]

{"sheet":"Probability tables","index":2,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Select the data - Start time: 26/04/2021 at 15:47:21 / End time: 26/04/2021 at 15:47:22 / Microsoft Excel 16.013901"]
[null,"Qualitative data: Workbook = BNBook1 / Sheet = Data / Range = Data!$B:$F / 50 rows and 5 columns"]
[null,"Quantitative data: Workbook = BNBook1 / Sheet = Data / Range = Data!$A:$A / 50 rows and 1 column"]
[]
[]
[]
[]
[null,"Data summary:"]
[]
[null,"Summary statistics (Qualitative data):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Age","[25,000; 45,000[",14,14,28]
[null,"","[45,000; 60,000[",16,16,32]
[null,"","[60,000; 60,000]",20,20,40]
[null,"S","M",25,25,50]
[null,"","W",25,25,50]
[null,"E","l1",34,34,68]
[null,"","l2",16,16,32]
[null,"Job","lib",24,24,48]
[null,"","nonlib",26,26,52]
[null,"City","B",31,31,62]
[null,"","S",19,19,38]
[null,"T","Autre",12,12,24]
[null,"","Car",24,24,48]
[null,"","Train",14,14,28]
[]
[]
[null,"Probability distributions of each node:"]
[]
[]
[null,"Probability distribution of node Age, p(Age):"]
[]
[null,"Age","Probability"]
[null,"[25,000; 45,000[",0.28000000000000003]
[null,"[45,000; 60,000[",0.32]
[null,"[60,000; 60,000]",0.4]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[null,"Probability distribution of node S, p(S):"]
[]
[null,"S","Probability"]
[null,"M",0.5]
[null,"W",0.5]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[null,"Probability distribution of node E, p(E|Age|S):"]
[]
[null,"E","Age","S","Probability"]
[null,"l1","[25,000; 45,000[","M",0.55555555555555558]
[null,"l2","[25,000; 45,000[","M",0.44444444444444442]
[null,"l1","[45,000; 60,000[","M",0.5714285714285714]
[null,"l2","[45,000; 60,000[","M",0.42857142857142855]
[null,"l1","[60,000; 60,000]","M",0.55555555555555558]
[null,"l2","[60,000; 60,000]","M",0.44444444444444442]
[null,"l1","[25,000; 45,000[","W",1]
[null,"l2","[25,000; 45,000[","W",0]
[null,"l1","[45,000; 60,000[","W",0.77777777777777779]
[null,"l2","[45,000; 60,000[","W",0.22222222222222221]
[null,"l1","[60,000; 60,000]","W",0.72727272727272729]
[null,"l2","[60,000; 60,000]","W",0.27272727272727271]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[null,"Probability distribution of node Job, p(Job|E):"]
[]
[null,"Job","E","Probability"]
[null,"lib","l1",0.44117647058823528]
[null,"nonlib","l1",0.55882352941176472]
[null,"lib","l2",0.5625]
[null,"nonlib","l2",0.4375]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[null,"Probability distribution of node City, p(City|E):"]
[]
[null,"City","E","Probability"]
[null,"B","l1",0.58823529411764708]
[null,"S","l1",0.41176470588235292]
[null,"B","l2",0.6875]
[null,"S","l2",0.3125]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[null,"Probability distribution of node T, p(T|Job|City):"]
[]
[null,"T","Job","City","Probability"]
[null,"Car","lib","B",0.6470588235294118]
[null,"Train","lib","B",0.17647058823529413]
[null,"Autre","lib","B",0.17647058823529413]
[null,"Car","nonlib","B",0.35714285714285715]
[null,"Train","nonlib","B",0.42857142857142855]
[null,"Autre","nonlib","B",0.21428571428571427]
[null,"Car","lib","S",0.5714285714285714]
[null,"Train","lib","S",0.2857142857142857]
[null,"Autre","lib","S",0.14285714285714285]
[null,"Car","nonlib","S",0.33333333333333331]
[null,"Train","nonlib","S",0.25]
[null,"Autre","nonlib","S",0.41666666666666669]
[null,"An empty bloc of probabilities means that none of the modality combinations for that bloc have been found in the data"]
[]
[]
[]
[]
[null,"Once all probability tables are defined, you can run the analysis"]

{"sheet":"Bayesian network analysis","index":3,"n_rows":421,"n_cols":7,"rows_kept":421,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Bayesian network analysis - Start time: 26/04/2021 at 15:47:41 / End time: 26/04/2021 at 15:47:42 / Microsoft Excel 16.013901"]
[null,"Method choice: Bayesian network analysis"]
[]
[]
[]
[]
[null,"Marginal probability distribution of each node:"]
[]
[null,"Marginal probability distribution of the node Age:"]
[]
[null,"Modality","Probability"]
[null,"[25,000; 45,000[",0.28000000000000003]
[null,"[45,000; 60,000[",0.32]
[null,"[60,000; 60,000]",0.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Marginal probability distribution of the node S:"]
[]
[null,"Modality","Probability"]
[null,"M",0.5]
[null,"W",0.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Marginal probability distribution of the node E:"]
[]
[null,"Modality","Probability"]
[null,"l1",0.69021645021645028]
[null,"l2",0.30978354978354983]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Marginal probability distribution of the node Job:"]
[]
[null,"Modality","Probability"]
[null,"lib",0.47876050420168076]
[null,"nonlib",0.52123949579831952]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Marginal probability distribution of the node City:"]
[]
[null,"Modality","Probability"]
[null,"B",0.61898586707410252]
[null,"S",0.38101413292589775]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Marginal probability distribution of the node T:"]
[]
[null,"Modality","Probability"]
[null,"Car",0.47755199344010962]
[null,"Train",0.29159778798767855]
[null,"Autre",0.23085021857221186]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Joint probability distribution of each clique:"]
[]
[null,"Number of cliques:",null,3]
[]
[null,"Nodes of the clique 1: E / Age / S"]
[]
[null,"Nodes of the clique 2: Job / City / E"]
[]
[null,"Nodes of the clique 3: T / Job / City"]
[]
[null,"Join probability distribution of the clique 1:"]
[]
[null,"Age","S","E","Probability"]
[null,"[25,000; 45,000[","M","l1",7.7777777777777793E-2]
[null,"[45,000; 60,000[","M","l1",9.1428571428571428E-2]
[null,"[60,000; 60,000]","M","l1",0.11111111111111112]
[null,"[25,000; 45,000[","W","l1",0.14000000000000001]
[null,"[45,000; 60,000[","W","l1",0.12444444444444445]
[null,"[60,000; 60,000]","W","l1",0.14545454545454548]
[null,"[25,000; 45,000[","M","l2",6.2222222222222227E-2]
[null,"[45,000; 60,000[","M","l2",6.8571428571428575E-2]
[null,"[60,000; 60,000]","M","l2",8.8888888888888906E-2]
[null,"[25,000; 45,000[","W","l2",0]
[null,"[45,000; 60,000[","W","l2",3.5555555555555556E-2]
[null,"[60,000; 60,000]","W","l2",5.4545454545454543E-2]
[]
[]
[null,"Join probability distribution of the clique 2:"]
[]
[null,"E","Job","City","Probability"]
[null,"l1","lib","B",0.17912191614613762]
[null,"l2","lib","B",0.11979910714285716]
[null,"l1","nonlib","B",0.22688776045177436]
[null,"l2","nonlib","B",9.3177083333333355E-2]
[null,"l1","lib","S",0.12538534130229634]
[null,"l2","lib","S",5.4454139610389619E-2]
[null,"l1","nonlib","S",0.15882143231624204]
[null,"l2","nonlib","S",4.2353219696969709E-2]
[]
[]
[null,"Join probability distribution of the clique 3:"]
[]
[null,"Job","City","T","Probability"]
[null,"lib","B","Car",0.19341948565758482]
[null,"nonlib","B","Car",0.1143088727803956]
[null,"lib","S","Car",0.10276541766439196]
[null,"nonlib","S","Car",6.705821733773723E-2]
[null,"lib","B","Train",5.2750768815704951E-2]
[null,"nonlib","B","Train",0.13717064733647472]
[null,"lib","S","Train",5.1382708832195978E-2]
[null,"nonlib","S","Train",5.029366300330293E-2]
[null,"lib","B","Autre",5.2750768815704951E-2]
[null,"nonlib","B","Autre",6.8585323668237358E-2]
[null,"lib","S","Autre",2.5691354416097989E-2]
[null,"nonlib","S","Autre",8.3822771672171559E-2]
[]
[]
[null,"Conditional probability distribution for each arc:"]
[]
[null,"Conditional probability p(E|Age):"]
[]
[null,"E","Age","Probability"]
[null,"l1","[25,000; 45,000[",0.77777777777777779]
[null,"l2","[25,000; 45,000[",0.22222222222222221]
[null,"l1","[45,000; 60,000[",0.67460317460317465]
[null,"l2","[45,000; 60,000[",0.32539682539682541]
[null,"l1","[60,000; 60,000]",0.64141414141414144]
[null,"l2","[60,000; 60,000]",0.35858585858585856]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Conditional probability p(E|S):"]
[]
[null,"E","S","Probability"]
[null,"l1","M",0.56063492063492071]
[null,"l2","M",0.4393650793650794]
[null,"l1","W",0.81979797979797997]
[null,"l2","W",0.1802020202020202]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Conditional probability p(Job|E):"]
[]
[null,"Job","E","Probability"]
[null,"lib","l1",0.44117647058823517]
[null,"nonlib","l1",0.55882352941176472]
[null,"lib","l2",0.5625]
[null,"nonlib","l2",0.4375]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Conditional probability p(City|E):"]
[]
[null,"City","E","Probability"]
[null,"B","l1",0.58823529411764708]
[null,"S","l1",0.41176470588235287]
[null,"B","l2",0.68749999999999989]
[null,"S","l2",0.3125]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Conditional probability p(T|Job):"]
[]
[null,"T","Job","Probability"]
[null,"Car","lib",0.61864940972074667]
[null,"Train","lib",0.21750640818114372]
[null,"Autre","lib",0.16384418209810961]
[null,"Car","nonlib",0.34795346780150427]
[null,"Train","nonlib",0.3596510085112819]
[null,"Autre","nonlib",0.29239552368721389]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Conditional probability p(T|City):"]
[]
[null,"T","City","Probability"]
[null,"Car","B",0.49714924816068612]
[null,"Train","B",0.30682674072983812]
[null,"Autre","B",0.1960240111094757]
[null,"Car","S",0.44571479198950792]
[null,"Train","S",0.26685721879842617]
[null,"Autre","S",0.28742798921206592]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Xlstatinfo","index":4,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["ID","Name","Modality combinaison Nomber","Modality values","Proba Table address","Modality Labels","Parent  number","Parent ID","Children number","Children ID","Modality Number","QualiInfo"]
["NODE1","Age",3,"[25,000; 45,000[,[45,000; 60,000[,[60,000; 60,000]","XLSTAT_20210426_154334_1'!$C$34:$C$37","XLSTAT_20210426_154334_1'!$B$34:$B$37",0,"None",1,3,3,true]
["NODE2","S",2,"M,W","XLSTAT_20210426_154334_1'!$C$43:$C$45","XLSTAT_20210426_154334_1'!$B$43:$B$45",0,"None",1,3,2,false]
["NODE3","E",12,"l1,l2","XLSTAT_20210426_154334_1'!$E$51:$E$63","XLSTAT_20210426_154334_1'!$B$51:$D$63",2,"1,2",2,"4,5",2,false]
["NODE4","Job",4,"lib,nonlib","XLSTAT_20210426_154334_1'!$D$69:$D$73","XLSTAT_20210426_154334_1'!$B$69:$C$73",1,3,1,6,2,false]
["NODE5","City",4,"B,S","XLSTAT_20210426_154334_1'!$D$79:$D$83","XLSTAT_20210426_154334_1'!$B$79:$C$83",1,3,1,6,2,false]
["NODE6","T",12,"Car,Train,Autre","XLSTAT_20210426_154334_1'!$E$89:$E$101","XLSTAT_20210426_154334_1'!$B$89:$D$101",2,"4,5",0,"None",3,false]