{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Données","Plan sensoriel","Tests de discrimination sensor"],"not_rendered":{"charts":0,"images":5,"macros":0,"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":"Données","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["BIERE1","BIERE2"]
["A","B"]
["C","D"]

{"sheet":"Plan sensoriel","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.4.1.12345 - Plan pour les tests de discrimination sensorielle - Début : 28/10/2021 à 09:44:40 / Fin : 28/10/2021 à 09:44:40 / Microsoft Excel 16.014527"]
[null,"Codes des produits : Classeur = tuto_FR.xlsx / Feuille = Sheet1 / Plage = 'Sheet1'!$A$1:$B$3 / 2 lignes et 2 colonnes"]
[null,"Type de test : Test triangulaire"]
[null,"Sujets : 20"]
[]
[]
[]
[]
[null,"Codes des produits :"]
[]
[null,"BIERE1","BIERE2"]
[null,"A","B"]
[null,"C","D"]
[]
[]
[null,"Identifiez le produit qui se différencie des autres."]
[]
[null,"Plan pour les tests de discrimination sensorielle :"]
[]
[null,"Sujet","Echantillon 1","Echantillon 2","Echantillon 3","Réponse du sujet","Réponse correcte","Correct / Incorrect"]
[null,"S1","D","A","C","D","D",{"$f":"IF(TEXT('Plan sensoriel'!$F$21,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$21,0)=TEXT('Plan sensoriel'!$G$21,0),\"+\",\"-\"))","v":"+"}]
[null,"S2","C","A","D","D","D",{"$f":"IF(TEXT('Plan sensoriel'!$F$22,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$22,0)=TEXT('Plan sensoriel'!$G$22,0),\"+\",\"-\"))","v":"+"}]
[null,"S3","D","B","C","C","C",{"$f":"IF(TEXT('Plan sensoriel'!$F$23,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$23,0)=TEXT('Plan sensoriel'!$G$23,0),\"+\",\"-\"))","v":"+"}]
[null,"S4","A","B","D","B","A",{"$f":"IF(TEXT('Plan sensoriel'!$F$24,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$24,0)=TEXT('Plan sensoriel'!$G$24,0),\"+\",\"-\"))","v":"-"}]
[null,"S5","C","B","A","A","B",{"$f":"IF(TEXT('Plan sensoriel'!$F$25,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$25,0)=TEXT('Plan sensoriel'!$G$25,0),\"+\",\"-\"))","v":"-"}]
[null,"S6","C","A","B","C","B",{"$f":"IF(TEXT('Plan sensoriel'!$F$26,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$26,0)=TEXT('Plan sensoriel'!$G$26,0),\"+\",\"-\"))","v":"-"}]
[null,"S7","A","B","C","B","B",{"$f":"IF(TEXT('Plan sensoriel'!$F$27,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$27,0)=TEXT('Plan sensoriel'!$G$27,0),\"+\",\"-\"))","v":"+"}]
[null,"S8","A","C","B","B","B",{"$f":"IF(TEXT('Plan sensoriel'!$F$28,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$28,0)=TEXT('Plan sensoriel'!$G$28,0),\"+\",\"-\"))","v":"+"}]
[null,"S9","B","D","A","A","A",{"$f":"IF(TEXT('Plan sensoriel'!$F$29,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$29,0)=TEXT('Plan sensoriel'!$G$29,0),\"+\",\"-\"))","v":"+"}]
[null,"S10","B","C","A","B","B",{"$f":"IF(TEXT('Plan sensoriel'!$F$30,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$30,0)=TEXT('Plan sensoriel'!$G$30,0),\"+\",\"-\"))","v":"+"}]
[null,"S11","A","D","C","D","D",{"$f":"IF(TEXT('Plan sensoriel'!$F$31,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$31,0)=TEXT('Plan sensoriel'!$G$31,0),\"+\",\"-\"))","v":"+"}]
[null,"S12","A","D","B","A","A",{"$f":"IF(TEXT('Plan sensoriel'!$F$32,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$32,0)=TEXT('Plan sensoriel'!$G$32,0),\"+\",\"-\"))","v":"+"}]
[null,"S13","A","C","D","C","D",{"$f":"IF(TEXT('Plan sensoriel'!$F$33,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$33,0)=TEXT('Plan sensoriel'!$G$33,0),\"+\",\"-\"))","v":"-"}]
[null,"S14","C","D","B","C","C",{"$f":"IF(TEXT('Plan sensoriel'!$F$34,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$34,0)=TEXT('Plan sensoriel'!$G$34,0),\"+\",\"-\"))","v":"+"}]
[null,"S15","D","C","A","D","D",{"$f":"IF(TEXT('Plan sensoriel'!$F$35,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$35,0)=TEXT('Plan sensoriel'!$G$35,0),\"+\",\"-\"))","v":"+"}]
[null,"S16","B","C","D","C","C",{"$f":"IF(TEXT('Plan sensoriel'!$F$36,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$36,0)=TEXT('Plan sensoriel'!$G$36,0),\"+\",\"-\"))","v":"+"}]
[null,"S17","B","D","C","D","C",{"$f":"IF(TEXT('Plan sensoriel'!$F$37,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$37,0)=TEXT('Plan sensoriel'!$G$37,0),\"+\",\"-\"))","v":"-"}]
[null,"S18","C","B","D","C","C",{"$f":"IF(TEXT('Plan sensoriel'!$F$38,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$38,0)=TEXT('Plan sensoriel'!$G$38,0),\"+\",\"-\"))","v":"+"}]
[null,"S19","B","A","D","A","A",{"$f":"IF(TEXT('Plan sensoriel'!$F$39,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$39,0)=TEXT('Plan sensoriel'!$G$39,0),\"+\",\"-\"))","v":"+"}]
[null,"S20","D","B","A","A","A",{"$f":"IF(TEXT('Plan sensoriel'!$F$40,0)=\"\",\"\",IF(TEXT('Plan sensoriel'!$F$40,0)=TEXT('Plan sensoriel'!$G$40,0),\"+\",\"-\"))","v":"+"}]

{"sheet":"Tests de discrimination sensor","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,1,32,9]]}
[null,"XLSTAT 2021.4.1.12345 - Tests de discrimination sensorielle - Début : 28/10/2021 à 15:06:25 / Fin : 28/10/2021 à 15:06:26 / Microsoft Excel 16.014527"]
[null,"Résultats du test de discrimination : Classeur = tuto_FR.xlsx / Feuille = Plan sensoriel / Plage = 'Plan sensoriel'!$H$20:$H$40 / 20 lignes et 1 colonne"]
[null,"Type de test : Test triangulaire"]
[null,"Méthode : Modèle de Thurstone"]
[null,"Statistique : Clopper-Pearson"]
[null,"Puissance : Binomiale"]
[null,"Niveau de signification (%) : 5"]
[]
[]
[]
[]
[null,"Récapitulatif des options sélectionnées :"]
[]
[null,"Test","Test triangulaire"]
[null,"Nombre de sujets",20]
[null,"Prop. de rép. correctes",0.75]
[null,"Probabilité de deviner",0.33333333333333331]
[null,"d-prime",0]
[]
[]
[null,"Tests de discrimination sensorielle :"]
[]
[null,"d-prime",2.7974494528208171]
[null,"Statistique",14]
[null,"Puissance",0.98613558305745153]
[null,"p-value",1.6736595467080134E-4]
[null,"alpha",0.05]
[]
[null,"Interprétation du test :"]
[null,"H0 : La valeur de d-prime est égal à 0."]
[null,"Ha : La valeur de d-prime est plus grande que 0."]
[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,"Le risque de rejeter l'hypothèse nulle H0 alors qu'elle est vraie est inférieur à 0,02%."]
[]
[]
[null,"Paramètre estimé (Modèle de Thurstone / Clopper-Pearson) :"]
[]
[null,"Paramètres","Valeur","Ecart-type","Borne inférieure (0.95%)","Borne supérieure (0.95%)"]
[null,"Prop. de rép. correctes",0.75,9.6824583655185426E-2,0.50895412829204245,0.913428530898585]
[null,"Prob. de discrim.",0.625,0.14523687548277811,0.26343119243806373,0.8701427963478775]
[null,"d-prime",2.7974494528208171,0.59933438412628914,1.5129908443528073,4.1969139407333786]