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?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.