﻿ Need some help my job depends on it..calibration curve excel - Chromatography Forum

Need some help my job depends on it..calibration curve excel

Discussions about HPLC, CE, TLC, SFC, and other "liquid phase" separation techniques.

Need some help my job depends on it..calibration curve excel

Hello...ive been trying to determine for 3 days now a unknown. I have a calibration curve run on hplc with the following peak areas:
Conc (mg/L) Peak Area
0 0
0.001 43162
0.01 1027039
0.05 4623058
0.1 8742401

The unknown peak area is 1227456 so i should be able to put this in the equation of the line and be able to detemine the concentration!!...but i keep getting strange answers! 1227456-61347/9e+07=118.15. my equation of the line is
y= 9E+07x + 61347
i should be able to put the unknown into this equation and get a concentration but instead i get a strange answer....please help....i know its something simple im doing wrong

Re: Need some help my job depends on it..calibration curve e

seamoro wrote:
Hello...ive been trying to determine for 3 days now a unknown. I have a calibration curve run on hplc with the following peak areas:
Conc (mg/L) Peak Area
0 0
0.001 43162
0.01 1027039
0.05 4623058
0.1 8742401

The unknown peak area is 1227456 so i should be able to put this in the equation of the line and be able to detemine the concentration!!...but i keep getting strange answers! 1227456-61347/9e+07=118.15. my equation of the line is
y= 9E+07x + 61347
i should be able to put the unknown into this equation and get a concentration but instead i get a strange answer....please help....i know its something simple im doing wrong

concentration is 0,0133

try to calculate:

(1227456-61347)/9e+07=

Re: Need some help my job depends on it..calibration curve e

Which function are you using?

Code: Select all

``. A      B1 0      02 0.001  43,1633 0.01   1,027,0404 0.05   4,623,0595 0.1    8,742,4026 ?      1227456 (unknown)``

Not constrained to zero: =FORECAST(B6,A1:A5,B1:B5)
Constrained to zero: =LINEST(A1:A5,B1:B5,FALSE,FALSE)*B6

Re: Need some help my job depends on it..calibration curve e

in fact L.R implemented in HP 35s

Re: Need some help my job depends on it..calibration curve e

Hope your problem is solved by now. If at all possible, you should consider using instrument software rather than Excel to do the calibration. Amongst other reasons, instrument software will almost always offer a multitude of other features, such as weighted least squares (rather than treating all points as equally important), or curved fits for calibrations that don't lie on a straight line. Many instrument software packages can also be set up to warn you if your values are way outside the range of the calibration curve, or other problems have happened that make the data unreliable.

Re: Need some help my job depends on it..calibration curve e

Don't use the antilog function on your calculator to enter 9E+07, use the EXP key instead
Good judgment comes from bad experience, and a lot of that comes from bad judgment.

Re: Need some help my job depends on it..calibration curve e

incidentally, while we're on subjects like that, I sincerely hope you're not using 9E+07. I'd suggest working to a precision better than one significant figure...

Re: Need some help my job depends on it..calibration curve e

JGK wrote:
Don't use the antilog function on your calculator to enter 9E+07, use the EXP key instead

Well spoted.
I would never guess he calculated "e" to the power of 7, and really rounded slope value to one significant digit.

Re: Need some help my job depends on it..calibration curve e

JGK wrote:
Don't use the antilog function on your calculator to enter 9E+07, use the EXP key instead

Is it wrong that this made me laugh,

also your 0 = 0 point, did you get this number experimentally from a blank? Or are you just assuming 0 concentration will be a 0 area?

Re: Need some help my job depends on it..calibration curve e

Well, if you haven't figured out what you did wrong, you had the axes incorrect. The equation you have X = Concentration and Y = Area

The correct equation is

Y = 1.13827E-08X - 0.00066

which gives the result of 0.013308371

Re: Need some help my job depends on it..calibration curve e

damn right that your job is on the block if you can't solve a basic high school level linear equation...

Re: Need some help my job depends on it..calibration curve e

michaelbarnes42 wrote:
Well, if you haven't figured out what you did wrong, you had the axes incorrect. The equation you have X = Concentration and Y = Area

The correct equation is

Y = 1.13827E-08X - 0.00066

which gives the result of 0.013308371

Are you kidding ?

Your equation is completely wrong (provided Y is peak area and X is concentration) - it gives peak area lower then zero for concentration 0.0133.
Gentelman, Ordinary Linear Regression is something which should be called "basics" for analytical chemist.

Time to summarize:

correct equation (point 0 , 0 included):

Y = 87 757 294 X + 61 347

correlation coefficient r = 0.9995 (BTW - residuals plot is acceptable)

concentration 0.0133 mg/L corresponds to peak area 1 227 456

I do hope it is not a concentration of API.

Re: Need some help my job depends on it..calibration curve e

lmh wrote:
Hope your problem is solved by now. If at all possible, you should consider using instrument software rather than Excel to do the calibration. ..........

New post strongly associated with this advise is waiting for the answer.

viewtopic.php?f=4&t=20370&start=0

Re: Need some help my job depends on it..calibration curve e

dblux_ wrote:
michaelbarnes42 wrote:
Well, if you haven't figured out what you did wrong, you had the axes incorrect. The equation you have X = Concentration and Y = Area

The correct equation is

Y = 1.13827E-08X - 0.00066

which gives the result of 0.013308371

Are you kidding ?

Your equation is completely wrong (provided Y is peak area and X is concentration) - it gives peak area lower then zero for concentration 0.0133.

I am 100% not kidding, the equation he had has X = Concentration and Y = Area

He was unfortunatly putting Area in for X, which was giving him the incorrect answer.

The equation I gave was the one he should be using if he wanted to use X for area and Y for concentration.

Re: Need some help my job depends on it..calibration curve e

michaelbarnes42 wrote:
I am 100% not kidding, the equation he had has X = Concentration and Y = Area

Correct. This form of equation is accepted by majority of analysts.
Y=bX + a where X is concentration

He was unfortunatly putting Area in for X, which was giving him the incorrect answer.

As JGK explained, he raised "e" (Euler's constant) to the power of 7 instead raising 10 to the power of 7.

Who is online

In total there are 21 users online :: 0 registered, 0 hidden and 21 guests (based on users active over the past 5 minutes)
Most users ever online was 599 on Tue Sep 18, 2018 9:27 am

Users browsing this forum: No registered users and 21 guests

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.