A
AL
I'm trying to figure this out for school and am trying to avoid using the
Solver tool.
Solver tool.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
In Help search for <matrix>
Why would you even think of Solver for this?
Please tell us what mark we get for your homework.
Why would you even think of Solver for this?
Please tell us what mark we get for your homework.
C
Chip Pearson
Doesn't the matrix need to be square?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
A
AL
I'm supposed to use the Newton-Raphson Method to solve a thermodynamics
problem. It involves using a Taylor-series expansion to establish a set of
simultaneous equations, in this cae 3 equations with 7 unknowns. The
coefficients are then set up as a matrix and I need to find its determinant.
problem. It involves using a Taylor-series expansion to establish a set of
simultaneous equations, in this cae 3 equations with 7 unknowns. The
coefficients are then set up as a matrix and I need to find its determinant.
A
AL
All my searches within the help database pointed me towards Solver.
B
Bernard Liengme
You are confusing two things.
A) You can do the N-R method by hand, or with simple calculator. You can use
Excel do all this step by step just as if you were doing it by hand
B) You can set up a model and have Solver find the answer. Solver does all
the hard work including the matrix stuff.
If your chem prof (I was one myself until 3 months ago) is asking you do
solve thermodynamics by A, he/she is a dodo. Does he ask you to use the N-R
method to find square roots?
If she/he is a math prof then you should learn the step by step method. See
Help fro MDERTM, MINVERSE, MMULT
(Then use Solver to check your math!)
Send me private email and I will send you a PDF file on using the matrix
functions to solve systems of equations (aka simultaneous equations)
A) You can do the N-R method by hand, or with simple calculator. You can use
Excel do all this step by step just as if you were doing it by hand
B) You can set up a model and have Solver find the answer. Solver does all
the hard work including the matrix stuff.
If your chem prof (I was one myself until 3 months ago) is asking you do
solve thermodynamics by A, he/she is a dodo. Does he ask you to use the N-R
method to find square roots?
If she/he is a math prof then you should learn the step by step method. See
Help fro MDERTM, MINVERSE, MMULT
(Then use Solver to check your math!)
Send me private email and I will send you a PDF file on using the matrix
functions to solve systems of equations (aka simultaneous equations)
J
Jerry W. Lewis
3 equations are not enough to uniquely determine 7 unknowns. If there
are other known relationships among the unknowns that make this a
determined system, then you need to expand the system of equations to
also include those relationships.
There may be an abstract algebra concept of determinant that would apply
to non-square matrices, but in the usual linear algebra framework,
determinants are for square matrices
http://mathworld.wolfram.com/Determinant.html
Excel's MDETERM function will return #VALUE! if the matrix is not square
(as documented in Help)
Jerry
are other known relationships among the unknowns that make this a
determined system, then you need to expand the system of equations to
also include those relationships.
There may be an abstract algebra concept of determinant that would apply
to non-square matrices, but in the usual linear algebra framework,
determinants are for square matrices
http://mathworld.wolfram.com/Determinant.html
Excel's MDETERM function will return #VALUE! if the matrix is not square
(as documented in Help)
Jerry