{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Missing data"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":101,"n_cols":12,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Long. Sépales","Larg. Sépales","Long. Pétales","Larg. Pétales","Espèce",null,null,"Long. Sépales","Larg. Sépales","Long. Pétales","Larg. Pétales","Espèce"]
[50,33,14,2,"Setosa",null,null,50,"",14,2,"Setosa"]
[67,31,56,24,"Virginica",null,null,67,31,"",24,"Virginica"]
[46,34,14,3,"Setosa",null,null,46,34,"",3,"Setosa"]
[69,31,51,23,"Virginica",null,null,69,"","",23,"Virginica"]
[59,32,48,18,"Versicolor",null,null,"","","","","Versicolor"]
[46,36,10,2,"Setosa",null,null,"",36,"",2,"Setosa"]
[61,30,46,14,"Versicolor",null,null,61,"",46,"","Versicolor"]
[65,30,52,20,"Virginica",null,null,"",30,52,20,"Virginica"]
[65,30,55,18,"Virginica",null,null,65,30,"","","Virginica"]
[68,32,59,23,"Virginica",null,null,"",32,59,23,"Virginica"]
[51,33,17,5,"Setosa",null,null,"",33,"",5,"Setosa"]
[62,34,54,23,"Virginica",null,null,62,34,54,23,"Virginica"]
[77,38,67,22,"Virginica",null,null,77,38,67,22,"Virginica"]
[63,33,47,16,"Versicolor",null,null,63,33,"",16,"Versicolor"]
[67,33,57,25,"Virginica",null,null,"",33,"","","Virginica"]
[76,30,66,21,"Virginica",null,null,76,30,66,21,"Virginica"]
[55,35,13,2,"Setosa",null,null,55,35,13,2,"Setosa"]
[67,30,52,23,"Virginica",null,null,67,"",52,23,"Virginica"]
[70,32,47,14,"Versicolor",null,null,70,32,"",14,"Versicolor"]
[64,32,45,15,"Versicolor",null,null,"",32,45,15,"Versicolor"]
[48,31,16,2,"Setosa",null,null,48,"","",2,"Setosa"]
[59,30,51,18,"Virginica",null,null,59,30,51,18,"Virginica"]
[64,32,53,23,"Virginica",null,null,64,32,53,23,"Virginica"]
[52,34,14,2,"Setosa",null,null,52,34,14,2,"Setosa"]
[49,36,14,1,"Setosa",null,null,49,36,14,1,"Setosa"]
[54,30,45,15,"Versicolor",null,null,54,30,"",15,"Versicolor"]
[79,38,64,20,"Virginica",null,null,79,38,"",20,"Virginica"]
[44,32,13,2,"Setosa",null,null,44,32,"","","Setosa"]
[67,33,57,21,"Virginica",null,null,67,"","","","Virginica"]
[50,35,16,6,"Setosa",null,null,"","",16,"","Setosa"]
[44,30,13,2,"Setosa",null,null,44,30,13,2,"Setosa"]
[47,32,16,2,"Setosa",null,null,47,32,16,2,"Setosa"]
[72,32,60,18,"Virginica",null,null,72,32,60,18,"Virginica"]
[48,30,14,3,"Setosa",null,null,48,30,14,3,"Setosa"]
[51,38,16,2,"Setosa",null,null,51,38,16,2,"Setosa"]
[61,30,49,18,"Virginica",null,null,61,30,49,18,"Virginica"]
[48,34,19,2,"Setosa",null,null,48,34,19,2,"Setosa"]
[50,30,16,2,"Setosa",null,null,50,30,16,2,"Setosa"]
[50,32,12,2,"Setosa",null,null,50,32,12,2,"Setosa"]
[43,30,11,1,"Setosa",null,null,43,30,11,1,"Setosa"]
[58,40,12,2,"Setosa",null,null,58,40,12,2,"Setosa"]
[51,38,19,4,"Setosa",null,null,"",38,19,4,"Setosa"]
[67,31,44,14,"Versicolor",null,null,"","",44,"","Versicolor"]
[49,30,14,2,"Setosa",null,null,49,30,"",2,"Setosa"]
[51,35,14,2,"Setosa",null,null,51,"",14,2,"Setosa"]
[56,30,45,15,"Versicolor",null,null,56,30,45,15,"Versicolor"]
[50,34,16,4,"Setosa",null,null,50,34,"",4,"Setosa"]
[46,32,14,2,"Setosa",null,null,"",32,14,2,"Setosa"]
[57,44,15,4,"Setosa",null,null,57,44,"",4,"Setosa"]
[50,36,14,2,"Setosa",null,null,50,36,"",2,"Setosa"]
[77,30,61,23,"Virginica",null,null,"",30,61,23,"Virginica"]
[63,34,56,24,"Virginica",null,null,"",34,56,24,"Virginica"]
[72,30,58,16,"Virginica",null,null,72,30,58,16,"Virginica"]
[54,34,15,4,"Setosa",null,null,54,34,15,4,"Setosa"]
[52,41,15,1,"Setosa",null,null,52,"",15,"","Setosa"]
[71,30,59,21,"Virginica",null,null,71,30,59,21,"Virginica"]
[64,31,55,18,"Virginica",null,null,64,31,55,18,"Virginica"]
[60,30,48,18,"Virginica",null,null,60,30,48,18,"Virginica"]
[57,30,42,12,"Versicolor",null,null,57,30,"",12,"Versicolor"]
[55,42,14,2,"Setosa",null,null,55,42,"",2,"Setosa"]
[49,31,15,2,"Setosa",null,null,49,31,15,2,"Setosa"]
[54,39,17,4,"Setosa",null,null,54,"",17,"","Setosa"]
[60,34,45,16,"Versicolor",null,null,60,34,45,16,"Versicolor"]
[50,34,15,2,"Setosa",null,null,"","","",2,"Setosa"]
[62,22,45,15,"Versicolor",null,null,62,22,45,15,"Versicolor"]
[55,24,38,11,"Versicolor",null,null,"","",38,11,"Versicolor"]
[50,23,33,10,"Versicolor",null,null,"",23,"",10,"Versicolor"]
[49,24,33,10,"Versicolor",null,null,49,24,"",10,"Versicolor"]
[60,22,50,15,"Virginica",null,null,60,22,50,15,"Virginica"]
[50,20,35,10,"Versicolor",null,null,50,20,35,10,"Versicolor"]
[55,24,37,10,"Versicolor",null,null,55,24,37,10,"Versicolor"]
[64,28,56,22,"Virginica",null,null,64,28,"",22,"Virginica"]
[65,28,46,15,"Versicolor",null,null,65,28,46,15,"Versicolor"]
[63,28,51,15,"Virginica",null,null,63,28,51,15,"Virginica"]
[60,27,51,16,"Versicolor",null,null,60,"","",16,"Versicolor"]
[56,25,39,11,"Versicolor",null,null,56,25,39,11,"Versicolor"]
[58,27,51,19,"Virginica",null,null,58,27,51,19,"Virginica"]
[57,28,45,13,"Versicolor",null,null,57,28,45,13,"Versicolor"]
[49,25,45,17,"Virginica",null,null,49,25,45,17,"Virginica"]
[61,28,40,13,"Versicolor",null,null,61,28,40,13,"Versicolor"]
[63,25,50,19,"Virginica",null,null,63,"",50,19,"Virginica"]
[58,26,40,12,"Versicolor",null,null,58,"","",12,"Versicolor"]
[77,28,67,20,"Virginica",null,null,"","",67,20,"Virginica"]
[63,27,49,18,"Virginica",null,null,63,"",49,18,"Virginica"]
[55,26,44,12,"Versicolor",null,null,55,"",44,"","Versicolor"]
[61,26,56,14,"Virginica",null,null,61,26,56,14,"Virginica"]
[64,28,56,21,"Virginica",null,null,64,"",56,"","Virginica"]
[62,28,48,18,"Virginica",null,null,62,"",48,18,"Virginica"]
[58,27,41,10,"Versicolor",null,null,"","",41,10,"Versicolor"]
[60,29,45,15,"Versicolor",null,null,"",29,45,"","Versicolor"]
[57,26,35,10,"Versicolor",null,null,57,26,35,10,"Versicolor"]
[58,27,51,19,"Virginica",null,null,58,27,51,"","Virginica"]
[57,29,42,13,"Versicolor",null,null,57,29,42,13,"Versicolor"]
[63,29,56,18,"Virginica",null,null,63,29,56,"","Virginica"]
[56,27,42,13,"Versicolor",null,null,"","","",13,"Versicolor"]
[77,26,69,23,"Virginica",null,null,77,"",69,"","Virginica"]
[66,29,46,13,"Versicolor",null,null,66,29,46,13,"Versicolor"]
[52,27,39,14,"Versicolor",null,null,52,"",39,14,"Versicolor"]
[44,29,14,2,"Setosa",null,null,44,29,14,2,"Setosa"]
[58,27,39,12,"Versicolor",null,null,58,27,39,"","Versicolor"]

{"sheet":"Missing data","index":1,"n_rows":149,"n_cols":9,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2020.4.1.12345 - Missing data - Start time: 09/10/2020 at 17:25:21 / End time: 09/10/2020 at 17:25:22 / Microsoft Excel 16.012325"]
[null,"Quantitative data: Workbook = demo_Missing_EM_en.xlsm / Sheet = Feuil1 / Range = Feuil1!$H:$K / 100 rows and 4 columns"]
[null,"Estimation method / Quantitative data: EM algorithm"]
[]
[]
[]
[]
[null,"Quantitative data:"]
[]
[null,"Missing values chart:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Summary statistics (Before treatment):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Long. Sépales",100,20,80,43,79,58.049999999999976,8.3876038732272757]
[null,"Larg. Sépales",100,26,74,20,44,30.891891891891891,4.4523891310681618]
[null,"Long. Pétales",100,28,72,11,69,38.930555555555543,17.694851951980382]
[null,"Larg. Pétales",100,17,83,1,24,11.6144578313253,7.6586175363652984]
[]
[]
[null,"Summary statistics (Post treatment):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Long. Sépales",100,0,100,43,79,57.950239763414913,8.0934749969453197]
[null,"Larg. Sépales",100,0,100,20,44,31.026249871904433,4.5109721294891818]
[null,"Long. Pétales",100,0,100,5.8732444233011663,69,37.631928612792009,17.958867290797514]
[null,"Larg. Pétales",100,0,100,1.4132819533090313E-2,24,11.873179662140954,7.5599471886537071]
[]
[]
[null,"Completed data:"]
[]
[null,null,"Long. Sépales","Larg. Sépales","Long. Pétales","Larg. Pétales"]
[null,"Obs1",50,32.84797445277529,14,2]
[null,"Obs2",67,31,65.502933241757006,24]
[null,"Obs3",46,34,17.078689747978018,3]
[null,"Obs4",69,24.736813201456656,64.391601784814981,23]
[null,"Obs5",56.742836086349982,32.127609316816681,48.696210894863249,15.883317521320187]
[null,"Obs6",50.119862887844654,36,15.854289604608027,2]
[null,"Obs7",61,31.941719723985951,46,16.294907984839]
[null,"Obs8",59.766391462628711,30,52,20]
[null,"Obs9",65,30,55.631140276971919,16.855258155400804]
[null,"Obs10",68.257960586062012,32,59,23]
[null,"Obs11",59.1564591456711,33,25.470730835375313,5]
[null,"Obs12",62,34,54,23]
[null,"Obs13",77,38,67,22]
[null,"Obs14",63,33,49.979929075913994,16]
[null,"Obs15",56.813770350113245,33,20.351428036755959,6.2380232314154762]
[null,"Obs16",76,30,66,21]
[null,"Obs17",55,35,13,2]
[null,"Obs18",67,33.772479299112916,52,23]
[null,"Obs19",70,32,52.791035237459127,14]
[null,"Obs20",60.322466309549206,32,45,15]
[null,"Obs21",48,34.343025831100682,13.333780057268935,2]
[null,"Obs22",59,30,51,18]
[null,"Obs23",64,32,53,23]
[null,"Obs24",52,34,14,2]
[null,"Obs25",49,36,14,1]
[null,"Obs26",54,30,45.58423806103378,15]
[null,"Obs27",79,38,60.329182553256715,20]
[null,"Obs28",44,32,15.275758578639859,5.5033619094323445]
[null,"Obs29",67,43.556735150113312,39.372318208821049,12.301281728174775]
[null,"Obs30",52.928245083453817,39.071850108455266,16,4.5456280564993223]
[null,"Obs31",44,30,13,2]
[null,"Obs32",47,32,16,2]
[null,"Obs33",72,32,60,18]
[null,"Obs34",48,30,14,3]
[null,"Obs35",51,38,16,2]
[null,"Obs36",61,30,49,18]
[null,"Obs37",48,34,18.999999999999996,2]
[null,"Obs38",50,30,16,2]
[null,"Obs39",50,32,12,2]
[null,"Obs40",43,30,11,1]
[null,"Obs41",58,40,12,2]
[null,"Obs42",50.217660722638286,38,18.999999999999996,4]
[null,"Obs43",61.3446156849744,25.548922292611287,44,16.833740398109587]
[null,"Obs44",49,30,19.649275209632915,2]
[null,"Obs45",51,34.428559456763423,14,2]
[null,"Obs46",56,30,45,15]
[null,"Obs47",50,34,15.193432010438958,4]
[null,"Obs48",49.697055452551041,32,14,2]
[null,"Obs49",57,44,15.416976585703548,4]
[null,"Obs50",50,36,9.3877971501631698,2]
[null,"Obs51",68.555961070855176,30,61,23]
[null,"Obs52",67.247720549993772,34,56,24]
[null,"Obs53",72,30,58,16]
[null,"Obs54",54,34,15,4]
[null,"Obs55",52,37.109171869687771,15,1.4132819533090313E-2]
[null,"Obs56",71,30,59,21]
[null,"Obs57",64,31,55,18]
[null,"Obs58",60,30,48,18]
[null,"Obs59",57,30,34.112162255864384,12]
[null,"Obs60",55,42,14.9853117819342,2]
[null,"Obs61",49,31,15,2]
[null,"Obs62",54,34.032942320498151,17,1.3364407020223155]
[null,"Obs63",60,34,45,16]
[null,"Obs64",44.816246335055531,33.630439889673156,5.8732444233011663,2]
[null,"Obs65",62,22,45,15]
[null,"Obs66",58.335104121091248,23.514959204690513,38,11]
[null,"Obs67",47.879746404102264,23,38.535353769917727,10]
[null,"Obs68",49,24,33.591628314248773,10]
[null,"Obs69",60,22,50,15]
[null,"Obs70",50,20,35,10]
[null,"Obs71",55,24,37,10]
[null,"Obs72",64,28,57.793807348910399,22]
[null,"Obs73",65,28,46,15]
[null,"Obs74",63,28,51,15]
[null,"Obs75",60,31.316378330604461,49.302643176197975,16]
[null,"Obs76",56,25,39,11]
[null,"Obs77",58,27,51,19]
[null,"Obs78",57,28,45,13]
[null,"Obs79",49,25,45,17]
[null,"Obs80",61,28,40,13]
[null,"Obs81",63,27.449119389265142,50,19]
[null,"Obs82",58,27.862431713034024,42.112814439924051,12]
[null,"Obs83",66.443561011862329,25.553279769555061,67,20]
[null,"Obs84",63,30.840879008697357,49,18]
[null,"Obs85",55,29.679164728158121,44,15.700877403579835]
[null,"Obs86",61,26,56,14]
[null,"Obs87",64,29.412973773083539,56,23.512131752571037]
[null,"Obs88",62,28.021829996833965,48,18]
[null,"Obs89",61.051942246940087,32.794103883780011,41,10]
[null,"Obs90",58.47223839119463,29,45,15.005687507922582]
[null,"Obs91",57,26,35,10]
[null,"Obs92",58,27,51,19.747153659738274]
[null,"Obs93",57,29,42,13]
[null,"Obs94",63,29,56,18.72857187072329]
[null,"Obs95",52.854132438558409,31.308783459660447,34.59514861744514,13]
[null,"Obs96",77,36.359224079363543,69,22.397341320375766]
[null,"Obs97",66,29,46,13]
[null,"Obs98",52,25.363616940666468,39,14]
[null,"Obs99",44,29,14,2]
[null,"Obs100",58,27,39,12.420110192437393]