{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Variances (k samples)-v1","Variances (k samples)-v2"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":8,"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":151,"n_cols":7,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["Petal width","Specie",null,null,"Setosa","Versicolor","Virginica"]
[2,"Setosa",null,null,2,15,22]
[22,"Virginica",null,null,3,15,24]
[15,"Versicolor",null,null,2,18,15]
[24,"Virginica",null,null,5,14,23]
[15,"Virginica",null,null,2,16,20]
[3,"Setosa",null,null,2,11,18]
[23,"Virginica",null,null,2,13,19]
[15,"Versicolor",null,null,1,16,23]
[18,"Versicolor",null,null,2,14,23]
[2,"Setosa",null,null,6,15,22]
[14,"Versicolor",null,null,2,13,25]
[16,"Versicolor",null,null,2,11,21]
[20,"Virginica",null,null,3,15,17]
[11,"Versicolor",null,null,2,12,23]
[18,"Virginica",null,null,2,12,18]
[19,"Virginica",null,null,2,10,19]
[23,"Virginica",null,null,2,14,23]
[5,"Setosa",null,null,1,15,20]
[13,"Versicolor",null,null,2,10,21]
[23,"Virginica",null,null,4,15,20]
[22,"Virginica",null,null,2,10,18]
[16,"Versicolor",null,null,2,13,18]
[25,"Virginica",null,null,4,10,18]
[21,"Virginica",null,null,2,13,14]
[17,"Virginica",null,null,4,12,21]
[2,"Setosa",null,null,2,13,18]
[23,"Virginica",null,null,4,14,23]
[14,"Versicolor",null,null,1,16,24]
[15,"Versicolor",null,null,2,10,19]
[13,"Versicolor",null,null,2,10,16]
[2,"Setosa",null,null,4,12,21]
[18,"Virginica",null,null,2,13,18]
[11,"Versicolor",null,null,2,15,18]
[19,"Virginica",null,null,2,10,18]
[23,"Virginica",null,null,2,15,23]
[2,"Setosa",null,null,2,13,15]
[1,"Setosa",null,null,3,13,23]
[15,"Versicolor",null,null,1,15,19]
[20,"Virginica",null,null,2,12,20]
[2,"Setosa",null,null,4,13,18]
[21,"Virginica",null,null,3,11,18]
[6,"Setosa",null,null,2,13,22]
[12,"Versicolor",null,null,1,14,21]
[2,"Setosa",null,null,3,13,25]
[20,"Virginica",null,null,3,15,20]
[18,"Virginica",null,null,3,13,19]
[2,"Setosa",null,null,2,13,21]
[12,"Versicolor",null,null,4,14,20]
[10,"Versicolor",null,null,2,14,24]
[18,"Virginica",null,null,2,17,25]
[3,"Setosa"]
[2,"Setosa"]
[18,"Virginica"]
[2,"Setosa"]
[2,"Setosa"]
[2,"Setosa"]
[14,"Virginica"]
[21,"Virginica"]
[1,"Setosa"]
[2,"Setosa"]
[4,"Setosa"]
[14,"Versicolor"]
[18,"Virginica"]
[2,"Setosa"]
[2,"Setosa"]
[15,"Versicolor"]
[10,"Versicolor"]
[4,"Setosa"]
[2,"Setosa"]
[15,"Versicolor"]
[10,"Versicolor"]
[4,"Setosa"]
[2,"Setosa"]
[23,"Virginica"]
[24,"Virginica"]
[19,"Virginica"]
[13,"Versicolor"]
[16,"Virginica"]
[4,"Setosa"]
[1,"Setosa"]
[21,"Virginica"]
[18,"Virginica"]
[18,"Virginica"]
[18,"Virginica"]
[10,"Versicolor"]
[13,"Versicolor"]
[12,"Versicolor"]
[2,"Setosa"]
[2,"Setosa"]
[23,"Virginica"]
[15,"Virginica"]
[4,"Setosa"]
[13,"Versicolor"]
[14,"Versicolor"]
[16,"Versicolor"]
[2,"Setosa"]
[2,"Setosa"]
[10,"Versicolor"]
[10,"Versicolor"]
[12,"Versicolor"]
[2,"Setosa"]
[2,"Setosa"]
[23,"Virginica"]
[13,"Versicolor"]
[19,"Virginica"]
[15,"Versicolor"]
[2,"Setosa"]
[3,"Setosa"]
[20,"Virginica"]
[10,"Versicolor"]
[18,"Virginica"]
[18,"Virginica"]
[1,"Setosa"]
[15,"Versicolor"]
[13,"Versicolor"]
[2,"Setosa"]
[13,"Versicolor"]
[15,"Versicolor"]
[12,"Versicolor"]
[13,"Versicolor"]
[11,"Versicolor"]
[13,"Versicolor"]
[22,"Virginica"]
[21,"Virginica"]
[4,"Setosa"]
[3,"Setosa"]
[25,"Virginica"]
[20,"Virginica"]
[14,"Versicolor"]
[13,"Versicolor"]
[15,"Versicolor"]
[19,"Virginica"]
[21,"Virginica"]
[13,"Versicolor"]
[2,"Setosa"]
[1,"Setosa"]
[3,"Setosa"]
[20,"Virginica"]
[3,"Setosa"]
[3,"Setosa"]
[13,"Versicolor"]
[14,"Versicolor"]
[14,"Versicolor"]
[2,"Setosa"]
[4,"Setosa"]
[2,"Setosa"]
[24,"Virginica"]
[17,"Versicolor"]
[25,"Virginica"]
[2,"Setosa"]

{"sheet":"Variances (k samples)-v1","index":1,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[42,1,43,9],[57,1,58,9]]}
[null,"XLSTAT 2023.2.0.1411 - k-sample comparison of variances - Start time: 12/09/2023 at 18:03:06 / End time: 12/09/2023 at 18:03:07 / Microsoft Excel 16.016731"]
[null,"Data: Workbook = 6 - Homoscédasticité-LeveneBartlett.xlsm / Sheet = Données / Range = 'Données'!$A:$A / 150 rows and 1 column"]
[null,"Sample identifiers: Workbook = 6 - Homoscédasticité-LeveneBartlett.xlsm / Sheet = Données / Range = 'Données'!$B:$B / 150 rows and 1 column"]
[null,"Significance level (%): 5"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Petal width",150,0,150,1,25,11.993333333333332,7.6223766896034659]
[]
[]
[null,"Summary statistics (Specie):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Specie","Setosa",50,50,33.333333333333336]
[null,"","Versicolor",50,50,33.333333333333336]
[null,"","Virginica",50,50,33.333333333333336]
[]
[]
[null,"Summary statistics (Data / Specie):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Petal width | Specie-Setosa",50,0,50,1,6,2.46,1.0538558938004563]
[null,"Petal width | Specie-Versicolor",50,0,50,10,18,13.259999999999998,1.9775268000454409]
[null,"Petal width | Specie-Virginica",50,0,50,14,25,20.259999999999998,2.7465005563666747]
[]
[]
[null,"Levene's test (Mean) / Two-tailed test (Petal width):"]
[]
[null,"F (Observed value)",19.65174376386971]
[null,"F (Critical value)",3.0576206516493958]
[null,"DF1",2]
[null,"DF2",147]
[null,"p-value (Two-tailed)",2.7326355984958399E-8]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The variances are identical."]
[null,"Ha: At least one of the variances is different from another."]
[null,"As the computed p-value is lower than the significance level alpha=0,05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Bartlett's test / Two-tailed test (Petal width):"]
[]
[null,"Chi-square (Observed value)",39.213113945563279]
[null,"Chi-square (Critical value)",5.9914645471101275]
[null,"DF",2]
[null,"p-value (Two-tailed)",3.0547839813266364E-9]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The variances are identical."]
[null,"Ha: At least one of the variances is different from another."]
[null,"As the computed p-value is lower than the significance level alpha=0,05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Summary (p-values):"]
[]
[null,"Variable\\Test","Levene","Bartlett"]
[null,"Petal width",2.7326355984958399E-8,3.0547839813266364E-9]

{"sheet":"Variances (k samples)-v2","index":2,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[27,1,28,9],[42,1,43,9]]}
[null,"XLSTAT 2023.2.0.1411 - k-sample comparison of variances - Start time: 12/09/2023 at 18:03:25 / End time: 12/09/2023 at 18:03:25 / Microsoft Excel 16.016731"]
[null,"Samples: Workbook = 6 - Homoscédasticité-LeveneBartlett.xlsm / Sheet = Données / Range = 'Données'!$E:$G / 50 rows and 3 columns"]
[null,"Significance level (%): 5"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Setosa",50,0,50,1,6,2.46,1.0538558938004563]
[null,"Versicolor",50,0,50,10,18,13.259999999999998,1.9775268000454409]
[null,"Virginica",50,0,50,14,25,20.259999999999998,2.7465005563666747]
[]
[]
[null,"Levene's test (Mean) / Two-tailed test:"]
[]
[null,"F (Observed value)",19.65174376386971]
[null,"F (Critical value)",3.0576206516493958]
[null,"DF1",2]
[null,"DF2",147]
[null,"p-value (Two-tailed)",2.7326355984958399E-8]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The variances are identical."]
[null,"Ha: At least one of the variances is different from another."]
[null,"As the computed p-value is lower than the significance level alpha=0,05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Bartlett's test / Two-tailed test:"]
[]
[null,"Chi-square (Observed value)",39.213113945563279]
[null,"Chi-square (Critical value)",5.9914645471101275]
[null,"DF",2]
[null,"p-value (Two-tailed)",3.0547839813266364E-9]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The variances are identical."]
[null,"Ha: At least one of the variances is different from another."]
[null,"As the computed p-value is lower than the significance level alpha=0,05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Summary (p-values):"]
[]
[null,"Levene","Bartlett"]
[null,2.7326355984958399E-8,3.0547839813266364E-9]