{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","Variables characterization4","Variables characterization3","Variables characterization2","Variables characterization1","Variables characterization"],"not_rendered":{"charts":9,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":101,"n_cols":11,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"AGE","WEIGHT","SIZE","ALCOHOL","GENDER","TOBACCO","SNORING"]
[null,47,71,158,0,0,1,0]
[null,56,58,164,7,0,0,1,null,null,"     GENDER  :  0=male / 1=female"]
[null,46,116,208,3,0,1,0,null,null,"     AGE :   in years"]
[null,70,96,186,3,0,1,0,null,null,"     SIZE : in cm"]
[null,51,91,195,2,0,1,1,null,null,"     WEIGHT : in kg"]
[null,46,98,188,0,1,0,0,null,null,"     TOBACCO :  1=smoker / 0=non-smoker"]
[null,40,112,193,5,0,1,0,null,null,"     ALCOHOL :  Number of drinks a day (equivalence in glasses of red wine)"]
[null,46,77,165,0,1,0,0,null,null,"     SNORING :  1=snores / 0= does not snore"]
[null,49,76,164,0,0,0,0]
[null,39,119,196,3,0,0,0]
[null,37,99,189,4,0,1,0]
[null,41,117,194,8,0,1,0]
[null,56,83,171,2,0,1,0]
[null,62,68,165,4,0,1,0]
[null,50,108,194,10,0,1,0]
[null,33,98,188,0,1,1,0]
[null,61,85,174,1,0,0,0]
[null,55,83,171,10,0,1,0]
[null,34,92,181,0,1,1,0]
[null,59,97,187,0,1,0,0]
[null,37,102,192,8,0,1,0]
[null,49,107,198,8,0,1,0]
[null,38,69,166,0,1,0,0]
[null,63,112,193,0,1,1,0]
[null,35,108,194,0,0,1,0]
[null,55,85,174,0,0,1,0]
[null,57,60,166,4,1,1,0]
[null,61,98,188,0,0,0,1]
[null,43,62,158,3,0,1,0]
[null,43,108,194,3,0,1,0]
[null,48,104,194,0,1,0,0]
[null,64,77,165,0,1,0,0]
[null,69,107,198,3,0,1,0]
[null,54,80,168,0,1,1,0]
[null,39,107,198,8,0,1,0]
[null,55,113,194,1,0,1,0]
[null,44,97,187,3,0,0,0]
[null,58,93,182,2,0,0,0]
[null,45,110,196,12,0,1,0]
[null,69,120,192,0,0,1,0]
[null,58,81,169,4,0,0,0]
[null,63,108,194,1,0,1,0]
[null,23,102,192,0,0,0,0]
[null,61,63,159,7,0,1,0]
[null,48,94,183,0,0,0,0]
[null,65,94,183,4,0,1,0]
[null,43,100,190,4,1,0,0]
[null,69,90,179,0,0,1,0]
[null,54,100,190,0,1,1,0]
[null,46,117,194,5,0,1,0]
[null,61,61,167,0,1,0,0]
[null,33,64,160,0,1,1,0]
[null,66,67,179,0,0,0,0]
[null,41,69,166,0,0,1,0]
[null,65,57,163,0,0,1,0]
[null,64,100,190,0,1,0,0]
[null,38,99,189,2,0,1,0]
[null,40,73,160,0,0,0,0]
[null,43,109,195,0,1,0,0]
[null,38,42,161,4,0,1,0]
[null,46,110,196,0,0,1,0]
[null,57,49,164,0,1,1,0]
[null,38,74,161,8,0,1,1]
[null,41,57,163,6,0,0,1]
[null,57,99,189,4,0,1,1]
[null,41,61,167,6,0,1,1]
[null,74,108,194,5,0,1,1]
[null,53,104,194,5,0,1,1]
[null,44,91,180,10,0,1,1]
[null,54,83,171,4,0,1,1]
[null,42,76,164,3,0,1,1]
[null,65,105,196,8,0,1,1]
[null,57,97,187,2,0,0,1]
[null,64,87,176,4,0,1,1]
[null,48,91,180,0,1,1,1]
[null,50,78,166,3,0,1,1]
[null,72,117,194,0,0,0,1]
[null,69,107,198,2,0,1,1]
[null,67,96,186,0,0,0,1]
[null,32,110,196,15,0,1,1]
[null,64,49,164,4,0,1,1]
[null,71,76,164,4,0,0,1]
[null,65,112,193,0,0,0,1]
[null,46,113,194,8,0,0,1]
[null,64,54,159,4,0,1,1]
[null,66,93,182,5,0,1,1]
[null,51,100,190,3,0,0,1]
[null,62,68,165,0,0,1,0]
[null,47,77,165,0,1,0,1]
[null,38,78,166,0,0,1,0]
[null,40,81,169,7,0,1,1]
[null,58,85,174,10,0,1,0]
[null,49,90,179,0,1,0,0]
[null,57,91,180,5,0,1,0]
[null,68,98,188,4,0,0,1]
[null,58,98,188,0,0,0,1]
[null,66,104,194,0,1,0,1]
[null,45,104,194,0,1,1,0]
[null,68,108,194,0,1,0,1]
[null,50,109,195,8,0,1,1]

