Passing-Bablok Regression Support

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.

Output Passing-Bablok functions

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.

Passing-Bablok dialog box

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/

Leave a Comment