{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Passing and Bablok","Passing and Bablok_HID2","Passing and Bablok_HID1","Passing and Bablok_HID"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":4,"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":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Ref","NM"]
[null,9.8000000000000007,10.1]
[null,9.6999999999999993,11.4]
[null,10.7,10.8]
[null,10.9,11.3]
[null,12.4,11.8]
[null,12.5,12.1]
[null,12.8,12.3]
[null,12.85,13.6]
[null,12.9,14.2]
[null,13.3,14.4]
[null,13.4,14.6]
[null,13.5,15.3]
[null,13.7,15.5]
[null,14.9,15.8]
[null,15.2,16.2]
[null,15.5,16.5]

{"sheet":"Passing and Bablok","index":1,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[[93,1,94,9]]}
[null,"XLSTAT 2022.2.1.12345 - Passing and Bablok regression - Start time: 17/05/2022 at 11:35:30 / End time: 17/05/2022 at 11:35:31 / Microsoft Excel 16.015128"]
[null,"Y method: Workbook = DemoPassingBablok01.xls / Sheet = Data / Range = 'Data'!$C:$C / 16 rows and 1 column"]
[null,"X method: Workbook = DemoPassingBablok01.xls / Sheet = Data / Range = 'Data'!$B:$B / 16 rows and 1 column"]
[null,"Method: Part I: same scale"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"NM",16,0,16,10.1,16.5,13.49375,2.0933127652917358]
[null,"Ref",16,0,16,9.6999999999999993,15.5,12.753125000000001,1.7555121522412385]
[]
[]
[null,"Model coefficients:"]
[]
[null,null,"Value","Lower bound 95% (Mean)","Upper bound 95% (Mean)"]
[null,"Intercept",-1.9696428571428584,-6.4785714285714313,2.3428571428571381]
[null,"Slope coefficient",1.2142857142857144,0.9047619047619051,1.5714285714285716]
[]
[]
[null,"Predictions and residuals:"]
[]
[null,null,"Ref","NM","Difference","Pred(NM)","Residuals","Perpendicular residuals"]
[null,"Obs1",9.8000000000000007,10.1,0.29999999999999893,9.9303571428571438,0.16964285714285587,0.10784319468147772]
[null,"Obs2",9.6999999999999993,11.4,1.7000000000000011,9.8089285714285701,1.5910714285714302,1.0114556469629195]
[null,"Obs3",10.7,10.8,0.10000000000000142,11.023214285714285,-0.2232142857142847,-0.14189894037066142]
[null,"Obs4",10.9,11.3,0.40000000000000036,11.266071428571429,3.392857142857153E-2,2.1568638934371654E-2]
[null,"Obs5",12.4,11.8,-0.59999999999999964,13.0875,-1.2874999999999996,-0.81847308805865548]
[null,"Obs6",12.5,12.1,-0.40000000000000036,13.208928571428572,-1.1089285714285726,-0.70495393576201315]
[null,"Obs7",12.8,12.3,-0.5,13.573214285714286,-1.2732142857142854,-0.8093915558748549]
[null,"Obs8",12.85,13.6,0.75,13.633928571428571,-3.392857142857153E-2,-2.1568638935689388E-2]
[null,"Obs9",12.9,14.2,1.2999999999999989,13.694642857142858,0.50535714285714128,0.3212592009993418]
[null,"Obs10",13.3,14.4,1.0999999999999996,14.180357142857144,0.21964285714285658,0.13962855732472865]
[null,"Obs11",13.4,14.6,1.1999999999999993,14.301785714285714,0.29821428571428577,0.18957698433559439]
[null,"Obs12",13.5,15.3,1.8000000000000007,14.423214285714288,0.87678571428571317,0.55737903777642916]
[null,"Obs13",13.7,15.5,1.8000000000000007,14.666071428571428,0.83392857142857224,0.53013444122515052]
[null,"Obs14",14.9,15.8,0.90000000000000036,16.123214285714287,-0.32321428571428612,-0.20546966565667574]
[null,"Obs15",15.2,16.2,1,16.487500000000001,-0.28750000000000142,-0.18276583519774028]
[null,"Obs16",15.5,16.5,1,16.851785714285715,-0.35178571428571459,-0.22363273002405037]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Test of linearity / (Two-tailed test):"]
[]
[null,"Max(|Cusum|) (Observed value)",3]
[null,"Max(|Cusum|) (Critical value)",5.4323945572900803]
[null,"p-value (Two-tailed)",0.62716704177626015]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The relationship between the two variables is linear"]
[null,"Ha: The relationship between the two variables is not linear"]
[null,"As the computed p-value is greater than the significance level alpha=0,05, one cannot reject the null hypothesis H0."]

{"sheet":"Passing and Bablok_HID2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Passing and Bablok_HID1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Passing and Bablok_HID","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}