{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","R-Index","XLSTAT_20241204_152736_1_HID","XLSTAT_20241204_152429_1_HID"],"not_rendered":{"charts":1,"images":5,"macros":1,"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":"Feuil1","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Sample","Answer"]
["Chocolate0",1]
["Chocolate1",2]
["Chocolate2",3]
["Chocolate3",4]
["Chocolate4",4]
["Chocolate0",2]
["Chocolate1",2]
["Chocolate2",2]
["Chocolate3",1]
["Chocolate4",4]
["Chocolate0",1]
["Chocolate1",4]
["Chocolate2",1]
["Chocolate3",4]
["Chocolate4",3]
["Chocolate0",1]
["Chocolate1",1]
["Chocolate2",1]
["Chocolate3",2]
["Chocolate4",2]

{"sheet":"R-Index","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2024.4.0.1424 - R-Index - Start time: 04/12/2024 at 15:27:37 / End time: 04/12/2024 at 15:27:38 / Microsoft Excel 16.018129"]
[null,"Raw data: Workbook = RIndextuto.xlsm / Sheet = Feuil1 / Range = 'Feuil1'!$B:$B / 20 rows and 1 column"]
[null,"Sample identifiers: Workbook = RIndextuto.xlsm / Sheet = Feuil1 / Range = 'Feuil1'!$A:$A / 20 rows and 1 column"]
[null,"Significance level (%): 5"]
[]
[]
[]
[]
[null,"Response matrix:"]
[]
[null,"Sample","Same and Sure","Same but Unsure","Different but Unsure","Different and Sure"]
[null,"Chocolate0",3,1,0,0]
[null,"Chocolate1",1,2,0,1]
[null,"Chocolate2",2,1,1,0]
[null,"Chocolate3",1,1,0,2]
[null,"Chocolate4",0,1,1,2]
[]
[]
[null,"Summary of the analysis:"]
[]
[null,"Sample","Chocolate0","Chocolate1","Chocolate2","Chocolate3","Chocolate4"]
[null,"R-Index",0.5,0.78125,0.65625,0.8125,0.96875]
[null,"Standard deviation",0.28867513459481287,0.23867581744561667,0.27421763710600383,0.22534695471649932,0.10045469542700995]
[null,"Z-scores",0,1.1783766072743589,0.56980288229818976,1.386750490563073,4.6662826262869137]
[null,"p-value",1,0.23864649932417548,0.56881140041333733,0.16551785869746993,3.0669777655312203E-6]
[null,"The value of the R-Index is between 0 and 1. The closer this value is to 1, the more the sample tested was identified as being different from the reference product. An R-Index of 0.5 or less means that the product was identified as being perfectly similar to the reference product."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"XLSTAT_20241204_152736_1_HID","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["Chocolate0",0.5]
["Chocolate1",0.78125]
["Chocolate2",0.65625]
["Chocolate3",0.8125]
["Chocolate4",0.96875]

{"sheet":"XLSTAT_20241204_152429_1_HID","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["Chocolate0",0.5]
["Chocolate1",0.78125]
["Chocolate2",0.65625]
["Chocolate3",0.8125]
["Chocolate4",0.96875]