Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solution for nonlinear set of equations
I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER be
used to solve for the unknowns? Any help is appreciated. I have never used SOLVER before. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solution for nonlinear set of equations
Hi Peter,
Maybe one of these may help. http://j-walk.com/ss///excel/tips/tip101.htm HTH Martin "Peter M" wrote in message ... I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER be used to solve for the unknowns? Any help is appreciated. I have never used SOLVER before. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solution for nonlinear set of equations
Hi Martin-
Thanks for your reply. Not sure if this would help though. Wgat I need is a solution to system of 3 simultaneous nonlinear equations. Peter "MartinW" wrote: Hi Peter, Maybe one of these may help. http://j-walk.com/ss///excel/tips/tip101.htm HTH Martin "Peter M" wrote in message ... I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER be used to solve for the unknowns? Any help is appreciated. I have never used SOLVER before. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solution for nonlinear set of equations
If you are trying to determine the coefficients for a polynomial fit, then
the equations are linear in the unknown coefficients. Those polynomial coefficients are easily calcualted by LINEST, as illustrated in MartinW's link. Perhaps you would find http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm easier to follow? If you are trying to solve equations that are actually nonlinear in the unknowns, then you sould say more about what those equations are. Jerry "Peter M" wrote: Hi Martin- Thanks for your reply. Not sure if this would help though. Wgat I need is a solution to system of 3 simultaneous nonlinear equations. Peter "MartinW" wrote: Hi Peter, Maybe one of these may help. http://j-walk.com/ss///excel/tips/tip101.htm HTH Martin "Peter M" wrote in message ... I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER be used to solve for the unknowns? Any help is appreciated. I have never used SOLVER before. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NonLinear R-squared (R2) | Excel Worksheet Functions | |||
Nonlinear R-squared (R2) | Excel Worksheet Functions | |||
Solve nonlinear systems of equations? | Excel Discussion (Misc queries) | |||
nonlinear regression | Excel Discussion (Misc queries) | |||
Nonlinear regression | Excel Worksheet Functions |