Solver

R

Richard4926

Hi!

I'm working with excel 2003. I'd like to know details about the algorithm
excel uses to solve a system of equations with for examlpe 10 unknowns.
Where can I find these information?
 
B

Bernard Liengme

In any text book on numerical analysis you will find stuff on solving
equations by iterative methods.
But to solve a system of equations (simultaneous equations) the best way is
with the matrix function MINVERSE and MMULT
best wishes
 
A

Alex Turner

Hi!

I'm working with excel 2003. I'd like to know details about the
algorithm excel uses to solve a system of equations with for examlpe 10
unknowns. Where can I find these information?
Click to expand...

Specifically, the solver uses a form of the simplex function. This is
not a bad choice because it tends to be very stable and therefore general
purpose. However, its performance (steps to completion within chosen
criteria) is really really bad compared to conjugate gradients or newton
raphson.
 
B

Bernard Liengme

Are you sure it uses the simplex method when solving a system of equation?
best wishes
 
Top