View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David C David C is offline
external usenet poster
 
Posts: 12
Default Matrix Inversion by Gaussian Reduction

Excel Minverse function has truncation errors, and I would like to use
Gaussian Reduction to solve my eqn ( A.X = Y ) without using matrix
inversion.
I understand the theory and the maths - has anyone done this in MSExcel, or
has any ideas how I might do this?

[Basically, it involves Mmult with a triangular matrix to reduce terms below
the diagonal to zeros, until you then solve 'by inspection' from the bottom
up. Triangle matrix is similar to the identity matrix, but with one key
value replacing one of the zeros]