Thread: Matrix inverse
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Robert McCurdy Robert McCurdy is offline
external usenet poster
 
Posts: 102
Default Matrix inverse

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