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.
|