+ Reply to Thread
Results 1 to 2 of 2

Matrix Elimination and Substitution?!

  1. #1
    dziw
    Guest

    Matrix Elimination and Substitution?!

    I have a numerical method problem which results in a matrix of values, i.e. a 4x4 matrix multiplied by a 4x1 matrix equals a 4x1 matrix. Some of the values in the matrix are already zero but in order to solve it elementary row operations are required to make the matrix a diagonal matrix which can be solved by back substitution. Is this process of elimination and subsititution possible in excel and if so how?

    Thanks in advance

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Take a look at the function Substitute() or take a look at matrix operations with Excel ...
    http://www.stanford.edu/~wfsharpe/mi...htm#operations
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1