Re: non-zero solution

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm afraid this brute force approach doesn't work here. If you increase the precision even more, you just get closer and closer to zero as a solution, until you reach Excel's precision limits.
I didn't find any start vales that worked better.
I'm afraid a more subtile approach (if there is any) is necessary.

Harlan?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message news:F12C50B9-E7A0-456C-8771-B92326679DC6@xxxxxxxxxxxxxxxx
<If you need more precision>

Indeed you do. I was way off in my first attempt (slightly different from yours).
Changing the precision had a vast impact on the outcome.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Mike Middleton" <mike@xxxxxxxxxxxxxxxxx> wrote in message news:%23evNNVsPJHA.4864@xxxxxxxxxxxxxxxxxxxxxxx
A.A.A -

Here's one way.

Let A1 contain values of t, and initially enter 1 (or your choice of starting value) in A1.

Let A2 contain the left side: =0.6*EXP(A1*1.0986)-0.6

Let A3 contain the right side: =0.99994572*A1

Let A4 contain the difference, which you want to be zero: =A2-A3

Choose Tools | Goal Seek (in Excel 2007, Data | What-If Analysis | Goal Seek), and set cell A4 to value 0 (zero) by changing cell A1.

If you need more precision, choose Tools | Calculation, and specify a smaller "Maximum change." (In Excel 2007, choose Office Button | Excel Options | Formulas | Maximum Change.)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"A.A.A" <ayafeps@xxxxxxxxx> wrote in message news:31225ca8-8c81-4f18-b1db-1dc51a993c8b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I do not know whether i can use excel in this or not. but I am trying
to find the non-zero solution to the following equation:

0.6*exp(t*1.0986)-0.6=0.99994572*t

but i always get a zero solution. How could i obtain the non-zero
solution?I know that there is a non zero value of t satisfying the
previous equation.
Plz help,
A.A.A




.

Relevant Pages

  • Re: non-zero solution
    ... Kind regards, ... Microsoft MVP - Excel ... the precision even more, you just get closer and closer to zero as a solution, until you reach Excel's precision limits. ...
    (microsoft.public.excel)
  • Re: is 0.000000000000000055511151231258=0 in excell?
    ... Microsoft Excel MVP ... And it is different from "precision" of the internal representation of any ... zero when subtracted" are sometimes two different thingsin Excel. ...
    (microsoft.public.excel.misc)
  • Re: non-zero solution
    ... Changing the precision had a vast impact on the outcome. ... Decision Analysis Add-ins for Excel ... to find the non-zero solution to the following equation: ... but i always get a zero solution. ...
    (microsoft.public.excel)
  • Re: is 0.000000000000000055511151231258=0 in excell?
    ... And it is different from "precision" of the internal representation of any number, which can have as many as 1074 decimal places. ... "considered equal" and "resulting in zero when subtracted" are sometimes two different thingsin Excel. ... My point is: the use of --TEXTdoes exactly what I would want, namely: it ensures that the internal representation of the actual result exactly matches the internal representation of the displayed result if we enter it as a constant or the equivalent using TIME. ...
    (microsoft.public.excel.misc)
  • Re: calculation accuracy
    ... in fortran is quite a bit different than what I get in excel. ... DOUBLE PRECISION PI_D ... and is padded with zeros on conversion ... a lot closer to zero if P_D was closer to pi. ...
    (comp.lang.fortran)