Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yo, you give those with degrees far too much credit.
If you don't have a degree in a particular field, there's an outside chance you don't know what you're talking about. But to 'invert the above point of view Harlan; I wouldn't suggest those with degrees always know what they are talking about? Regards Robert "Harlan Grove" wrote in message ... "Alan Beban" wrote... Unless you mean something odd by "invert matrix", there is no such concept. Mathematically, the inverse of a matrix does not exist for non-square matrices. If you don't have a degree in a particular field, there's an outside chance you don't know what you're talking about. http://mathworld.wolfram.com/Moore-P...ixInverse.html Chee Beng wrote: MInverse function can return answer if array has an equal number of rows and columns. Is there a known trick (any function or VBA) to invert matrix which does not has an equal number of rows and columns? Do you mean a Moore-Penrose pseudoinverse? If so, follow the link above, and see formula (7). Otherwise, follow this link. http://mathworld.wolfram.com/Pseudoinverse.html It's possibe Octave (the GNU Project's rough work-alike for MatLab) includes source code for generalized matrix inverses. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.590 / Virus Database: 373 - Release Date: 17/02/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating a generalized inverse matrix | Excel Discussion (Misc queries) | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
Matrix Inverse | Excel Worksheet Functions | |||
How to compute the inverse of a matrix with some complex elements | Excel Worksheet Functions | |||
Inverse sin | Excel Worksheet Functions |