• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

How to solve equation by computer?

Hemant Rupani

Senior Member
Hi there,
I want to solve f(x)=0.9*exp(2000*x)+0.1*exp(15000*x)-5290*x-1 equation, by any computer package. I tried Excel Goal-Seek analysis, but it is not good for value near zero. so how can I solve this equation on my PC? what software I should use? and what are the steps to do?
Thanks!
Regards,

PS:- one root is zero , I want another root.
 
I thnk x=0 is the only solution.

f(x) = exp(c*x) only has one root.

The same goes for f(x) = exp(c*x) + exp(k*x).

Including the 5290*x term doesn't change the number of roots, as it only affects the curve along the vertical plane, as does the -1 term.

So by my reckoning there is only one solution, which is x=0. It's been a while since I've had to think about these equations though!
 
second solution is between 0.000094 and 0.0000945
f(0.000094)=-0.0015 and f(0.0000945)=0.000011
Source:- Q3.9 QA Bank 3 CT6
 
In excel->options->formula you can change maximum iterations and maximum change.
an easier solution is also to reformulate the problem so the solution is scaled up, and then goal seek e.g.
=0.9*EXP(2000*x/1e9)+0.1*EXP(15000*x/1e9)-5290*x/1e9-1
 
Back
Top