Thread: Matrix Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff
 
Posts: n/a
Default Matrix Problem

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.