18 thoughts on “Deming Regression”

  1. Dear Dr. Zaiontz,
    Hello again.
    Is it possible to calculate prediction intervals and curves for the Deming Regression, using your tool?
    I know I have to find a t value considering 95% confidence level and the degree of freedom related to my data, and also have to determine the standard errors of the prediction values.

    Reply
  2. Dr. Zaiontz,
    Good evening.
    First of all, thank you very for the help put available in your website, specially the resource pack. I’m starting to use it to calculate and learn Deming Regression.
    My questions is: should I have always two columns or more for X and Y? I tried to use the add-in entering just one column for X (mean of 3 replicates for each sample) values and one column for Y (mean of 3 replicates) and it did not work. Only when I entered all the values (3 columns 61 rows for X, 3 columns 61 rows for Y) I got the results. It also complained about one the cells being blank.
    Regards,
    Waldemar

    Reply
    • Waldemar,
      You can have one or more columns for X as well as for y. The case where there is one column for each is shown in Example 1, while the case for more than one column for X and Y is shown in Example 2.
      If you email me an Excel file with your data and test results, I will try to figure out why it didn’t work in the case of one column for X and one column for Y. I can also see where there was a blank.
      Charles

      Reply
      • Dear Dr. Zaiontz,
        Thank you for answering. I sent you a Excel file with Xi and Yi values(3 columns for the replicates each), as well as another two columns with the averages.
        In the email I explain my objectives.
        Thank you!
        Waldemar

        Reply
  3. Dr, good evening, in Deming regression, in the case of two or more dependent variables (y), both must be the same type of response ?, or it is possible that based on the independent variables (x), two different answers (and), in which case we treat the model as a Deming regression?
    Thank you very much

    Reply
  4. Weighted or unweighted Deming regression should I use if the variable X and Y are measured with either constant error nor proportional error? It only measured with random error.
    Thank for your kind reply

    Reply
  5. Very valuable site for Excel users. But I have a comment about the Deming regression formulas.

    It seems that the variances in the x and y values (s^2 and t^2) should be written in terms of relative error, not absolute error. Otherwise, the Deming lambda is not dimensionless. Thus it would be possible to change the value of lambda merely by changing units of the x or y from, say, g to kg.

    Reply
    • Mark,
      Thanks for this insight. Do you have an easily available source that explains how to perform Deming regression in the manner that you are suggesting? Also how do you measure relative error? Are you referring to normalizing (i.e. standardizing) the data first?
      Charles

      Reply

Leave a Comment