View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default polynomial equation

Just solve the quadratic equation:

0= -0.0881x^2+2.8089x-0.1615

x=31.82549

see:

http://mathworld.wolfram.com/QuadraticEquation.html
--
Gary''s Student


"PAUL GRAZIDE" wrote:

I am setting up a calibration curve, where x= concentration and y=
absorbance. The curve is polynomial.

after plotting x and y values using a scattergraph and applying a trend
line, i got the following regression line:
y= -0.0881x^2+2.8089x+0.0505.

If the absorbance reading (y) = 0.212, how do I calculate the value of x?

Thanks in advance