How to solve equation by computer?

Discussion in 'Off-topic' started by Hemant Rupani, Mar 24, 2015.

  1. Hemant Rupani

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

    maz1987 Member

    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!
     
  3. Hemant Rupani

    Hemant Rupani Senior Member

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

    tiger Ton up Member

    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
     
  5. Hemant Rupani

    Hemant Rupani Senior Member

    Thanks tiger
     
  6. C2H6O

    C2H6O Member

  7. Hemant Rupani

    Hemant Rupani Senior Member

    even better!!!!!:D
     
  8. didster

    didster Member

    looks like a candidate for excel challenge #3
     

Share This Page