{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Friedman"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"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":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fromage1","Fromage2","Fromage3","Fromage4"]
[null,"Expert1",2,1,2.5,1.5]
[null,"Expert2",2,4,7,2.8]
[null,"Expert3",3,2,4,2]
[null,"Expert4",1,1,4,2]
[null,"Expert5",1,1,2,2]
[null,"Expert6",2,1.5,4,2.5]
[null,"Expert7",2,1,3,2]
[null,"Expert8",1,0.5,4.3,2]
[null,"Expert9",2.2999999999999998,1.3,4.3,3.3]
[null,"Expert10",3,2.8,4,4]

{"sheet":"Friedman","index":1,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[30,1,31,9],[39,5,39,6]]}
[null,"XLSTAT 2018.7.12345 - Comparaison de k échantillons (Kruskal-Wallis, Friedman, ...) - Début : 14/01/2019 à 11:41:25 / Fin : 14/01/2019 à 11:41:26 / Microsoft Excel 16.04795"]
[null,"Echantillons: Classeur = demoFriedmanf.xls / Feuille = Data / Plage = Data!$C$1:$F$11 / 10 lignes et 4 colonnes"]
[null,"Niveau de signification (%) : 5"]
[null,"p-value : p-value asymptotique"]
[null,"Correction de continuité : Oui"]
[]
[]
[]
[]
[null,"Statistiques descriptives :"]
[]
[null,"Variable","Observations","Obs. avec données manquantes","Obs. sans données manquantes","Minimum","Maximum","Moyenne","Ecart-type"]
[null,"Fromage1",10,0,10,1,3,1.93,0.74840571290651647]
[null,"Fromage2",10,0,10,0.5,4,1.61,1.0598217879540985]
[null,"Fromage3",10,0,10,2,7,3.9099999999999997,1.3477965556995446]
[null,"Fromage4",10,0,10,1.5,4,2.41,0.75638026885364418]
[]
[]
[null,"Test de Friedman :"]
[]
[null,"Q (Valeur observée)",22.5]
[null,"Q (Valeur critique)",7.8147279032535604]
[null,"DDL",3]
[null,"p-value (unilatérale)","< 0,0001"]
[null,"alpha",0.05]
[null,"Une approximation a été utilisée pour calculer la p-value."]
[]
[null,"Interprétation du test :"]
[null,"H0 : Les échantillons proviennent de la même population."]
[null,"Ha : Les échantillons proviennent de populations différentes."]
[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,"Des ex-aequo ont été détectés et les corrections appropriées ont été appliquées."]
[]
[]
[null,"Comparaisons multiples par paires suivant la procédure de Nemenyi / Test bilatéral :"]
[]
[null,"Echantillon","Effectif","Somme des rangs","Moyenne des rangs","Groupes"]
[null,"Fromage2",10,13.5,1.35,"A"]
[null,"Fromage1",10,20.5,2.0499999999999998,"A"]
[null,"Fromage4",10,27,2.7,"A","B"]
[null,"Fromage3",10,39,3.9,null,"B"]
[]
[]
[null,"Comparaisons par paires :"]
[]
[null,"Wij :"]
[]
[null,null,"Fromage1","Fromage2","Fromage3","Fromage4"]
[null,"Fromage1",0,0.69999999999999973,-1.85,-0.65000000000000036]
[null,"Fromage2",-0.69999999999999973,0,-2.5499999999999998,-1.35]
[null,"Fromage3",1.85,2.5499999999999998,0,1.1999999999999997]
[null,"Fromage4",0.65000000000000036,1.35,-1.1999999999999997,0]
[null,"Différence critique : 1,4936"]
[]
[]
[null,"p-values :"]
[]
[null,null,"Fromage1","Fromage2","Fromage3","Fromage4"]
[null,"Fromage1",1,0.61955554046678296,8.3120643290653939E-3,0.67394798071253903]
[null,"Fromage2",0.61955554046678296,1,"< 0,0001",9.232938273978486E-2]
[null,"Fromage3",8.3120643290653939E-3,"< 0,0001",1,0.16310266491997105]
[null,"Fromage4",0.67394798071253903,9.232938273978486E-2,0.16310266491997105,1]
[]
[]
[null,"Différences significatives :"]
[]
[null,null,"Fromage1","Fromage2","Fromage3","Fromage4"]
[null,"Fromage1","Non","Non","Oui","Non"]
[null,"Fromage2","Non","Non","Oui","Non"]
[null,"Fromage3","Oui","Oui","Non","Non"]
[null,"Fromage4","Non","Non","Non","Non"]