Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
curve fit equation | Excel Discussion (Misc queries) | |||
can I find the area under a plotted curve? | Excel Worksheet Functions | |||
equation of a curve | New Users to Excel | |||
How To Fit An Equation To A Curve | Excel Discussion (Misc queries) | |||
How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION? | Excel Worksheet Functions |