Worksheet Functions
Real Statistics Functions: The Real Statistics Resource Pack contains the following functions where R1 and R2 are column arrays containing the x and y values respectively.
PBRegCoeff(R1, R2, lab, alpha): array function that returns a column array with the values: slope and intercept coefficients, as well as their 1-alpha confidence intervals
PBTEST(R1, R2, lab, alpha): array function that returns a column array with the values h-stat, h-crit, and p-value.
If lab = TRUE (default FALSE) then an extra column of labels is appended. alpha = significance level (default .05).
For Example 1 of Passing-Bablok Regression Basic Concepts, the output from these functions is shown in Figure 1.
Figure 1 – Passing-Bablok functions
Data Analysis Tool
Real Statistics Data Analysis Tool: The Real Statistics Resource Pack also supplies a Passing-Bablok Regression data analysis tool.
To use this tool for Example 1 of Passing-Bablok Regression Basic Concepts, press Ctrl-m and choose the Passing-Bablok Regression option from the Reg tab (or from the Regression menu if using the original menu). Fill in the dialog box that appears as shown in Figure 2 and click on the OK button to get a report similar to that shown in Figure 1.
Figure 2 – Passing-Bablok Regression dialog box
Examples Workbook
Click here to download the Excel workbook with the examples described on this webpage.
References
Hintze, J. L. (2020) Passing-Bablok regression for method comparison. NCSS
https://www.ncss.com/wp-content/themes/ncss/pdf/Procedures/NCSS/Passing-Bablok_Regression_for_Method_Comparison.pdf
Passing, H. and Bablok, W. (1983, 1984) Comparison of several regression procedures for method comparison studies and determination of sample sizes. Application of linear regression procedures for method comparison studies in Clinical Chemistry. J. Clin. Chem. Clin. Biochem
https://pubmed.ncbi.nlm.nih.gov/6481307/