Multiple calibration level and % residual error on each point.

Hi, 

I want to show my statistical deviation on each point in openlab CDS report for a multiple level calibration. 

For example, if I perform a 4 level butane calibration curve from 500 to 5000 ppm, I want to show the residual déviation on each point in a report. 

Can you help me doing this? 

Thank you. 

JF Fortin

Parents
  • Do you mean the vertical distance between each point and the curve? If so, theoretically it shouldn't be too hard, but practically it is if you don't know what type of curve it will be beforehand. I'm unaware of any features that allow you to do this easily, but there may be some. What I have done previously is save the calibration curve constants, then use those along with the calibration curve type to calculate it. It will be much, much easier if you know that it will only be a specific type of curve (e.g. linear). You can follow the steps below:

    1. Filter for the last calibration injection within the bracket for this curve (if you are using the default bracketing mode) using a group.

    2. Save the curve coefficients (CalibCurve_A_Coefficient, CalibCurve_B_Coefficient, and CalibCurve_C_Coefficient), which you should be able to find in the variables. Save them with a scope of Compound_Name.

    3. Make a table and filter for Sample_Type=1, repeat by column (by group or by the table repeat)

    4. In one of the columns, use the Area (or concentration depending on which is on the x axis) along with the coefficients to calculate where the curve predicts and subtract that from the concentration (or area depending on which is on the y axis). For example, if your plot has area on the y axis and concentration on the x and the curve is linear your formula would be =Peak_Area - (CoeffA(Compound_Name)*Compound_CalibAmount+CoeffB(Compound_Name)), where CoeffA(Compound_Name) and CoeffB(Compound_Name) are the previously saved variables for the coefficients.

    This will be complicated by having multiple curves for one compound within the sequence so you will need to adjust some things if that is your case. In my case I allowed all types of curves, which requires a big if statement and a few numerical checks beforehand, but trust me when I say you want to keep it simple if at all possible.

    Good luck!

    -Cole

  • Thank you Cole, I will try that. Basically, I want the % deviation of each point that are in my calibration curve. So I think you got it right. I will try it next week and comeback to you if it works.  Thank you again. 

  • Hello,

    I am not sure this is what you are looking for from the original post. The software calculates the residual, relative residual, and residual percent for the individual calibration points or the average per level depending on the method setup. The calibration table object can be used to display the values on the report. If you want something like the residual sum of squares, then that would be a custom calculation. 

  • Thank you again for your help and explanation. I will try this today and see how I can put it into a report templates. 

Reply Children
No Data
Was this helpful?