Statistics add-in software for statistical analysis in Excel
  • Tutorials
  • Bland-Altman method comparison tutorial

Estimating regression based limits of agreement when transformation is not enough

Sometimes, a transformation does not solve the problem of a relationship between the differences and magnitude. For example, this could occur when differences are negative for low values and positive for high values.

To illustrate these concepts, we will use another example from Bland & Altman’s 1999 paper. In this example, the fat content of human milk was measured by enzymic procedures for the determination of triglycerides and using the standard Gerber method.

  1. Open the file tutorials\Fat.xlsx.
    The analysis report on the Fat worksheet shows that the differences are related to the magnitude, although the variability looks fairly constant throughout the measuring interval.
  2. On the Analyse-it ribbon tab, in the Report group, click Edit.
    The analysis task pane opens.
  3. On the Analyse-it ribbon tab, in the Method Comparison group, click Estimate Agreement Limits.
    The Fit Differences task is added to the analysis task pane.
  4. In the Mean function drop-down list, select Linear.
  5. Click Recalculate.
    The results are recalculated and the analysis report updates.

The difference plot shows the average bias estimated using a linear regression. The limits of agreement are estimated using the residual standard deviation from the regression.

The p-value of the slope term is significant (p < 0.05) and confirms that the average difference is related to the magnitude.

If we suspect that the variability of the differences is also related to the mean, we could model the SD using the residuals from the fit.

Next topic: Estimating nonparametric limits of agreement in non-normally distributed data

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Plotting the relationship between methods
  •  Estimating the average bias and the limits of agreement
  •  Understanding the importance of repeatability
  •  Using repeated measurements
  •  Dealing with a relationship between difference and magnitude of measurement
  •  Transforming the measurements to remove a relationship between differences and magnitude
  •  Estimating regression based limits of agreement when transformation is not enough
  •  Estimating nonparametric limits of agreement in non-normally distributed data
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.