software

I was trying to match a matrix division, that was written in another code.Matrix A =

11110000
10001001010000
00001000100101
00004096256161
32100000
3002010-300-20-10
00007683210
60200-60-200

Matrix B = 0.114131250.305550.305550.4250.008562500.0199083330

Matrix C =
-0.0001355710.0030386570.0028918980.1083362658.5706E-05-0.0035996530.069275-0.112940741

The calculation that I am looking at has

Matrix B / Matrix A = Matrix C

I was trying to use a function in excel to match matrix C, but I have been
unable to do this.

Any help would be greatly appreciated.

With matrices, you don't divide, you multiply by an inverse.

Assuming that B is a row, as you have portrayed it, and that you want C as a
row, select the full output range, type the following formula (replacing A
and B with the appropriate ranges)

=TRANSPOSE(MMULT(MINVERSE(A),TRANSPOSE(B)))

and array enter it (Ctrl-Shift-Enter).

Jerry

quot;Jeffquot; wrote:

gt; I was trying to match a matrix division, that was written in another code.
gt;
gt;
gt; Matrix A =
gt;
gt; 11110000
gt; 10001001010000
gt; 00001000100101
gt; 00004096256161
gt; 32100000
gt; 3002010-300-20-10
gt; 00007683210
gt; 60200-60-200
gt;
gt; Matrix B = 0.114131250.305550.305550.4250.008562500.0199083330
gt;
gt; Matrix C =
gt; -0.0001355710.0030386570.0028918980.1083362658.5706E-05-0.0035996530.069275-0.112940741
gt;
gt; The calculation that I am looking at has
gt;
gt; Matrix B / Matrix A = Matrix C
gt;
gt; I was trying to use a function in excel to match matrix C, but I have been
gt; unable to do this.
gt;
gt; Any help would be greatly appreciated.