{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","ROC Curves_HID1","ROC Curves","XLSTAT_20240308_114759_1_HID","ROC Curves_HID"],"not_rendered":{"charts":4,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"Disease","Concentration"]
[null,"-",0.52]
[null,"-",0.53]
[null,"-",0.54]
[null,"-",0.56000000000000005]
[null,"-",0.59]
[null,"-",0.59]
[null,"-",0.65]
[null,"-",0.66]
[null,"-",0.69]
[null,"-",0.69]
[null,"-",0.72]
[null,"-",0.72]
[null,"-",0.73]
[null,"-",0.73]
[null,"-",0.78]
[null,"-",0.81]
[null,"-",0.82]
[null,"-",0.82]
[null,"-",0.9]
[null,"-",0.94]
[null,"-",0.95]
[null,"-",0.96]
[null,"-",1.1399999999999999]
[null,"-",1.1599999999999999]
[null,"-",1.18]
[null,"-",1.2]
[null,"-",1.23]
[null,"-",1.25]
[null,"-",1.26]
[null,"-",1.3]
[null,"+",0.9]
[null,"+",0.98]
[null,"+",1.04]
[null,"+",1.05]
[null,"+",1.1200000000000001]
[null,"+",1.1200000000000001]
[null,"+",1.3]
[null,"+",1.31]
[null,"+",1.35]
[null,"+",1.36]
[null,"+",1.37]
[null,"+",1.38]
[null,"+",1.4]
[null,"+",1.4]
[null,"+",1.42]
[null,"+",1.43]
[null,"+",1.46]
[null,"+",1.46]
[null,"+",1.48]
[null,"+",1.5]

{"sheet":"ROC Curves_HID1","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[0,0]
[0,0.05]
[0,0.1]
[0,0.2]
[0,0.25]
[0,0.3]
[0,0.4]
[0,0.45]
[0,0.5]
[0,0.55000000000000004]
[0,0.6]
[0,0.65]
[3.3333333333333326E-2,0.7]
[6.6666666666666652E-2,0.7]
[0.1,0.7]
[0.1333333333333333,0.7]
[0.16666666666666663,0.7]
[0.2,0.7]
[0.23333333333333328,0.7]
[0.26666666666666672,0.7]
[0.26666666666666672,0.8]
[0.26666666666666672,0.85]
[0.26666666666666672,0.9]
[0.26666666666666672,0.95]
[0.3,0.95]
[0.33333333333333337,0.95]
[0.3666666666666667,0.95]
[0.4,1]
[0.46666666666666667,1]
[0.5,1]
[0.53333333333333333,1]
[0.6,1]
[0.66666666666666674,1]
[0.73333333333333339,1]
[0.76666666666666661,1]
[0.8,1]
[0.8666666666666667,1]
[0.9,1]
[0.93333333333333335,1]
[0.96666666666666667,1]
[1,1]

{"sheet":"ROC Curves","index":2,"n_rows":177,"n_cols":19,"rows_kept":177,"cut":false,"hidden":false,"merged":[[176,1,177,9]]}
[null,"XLSTAT 2023.3.1.1416 - ROC Curves - Start time: 08/03/2024 at 11:49:02 / End time: 08/03/2024 at 11:49:03 / Microsoft Excel 16.017328"]
[null,"Event data: Workbook = demoROC (1).xls / Sheet = Data / Range = Data!$B$1:$B$51 / 50 rows and 1 column"]
[null,"Test data: Workbook = demoROC (1).xls / Sheet = Data / Range = Data!$C$1:$C$51 / 50 rows and 1 column"]
[null,"Size (%): 95 / Wald (Continuity correction)"]
[null,"Area under the curve (Variance): Bamber"]
[null,"Costs: TP = 1 / TN = 1 / FP = 2 / FN = 4"]
[]
[]
[]
[]
[null,"Summary statistics (Concentration):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Concentration",50,0,50,0.52,1.5,1.0290000000000001,0.31262058897817535]
[]
[]
[null,"Disease","Frequency","%"]
[null,"-",30,0.6]
[null,"+",20,0.4]
[null,"Prevalence",0.4,0.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"ROC analysis:"]
[]
[null,"Concentration","Sensitivity","Lower bound (95%)","Upper bound (95%)","Specificity","Lower bound (95%)","Upper bound (95%)","Cost","PPV","NPV","LR+","LR-","TP","TN","FP","FN","Sensitivity+Specificity","Accuracy"]
[null,0.52,1,0.80609150915203664,1,0,0,0.13791318830091603,80,0.4,null,1,null,20,0,30,0,1,0.4]
[null,0.53,1,0.80609150915203664,1,3.3333333333333333E-2,0,0.18357442525927675,79,0.40816326530612246,1,1.0344827586206897,0,20,1,29,0,1.0333333333333334,0.42]
[null,0.54,1,0.80609150915203664,1,6.6666666666666666E-2,9.349083226086477E-3,0.22594503442097236,78,0.41666666666666669,1,1.0714285714285714,0,20,2,28,0,1.0666666666666667,0.44]
[null,0.56000000000000005,1,0.80609150915203664,1,0.1,2.8013122564644666E-2,0.26610452449417887,77,0.42553191489361702,1,1.1111111111111112,0,20,3,27,0,1.1000000000000001,0.46]
[null,0.59,1,0.80609150915203664,1,0.13333333333333333,4.8330695438764559E-2,0.3046104810318237,76,0.43478260869565216,1,1.1538461538461537,0,20,4,26,0,1.1333333333333333,0.48]
[null,0.65,1,0.80609150915203664,1,0.2,9.2713207405163062E-2,0.37787502788895455,74,0.45454545454545459,1,1.25,0,20,6,24,0,1.2,0.52]
[null,0.66,1,0.80609150915203664,1,0.23333333333333334,0.11641277193578237,0.41299899277009999,73,0.46511627906976749,1,1.3043478260869565,0,20,7,23,0,1.2333333333333334,0.54]
[null,0.69,1,0.80609150915203664,1,0.26666666666666666,0.14096118119136924,0.44727411292627783,72,0.47619047619047616,1,1.3636363636363638,0,20,8,22,0,1.2666666666666666,0.56000000000000005]
[null,0.72,1,0.80609150915203664,1,0.33333333333333331,0.19230931991433239,0.51357303302684409,70,0.5,1,1.5,0,20,10,20,0,1.3333333333333333,0.6]
[null,0.73,1,0.80609150915203664,1,0.4,0.24633681562043203,0.57719259614427387,68,0.52631578947368418,1,1.6666666666666667,0,20,12,18,0,1.4,0.64]
[null,0.78,1,0.80609150915203664,1,0.46666666666666667,0.30281373292736813,0.63836273766086715,66,0.55555555555555558,1,1.875,0,20,14,16,0,1.4666666666666668,0.68]
[null,0.81,1,0.80609150915203664,1,0.5,0.33193447486055339,0.66806552513944661,65,0.57142857142857151,1,2,0,20,15,15,0,1.5,0.7]
[null,0.82,1,0.80609150915203664,1,0.53333333333333333,0.36163726233913285,0.69718626707263187,64,0.58823529411764719,1,2.1428571428571428,0,20,16,14,0,1.5333333333333332,0.72]
[null,0.9,1,0.80609150915203664,1,0.6,0.42280740385572618,0.75366318437956803,62,0.625,1,2.5,0,20,18,12,0,1.6,0.76]
[null,0.94,0.95,0.74268730872893374,1,0.6333333333333333,0.45430010536373155,0.78099401228332732,64,0.63333333333333341,0.95,2.5909090909090908,7.8947368421052641E-2,19,19,11,1,1.5833333333333333,0.76]
[null,0.95,0.95,0.74268730872893374,1,0.66666666666666663,0.48642696697315591,0.80769068008566769,63,0.65517241379310343,0.95238095238095233,2.85,7.5000000000000011E-2,19,20,10,1,1.6166666666666667,0.78]
[null,0.96,0.95,0.74268730872893374,1,0.7,0.51922083375266659,0.83372034271792173,62,0.67857142857142849,0.95454545454545447,3.1666666666666665,7.1428571428571438E-2,19,21,9,1,1.65,0.8]
[null,0.98,0.95,0.74268730872893374,1,0.73333333333333328,0.55272588707372217,0.85903881880863087,61,0.70370370370370372,0.9565217391304347,3.5625,6.8181818181818191E-2,19,22,8,1,1.6833333333333331,0.82]
[null,1.04,0.9,0.68423382135690369,0.98243284530976305,0.73333333333333328,0.55272588707372217,0.85903881880863087,64,0.6923076923076924,0.91666666666666674,3.375,0.13636363636363638,18,22,8,2,1.6333333333333333,0.8]
[null,1.05,0.85,0.6291892403575442,0.95414409297578906,0.73333333333333328,0.55272588707372217,0.85903881880863087,67,0.68,0.88,3.1875,0.20454545454545456,17,22,8,3,1.5833333333333333,0.78]
[null,1.1200000000000001,0.8,0.57676202195629034,0.92323797804370966,0.73333333333333328,0.55272588707372217,0.85903881880863087,70,0.66666666666666663,0.84615384615384626,3,0.27272727272727276,16,22,8,4,1.5333333333333332,0.76]
[null,1.1399999999999999,0.7,0.47806904432063801,0.85526428901269524,0.73333333333333328,0.55272588707372217,0.85903881880863087,76,0.63636363636363624,0.7857142857142857,2.625,0.40909090909090912,14,22,8,6,1.4333333333333331,0.72]
[null,1.1599999999999999,0.7,0.47806904432063801,0.85526428901269524,0.76666666666666672,0.58700100722990012,0.88358722806421763,75,0.66666666666666674,0.79310344827586199,2.9999999999999996,0.39130434782608692,14,23,7,6,1.4666666666666668,0.74]
[null,1.18,0.7,0.47806904432063801,0.85526428901269524,0.8,0.62212497211104534,0.90728679259483691,74,0.70000000000000007,0.8,3.4999999999999996,0.37499999999999994,14,24,6,6,1.5,0.76]
[null,1.2,0.7,0.47806904432063801,0.85526428901269524,0.83333333333333337,0.65820476635340852,0.93003052776423845,73,0.73684210526315796,0.80645161290322587,4.2,0.36,14,25,5,6,1.5333333333333332,0.78]
[null,1.23,0.7,0.47806904432063801,0.85526428901269524,0.8666666666666667,0.69538951896817625,0.95166930456123544,72,0.7777777777777779,0.8125,5.25,0.34615384615384615,14,26,4,6,1.5666666666666667,0.8]
[null,1.25,0.7,0.47806904432063801,0.85526428901269524,0.9,0.73389547550582113,0.97198687743535528,71,0.82352941176470584,0.81818181818181823,6.9999999999999991,0.33333333333333331,14,27,3,6,1.6,0.82]
[null,1.26,0.7,0.47806904432063801,0.85526428901269524,0.93333333333333335,0.77405496557902764,0.99065091677391348,70,0.875,0.82352941176470584,10.5,0.3214285714285714,14,28,2,6,1.6333333333333333,0.84]
[null,1.3,0.7,0.47806904432063801,0.85526428901269524,0.96666666666666667,0.81642557474072319,1,69,0.93333333333333324,0.82857142857142851,21,0.31034482758620691,14,29,1,6,1.6666666666666665,0.86]
[null,1.31,0.65,0.43131405240482457,0.81868594759517543,1,0.86208681169908397,1,71,1,0.81081081081081074,"+Inf",0.35,13,30,0,7,1.65,0.86]
[null,1.35,0.6,0.38609321868796859,0.7805734479786981,1,0.86208681169908397,1,74,1,0.78947368421052633,"+Inf",0.4,12,30,0,8,1.6,0.84]
[null,1.36,0.55000000000000004,0.34232446656091381,0.74100886677241951,1,0.86208681169908397,1,77,1,0.76923076923076916,"+Inf",0.45,11,30,0,9,1.55,0.82]
[null,1.37,0.5,0.29996201348519547,0.70003798651480453,1,0.86208681169908397,1,80,1,0.74999999999999989,"+Inf",0.5,10,30,0,10,1.5,0.8]
[null,1.38,0.45,0.25899113322758049,0.65767553343908614,1,0.86208681169908397,1,83,1,0.7317073170731706,"+Inf",0.55000000000000004,9,30,0,11,1.45,0.78]
[null,1.4,0.4,0.21942655202130193,0.61390678131203147,1,0.86208681169908397,1,86,1,0.7142857142857143,"+Inf",0.6,8,30,0,12,1.4,0.76]
[null,1.42,0.3,0.14473571098730473,0.52193095567936187,1,0.86208681169908397,1,92,1,0.68181818181818188,"+Inf",0.7,6,30,0,14,1.3,0.72]
[null,1.43,0.25,0.10982026609321802,0.47351306724011533,1,0.86208681169908397,1,95,1,0.66666666666666663,"+Inf",0.75,5,30,0,15,1.25,0.7]
[null,1.46,0.2,7.6762021956290311E-2,0.42323797804370966,1,0.86208681169908397,1,98,1,0.65217391304347816,"+Inf",0.8,4,30,0,16,1.2,0.68]
[null,1.48,0.1,1.7567154690236925E-2,0.31576617864309642,1,0.86208681169908397,1,104,1,0.625,"+Inf",0.9,2,30,0,18,1.1000000000000001,0.64]
[null,1.5,0.05,0,0.25731269127106626,1,0.86208681169908397,1,107,1,0.61224489795918369,"+Inf",0.95,1,30,0,19,1.05,0.62]
[null,"Test is positive if Concentration >= threshold value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Area under the curve (AUC):"]
[]
[null,"AUC","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,0.91333333333333322,3.8011418243979557E-2,0.83883232257384455,0.98783434409282189]
[]
[]
[null,"Comparison of the AUC to 0.5:"]
[]
[null,"95% confidence interval on the difference between the AUC and 0.5 (Two-tailed test):"]
[null,0.33883232257384455,0.48783434409282189]
[]
[null,"Difference",0.41333333333333327]
[null,"z (Observed value)",10.873925584157837]
[null,"z (Critical value)",1.9599639845400536]
[null,"p-value (Two-tailed)","< 0,0001"]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The AUC is equal to 0.5."]
[null,"Ha: The AUC is different from 0.5."]
[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."]

{"sheet":"XLSTAT_20240308_114759_1_HID","index":3,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[0,0]
[0,0.05,null,0.95]
[0,0.1,null,0.9]
[0,0.2,null,0.8]
[0,0.25,null,0.75]
[0,0.3,null,0.7]
[0,0.4,null,0.6]
[0,0.45,null,0.55000000000000004]
[0,0.5,null,0.5]
[0,0.55000000000000004,null,0.44999999999999996]
[0,0.6,null,0.4]
[0,0.65,null,0.35]
[3.3333333333333326E-2,0.7,3.3333333333333326E-2,0.30000000000000004]
[6.6666666666666652E-2,0.7,6.6666666666666652E-2,0.30000000000000004]
[9.9999999999999978E-2,0.7,9.9999999999999978E-2,0.30000000000000004]
[0.1333333333333333,0.7,0.1333333333333333,0.30000000000000004]
[0.16666666666666663,0.7,0.16666666666666663,0.30000000000000004]
[0.19999999999999996,0.7,0.19999999999999996,0.30000000000000004]
[0.23333333333333328,0.7,0.23333333333333328,0.30000000000000004]
[0.26666666666666672,0.7,0.26666666666666672,0.30000000000000004]
[0.26666666666666672,0.8,0.26666666666666672,0.19999999999999996]
[0.26666666666666672,0.85,0.26666666666666672,0.15000000000000002]
[0.26666666666666672,0.9,0.26666666666666672,9.9999999999999978E-2]
[0.26666666666666672,0.95,0.26666666666666672,5.0000000000000044E-2]
[0.30000000000000004,0.95,0.30000000000000004,5.0000000000000044E-2]
[0.33333333333333337,0.95,0.33333333333333337,5.0000000000000044E-2]
[0.3666666666666667,0.95,0.3666666666666667,5.0000000000000044E-2]
[0.4,1,0.4]
[0.46666666666666667,1,0.46666666666666667]
[0.5,1,0.5]
[0.53333333333333333,1,0.53333333333333333]
[0.6,1,0.6]
[0.66666666666666674,1,0.66666666666666674]
[0.73333333333333339,1,0.73333333333333339]
[0.76666666666666661,1,0.76666666666666661]
[0.8,1,0.8]
[0.8666666666666667,1,0.8666666666666667]
[0.9,1,0.9]
[0.93333333333333335,1,0.93333333333333335]
[0.96666666666666667,1,0.96666666666666667]
[1,1]

{"sheet":"ROC Curves_HID","index":4,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[0,0]
[0,0.05]
[0,0.1]
[0,0.2]
[0,0.25]
[0,0.3]
[0,0.4]
[0,0.45]
[0,0.5]
[0,0.55000000000000004]
[0,0.6]
[0,0.65]
[3.3333333333333326E-2,0.7]
[6.6666666666666652E-2,0.7]
[0.1,0.7]
[0.1333333333333333,0.7]
[0.16666666666666663,0.7]
[0.2,0.7]
[0.23333333333333328,0.7]
[0.26666666666666672,0.7]
[0.26666666666666672,0.8]
[0.26666666666666672,0.85]
[0.26666666666666672,0.9]
[0.26666666666666672,0.95]
[0.3,0.95]
[0.33333333333333337,0.95]
[0.3666666666666667,0.95]
[0.4,1]
[0.46666666666666667,1]
[0.5,1]
[0.53333333333333333,1]
[0.6,1]
[0.66666666666666674,1]
[0.73333333333333339,1]
[0.76666666666666661,1]
[0.8,1]
[0.8666666666666667,1]
[0.9,1]
[0.93333333333333335,1]
[0.96666666666666667,1]
[1,1]