{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Données","Variances (k échant.)-v1","Variances (k échant.)-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":"Données","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 échant.)-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 - Comparaison des variances de k échantillons - Début : 12/09/2023 à 18:07:56 / Fin : 12/09/2023 à 18:07:56 / Microsoft Excel 16.016731"]
[null,"Données : Classeur = demoLeveneBartlett-FR.xlsm / Feuille = Données / Plage = 'Données'!$A:$A / 150 lignes et 1 colonne"]
[null,"Identifiants d'échantillon : Classeur = demoLeveneBartlett-FR.xlsm / Feuille = Données / Plage = 'Données'!$B:$B / 150 lignes et 1 colonne"]
[null,"Niveau de signification (%) : 5"]
[]
[]
[]
[]
[null,"Statistiques descriptives :"]
[]
[null,"Variable","Observations","Obs. avec données manquantes","Obs. sans données manquantes","Minimum","Maximum","Moyenne","Ecart-type"]
[null,"Petal width",150,0,150,1,25,11.993333333333332,7.6223766896034659]
[]
[]
[null,"Statistiques descriptives (Specie) :"]
[]
[null,"Variable","Modalités","Comptages","Effectifs","%"]
[null,"Specie","Setosa",50,50,33.333333333333336]
[null,"","Versicolor",50,50,33.333333333333336]
[null,"","Virginica",50,50,33.333333333333336]
[]
[]
[null,"Statistiques descriptives (Données / Specie) :"]
[]
[null,"Variable","Observations","Obs. avec données manquantes","Obs. sans données manquantes","Minimum","Maximum","Moyenne","Ecart-type"]
[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,"Test de Levene (Moyenne) / Test bilatéral (Petal width) :"]
[]
[null,"F (Valeur observée)",19.65174376386971]
[null,"F (Valeur critique)",3.0576206516493958]
[null,"DDL1",2]
[null,"DDL2",147]
[null,"p-value (bilatérale)",2.7326355984958399E-8]
[null,"alpha",0.05]
[]
[null,"Interprétation du test :"]
[null,"H0 : Les variances sont identiques."]
[null,"Ha : Au moins l'une des variances est différente d'une autre."]
[null,"Etant donné que la p-value calculée est inférieure au niveau de signification alpha=0,05, on doit rejeter l'hypothèse nulle H0, et retenir l'hypothèse alternative Ha."]
[]
[]
[]
[null,"Test de Bartlett / Test bilatéral (Petal width) :"]
[]
[null,"Khi² (Valeur observée)",39.213113945563279]
[null,"Khi² (Valeur critique)",5.9914645471101275]
[null,"DDL",2]
[null,"p-value (bilatérale)",3.0547839813266364E-9]
[null,"alpha",0.05]
[]
[null,"Interprétation du test :"]
[null,"H0 : Les variances sont identiques."]
[null,"Ha : Au moins l'une des variances est différente d'une autre."]
[null,"Etant donné que la p-value calculée est inférieure au niveau de signification alpha=0,05, on doit rejeter l'hypothèse nulle H0, et retenir l'hypothèse alternative Ha."]
[]
[]
[]
[null,"Synthèse (p-values) :"]
[]
[null,"Variable\\Test","Levene","Bartlett"]
[null,"Petal width",2.7326355984958399E-8,3.0547839813266364E-9]

{"sheet":"Variances (k échant.)-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 - Comparaison des variances de k échantillons - Début : 12/09/2023 à 18:08:13 / Fin : 12/09/2023 à 18:08:14 / Microsoft Excel 16.016731"]
[null,"Echantillons : Classeur = demoLeveneBartlett-FR.xlsm / Feuille = Données / Plage = 'Données'!$E:$G / 50 lignes et 3 colonnes"]
[null,"Niveau de signification (%) : 5"]
[]
[]
[]
[]
[null,"Statistiques descriptives :"]
[]
[null,"Variable","Observations","Obs. avec données manquantes","Obs. sans données manquantes","Minimum","Maximum","Moyenne","Ecart-type"]
[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,"Test de Levene (Moyenne) / Test bilatéral :"]
[]
[null,"F (Valeur observée)",19.65174376386971]
[null,"F (Valeur critique)",3.0576206516493958]
[null,"DDL1",2]
[null,"DDL2",147]
[null,"p-value (bilatérale)",2.7326355984958399E-8]
[null,"alpha",0.05]
[]
[null,"Interprétation du test :"]
[null,"H0 : Les variances sont identiques."]
[null,"Ha : Au moins l'une des variances est différente d'une autre."]
[null,"Etant donné que la p-value calculée est inférieure au niveau de signification alpha=0,05, on doit rejeter l'hypothèse nulle H0, et retenir l'hypothèse alternative Ha."]
[]
[]
[]
[null,"Test de Bartlett / Test bilatéral :"]
[]
[null,"Khi² (Valeur observée)",39.213113945563279]
[null,"Khi² (Valeur critique)",5.9914645471101275]
[null,"DDL",2]
[null,"p-value (bilatérale)",3.0547839813266364E-9]
[null,"alpha",0.05]
[]
[null,"Interprétation du test :"]
[null,"H0 : Les variances sont identiques."]
[null,"Ha : Au moins l'une des variances est différente d'une autre."]
[null,"Etant donné que la p-value calculée est inférieure au niveau de signification alpha=0,05, on doit rejeter l'hypothèse nulle H0, et retenir l'hypothèse alternative Ha."]
[]
[]
[]
[null,"Synthèse (p-values) :"]
[]
[null,"Levene","Bartlett"]
[null,2.7326355984958399E-8,3.0547839813266364E-9]