Linear Algebra in Excel
Linear Algebra in Excel
(OP)
Generally, I use MathCAD when linear algebra is involved, but the Help files for Excel make it sound like Excel has this capability, too - but don't provide enough information to really figure it out.
Would somebody mind showing me an example? sparweb@hotmail.com
Thanks in advance, for any help you can provide.
Would somebody mind showing me an example? sparweb@hotmail.com
Thanks in advance, for any help you can provide.
Steven Fahey, CET
"Simplicate, and add more lightness" - Bill Stout





RE: Linear Algebra in Excel
M777182
RE: Linear Algebra in Excel
http://digilander.libero.it/foxes/
RE: Linear Algebra in Excel
They're pretty simple to run, and pretty handy to have.
--Steve
RE: Linear Algebra in Excel
~Tech
RE: Linear Algebra in Excel
Excel has a very nice capability to handle matricies. I use the spreadsheet approach to solve rotational matricies for use in astrodynamic applications. Once you generate your polynomial, try applying other Excel features.
Kenneth J Hueston, PEng
Principal
Sturni-Hueston Engineering Inc
Edmonton, Alberta Canada
RE: Linear Algebra in Excel
RE: Linear Algebra in Excel
As mentioned, Excel can directly multiply the matricies for you. My reference book isn't with me, but it goes something like defining and blocking a region of the spreadsheet representative of the matrix, then issuing in the command AXB, something like that. I will look it up and get back to you. Of course you need to make the adjustment for the eigenvalue problem itself.
Second, you would have much more flexibility in writing a background macro using VisualBasic, then coding various polynomial root convergence schemes used in numerical computations. Matrix multiplication is commonly found in computing textbooks, my preferred method is FORTRANMS since it is close to BASIC. You can find roots by closed form methods for polynomials under degree five, but must employee iterative schemes thereafter. Depending on the nature of your problem, this may not be an issue.
I saw a method complete with example, laid out in a C++ textbook reference. Despite the program language, the methodology is what you are after. I will provide that reference also.
Kenneth J Hueston, PEng
Principal
Sturni-Hueston Engineering Inc
Edmonton, Alberta Canada