Using Microsoft Excel in Solving 2 or 3 Unknown Variables Using Matrices in Row Echelon Form

My daughter was working on some match assignment solving algebraic equations but instead of doing the usual transposition stuff, she was solving it in a matrix setting them up in row Echelon form. Something even I needed to review a bit to refresh my memory how it is done.

She then asked me if Excel can solve this to double check. And I said yes and no. There is no automatic way to show the row Echelon form of the matrix but I can certainly make some way to display it. So challenge accepted.

If you need to review yourself on the row Echelon form, I found this video to be useful.

If you need an MS Excel file that can solve 2 or 3 equations with 2 or 3 unknown variables respectively in matrices using the row Echelon form and needs to see the complete solution, you can try this file I’ve created. If you find this useful, you are free to use an distribute as long as you mention it was made by me, and link back to this page. Enjoy! Download it here: Row-Echelon-Form

 

About Author:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.