View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jessica[_4_] Jessica[_4_] is offline
external usenet poster
 
Posts: 2
Default Find Max of Curve Equation

You can use bisection method to approximate the root of
the equation. It is easy to use excel to do.


-----Original Message-----
I have scoured the newsgroups and web and can't seem to

find an anwser
to this.

I need to find the max of an equation. where the

equation is in this
form 1/(1-e^(z1-x))*(1-1/(1+e^(z2-x))*.........*(1-1/

(1+e^(zn-x)).

Where there are n number of z values that are know.

Meaning that z is
not a variable but different constants.

I can calculate the slope at a specific value of x but

want to solve
for x where F'(x) = 0.

Any help?

Thanks,
John
.