G
Guest
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?
Alan Beban said: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.
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?
Harlan said: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-PenroseMatrixInverse.html
Harlan said: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-PenroseMatrixInverse.html
...You outdo yourself. It's amazing, and amusing, the lengths to which
you'll go to take exception to anything I post.
A matrix inverse is defined such that if B is the inverse of A, then
AB = BA = I, the identity matrix or unit matrix. ...
Now, which part of that suggests that I don't know what I'm talking
about without a degree in some particular field, and which is
contradicted by any material at the link you provided?
Alan said:Harlan Grove wrote: ....
....
A matrix inverse is defined such that if B is the inverse of A, then
AB = BA = I, the identity matrix or unit matrix.
A matrix has an inverse if and only if it is nonsingular.
A nonsingular matrix is always a square matrix whose rank is equal to
its order and whose determinant, therefore, is not zero.
Alan Beban said:I understand how an inverse is defined. How is a right inverse defined?
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.