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


Matrix A =

1 1 1 1 0 0 0 0
1000 100 10 1 0 0 0 0
0 0 0 0 1000 100 10 1
0 0 0 0 4096 256 16 1
3 2 1 0 0 0 0 0
300 20 1 0 -300 -20 -1 0
0 0 0 0 768 32 1 0
60 2 0 0 -60 -2 0 0

Matrix B = 0.11413125 0.30555 0.30555 0.425 0.0085625 0 0.019908333 0

Matrix C =
-0.000135571 0.003038657 0.002891898 0.108336265 8.5706E-05 -0.003599653 0.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

"Jeff" wrote:

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


Matrix A =

1 1 1 1 0 0 0 0
1000 100 10 1 0 0 0 0
0 0 0 0 1000 100 10 1
0 0 0 0 4096 256 16 1
3 2 1 0 0 0 0 0
300 20 1 0 -300 -20 -1 0
0 0 0 0 768 32 1 0
60 2 0 0 -60 -2 0 0

Matrix B = 0.11413125 0.30555 0.30555 0.425 0.0085625 0 0.019908333 0

Matrix C =
-0.000135571 0.003038657 0.002891898 0.108336265 8.5706E-05 -0.003599653 0.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.