LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating a generalized inverse matrix Ying-Foon Chow Excel Discussion (Misc queries) 10 April 28th 11 11:41 AM
How can I transpose nXm matrix to mXn Matrix MIHir Excel Worksheet Functions 2 August 9th 08 11:44 AM
Matrix Inverse Rosina Excel Worksheet Functions 2 May 10th 07 08:49 AM
How to compute the inverse of a matrix with some complex elements Annoushka42 Excel Worksheet Functions 0 March 6th 06 12:08 AM
Inverse sin John Fitzpatrick Excel Worksheet Functions 3 March 25th 05 06:35 PM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"