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

You are correct davesexcel:

This quadratic has two separate solutions:
one around .0576 and the other around 31.82548752

=(-2.8089+(2.8089^2-4*(-0.0881)*(-0.1615))^0.5)/(2*(-0.0881))
=(-2.8089- (2.8089^2-4*(-0.0881)*(-0.1615))^0.5)/(2*(-0.0881))

--
Gary's Student


"davesexcel" wrote:


0.057672821
y= -0.0881x^2+2.8089x+0.0505.

If the absorbance reading (y) = 0.212, how do I calculate the value of
x?
I am just thinking
A1=B2
B2=-.0881*C1^2+2.8089*C1+.0505
then I went to Tools, Goal seek
set the value of A1 to .212 by changing Cell C1


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519106