View Single Post
  #8  
Old July 29th, 2004, 08:08 PM
Dana DeLouis
external usenet poster
 
Posts: n/a
Default Finding roots of non-linear equations in Excel

Oh. Never mind. You meant the equation as you gave as that would give 1.64
as one solution.

tan(0.155x)-(0.42x)/(x^2-0.0438)=0


Be aware that the solution you see of about 10.4 I believe is not correct.
What you most likely see on a plot is a jump from +Infinity to - Infinity.

Dana

tan ( (0.155x-0.42x) / (x^2-0.0438) ) = 0



I should re-write the function slightly as follows:

tan(0.155x)-(0.42x)/(x^2-0.0438)=0

I am trying to determine positive values of x where the left hand side

is
zero. The number 0 satisfies the equation, but there are other roots at
1.64, 10.4, 20.4, 30.5, etc.