{"sheet":"Variables characterization4","index":1,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Variables characterization - Start time: 25/05/2023 at 16:44:37 / End time: 25/05/2023 at 16:44:38 / Microsoft Excel 16.016227"]
[null,"Y / Element(s) to characterize / Qualitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$H:$H / 100 rows and 1 column"]
[null,"X / Characterizing elements / Qualitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$F:$G / 100 rows and 2 columns"]
[null,"Significance level (%): 5"]
[null,"Sort characterizing elements: Increasing p-values"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Y / Element(s) to characterize:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"SNORING","0",65,65,65]
[null,"","1",35,35,35]
[]
[]
[null,"X / Characterizing elements:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"GENDER","0",76,76,76]
[null,"","1",24,24,24]
[null,"TOBACCO","0",36,36,36]
[null,"","1",64,64,64]
[]
[]
[null,"Characterization of the category 0 of the variable SNORING with the selected categories:"]
[]
[null,"Categories Labels","% of the characterizing category in the category to characterize","% of the characterizing category in the population","% of the category to characterize in the characterizing category","Test value","p-values"]
[null,"GENDER(1)",30.76923076923077,24,83.333333333333329,2.1624212018328661,3.0585724796239555E-2]
[null,"GENDER(0)",69.230769230769226,76,59.210526315789473,-2.1624212018324611,3.058572479627069E-2]
[null,"TOBACCO(1)",67.692307692307693,64,68.75,1.0237552284163878,0.3059509021319089]
[null,"TOBACCO(0)",32.307692307692307,36,58.333333333333336,-1.0237552284163334,0.30595090213193471]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[null,"Characterization of the category 1 of the variable SNORING with the selected categories:"]
[]
[null,"Categories Labels","% of the characterizing category in the category to characterize","% of the characterizing category in the population","% of the category to characterize in the characterizing category","Test value","p-values"]
[null,"GENDER(0)",88.571428571428569,76,40.789473684210527,2.1624212018328777,3.0585724796238667E-2]
[null,"GENDER(1)",11.428571428571429,24,16.666666666666668,-2.1624212018324611,3.058572479627069E-2]
[null,"TOBACCO(0)",42.857142857142854,36,41.666666666666664,1.0237552284163867,0.30595090213190934]
[null,"TOBACCO(1)",57.142857142857146,64,31.25,-1.0237552284163329,0.30595090213193488]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Variables characterization3","index":2,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Variables characterization - Start time: 25/05/2023 at 16:45:27 / End time: 25/05/2023 at 16:45:28 / Microsoft Excel 16.016227"]
[null,"Y / Element(s) to characterize / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$E:$E / 100 rows and 1 column"]
[null,"X / Characterizing elements / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$F:$F / 100 rows and 1 column"]
[null,"Significance level (%): 5"]
[null,"Sort characterizing elements: Increasing p-values"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Y / Element(s) to characterize:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"ALCOHOL",100,0,100,0,15,2.95,3.3646258440883257]
[]
[]
[null,"X / Characterizing elements:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"GENDER","0",76,76,76]
[null,"","1",24,24,24]
[]
[]
[null,"Characterization of the continuous variable ALCOHOL with the selected categories:"]
[]
[null,"Categories Labels","% of the characterizing category in the population","Category mean","Total mean","Standard deviation of the category","Total standard deviation","Test value","p-value"]
[null,"GENDER(0)",0.76,3.7763157894736841,2.95,3.3934871220685996,3.347760445432141,4.3702919501936099,1.2408052714407702E-5]
[null,"GENDER(1)",0.24,0.33333333333333326,2.95,1.105541596785133,3.347760445432141,-4.3702919501936126,1.2408052714407702E-5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Variables characterization2","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Variables characterization - Start time: 25/05/2023 at 16:46:09 / End time: 25/05/2023 at 16:46:09 / Microsoft Excel 16.016227"]
[null,"Y / Element(s) to characterize / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$E:$E / 100 rows and 1 column"]
[null,"X / Characterizing elements / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$F:$H / 100 rows and 3 columns"]
[null,"Significance level (%): 5"]
[null,"Sort characterizing elements: Increasing p-values"]
[null,"Tests: Parametric tests"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Y / Element(s) to characterize:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"ALCOHOL",100,0,100,0,15,2.95,3.3646258440883257]
[]
[]
[null,"X / Characterizing elements:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"GENDER","0",76,76,76]
[null,"","1",24,24,24]
[null,"TOBACCO","0",36,36,36]
[null,"","1",64,64,64]
[null,"SNORING","0",65,65,65]
[null,"","1",35,35,35]
[]
[]
[null,"Characterization of the continuous variable ALCOHOL with the selected categorical variables (Fisher's F-test):"]
[]
[null,"Variable labels","p-values"]
[null,"GENDER",4.838797930541775E-6]
[null,"TOBACCO",4.6691174986416873E-4]
[null,"SNORING",1.7880517107839049E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Variables characterization1","index":4,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Variables characterization - Start time: 25/05/2023 at 16:46:52 / End time: 25/05/2023 at 16:46:53 / Microsoft Excel 16.016227"]
[null,"Y / Element(s) to characterize / Qualitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$H:$H / 100 rows and 1 column"]
[null,"X / Characterizing elements / Qualitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$F:$G / 100 rows and 2 columns"]
[null,"Significance level (%): 5"]
[null,"Sort characterizing elements: Increasing p-values"]
[null,"Tests: Parametric tests"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Y / Element(s) to characterize:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"SNORING","0",65,65,65]
[null,"","1",35,35,35]
[]
[]
[null,"X / Characterizing elements:"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"GENDER","0",76,76,76]
[null,"","1",24,24,24]
[null,"TOBACCO","0",36,36,36]
[null,"","1",64,64,64]
[]
[]
[null,"Independence between the nominal variable SNORING and the selected nominal variables (Chi-square independence test):"]
[]
[null,"Variable labels","p-values"]
[null,"GENDER",3.0774283675921721E-2]
[null,"TOBACCO",0.29450739368011014]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Variables characterization","index":5,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Variables characterization - Start time: 25/05/2023 at 16:47:17 / End time: 25/05/2023 at 16:47:18 / Microsoft Excel 16.016227"]
[null,"Y / Element(s) to characterize / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$E:$E / 100 rows and 1 column"]
[null,"X / Characterizing elements / Quantitative variables: Workbook = DemoDMO.xlsm / Sheet = Data / Range = 'Data'!$B:$D / 100 rows and 3 columns"]
[null,"Significance level (%): 5"]
[null,"Sort characterizing elements: Increasing p-values"]
[null,"Tests: Parametric tests"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Y / Element(s) to characterize:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"ALCOHOL",100,0,100,0,15,2.95,3.3646258440883257]
[]
[]
[null,"X / Characterizing elements:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"AGE",100,0,100,23,74,52.27000000000001,11.397195295600611]
[null,"WEIGHT",100,0,100,42,120,90.41,18.735853922952703]
[null,"SIZE",100,0,100,158,208,181.09999999999997,13.366247254056232]
[]
[]
[null,"Correlations of the continuous variable ALCOHOL with the selected quantitative variables (Pearson's Phi):"]
[]
[null,"Variable labels","Correlation coefficient","p-values"]
[null,"AGE",-0.15874322520723194,0.11468175502629419]
[null,"SIZE",0.10635025159534849,0.29228520334417962]
[null,"WEIGHT",9.1501596815620215E-2,0.36524650436480277]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]