{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Association coefficients"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,3,0],[0,2,0,3]]}
[null,null,"Doctor 1"]
[null,null,"healthy","diseased"]
["Doctor 2","healthy",34,4]
[null,"diseased",3,21]

{"sheet":"Association coefficients","index":1,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[[17,1,18,9],[32,1,33,9]]}
[null,"XLSTAT 2023.1.2.1406 - Tests on contingency tables (Chi-square...) - Start time: 30/05/2023 at 15:47:43 / End time: 30/05/2023 at 15:47:43 / Microsoft Excel 16.016327"]
[null,"Contingency table: Workbook = demoCohenKappa.xlsm / Sheet = Data / Range = Data!$B$2:$D$4 / 2 rows and 3 columns"]
[]
[]
[]
[]
[null,"Test of independence between the rows and the columns (Chi-square):"]
[]
[null,"Chi-square (Observed value)",36.218406827880514]
[null,"Chi-square (Critical value)",3.8414588206760336]
[null,"DF",1]
[null,"p-value",1.7639656402224091E-9]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The rows and the columns of the table are independent."]
[null,"Ha: There is a link between the rows and the columns of the table."]
[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,"Test of independence between the rows and the columns (Chi-square with Yates' continuity correction):"]
[]
[null,"Chi-square (Observed value)",33.090258416311052]
[null,"Chi-square (Critical value)",3.8414588206760336]
[null,"DF",1]
[null,"p-value (Two-tailed)",8.7978406781985541E-9]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The rows and the columns of the table are independent."]
[null,"Ha: There is a link between the rows and the columns of the table."]
[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,"Association coefficients (1):"]
[]
[null,"Coefficient","Value"]
[null,"Pearson's Phi",0.76430874132289561]
[null,"Contingency coefficient",0.60725098607619532]
[null,"Cramer's V",0.76430874132289561]
[null,"Tschuprow's T",0.76430874132289561]
[null,"Goodman and Kruskal tau (R/C)",0.5841678520625887]
[null,"Goodman and Kruskal tau (C/R)",0.58416785206258892]
[null,"Cohen's kappa",0.76387377584330796]
[null,"Yule's Q",0.96694214876033058]
[null,"Yule's Y",0.77047438255484602]
[]
[]
[null,"Association coefficients (2):"]
[]
[null,"Coefficient","Value","Standard deviation","Lower bound 95%","Upper bound 95%"]
[null,"Goodman and Kruskal Gamma",0.96694214876033058,2.6419704435640623E-2,0.91516047958428182,1.0187238179363793]
[null,"Kendall's tau",0.76430874132289561,8.3675872896838324E-2,0.60030704407014124,0.92831043857564999]
[null,"Stuart's tau",0.73048907388137352,9.0478016107158887E-2,0.55315542091870729,0.90782272684403975]
[null,"Somers' D (R/C)",0.75891891891891905,8.5963370478959356E-2,0.59043380879048502,0.92740402904735308]
[null,"Somers' D (C/R)",0.76973684210526305,8.3879598676677436E-2,0.60533584966130172,0.93413783454922439]
[null,"Theil's U (R/C)",0.48276416355724089,0.12156923318456965,0.24449284488733286,0.72103548222714897]
[null,"Theil's U (C/R)",0.47784826512401585,0.12137652770756077,0.23995464224866883,0.71574188799936289]
[null,"Theil's U (Symmetric)",0.4802936358767837,0.12129382842793908,0.24256210061104258,0.71802517114252484]
[null,"Log(Odds ratio)",4.0859763125515842,0.76382828115346801,2.5889003911176527,5.5830522339855158]
[null,"Odds ratio",59.5,null,13.315122123766194,265.88190232825571]
[]
[]
[null,"Contingency table:"]
[]
[null,null,"healthy","diseased"]
[null,"healthy",34,4]
[null,"diseased",3,21]