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

 

Math/Logic Problem and Answer

Five employees at the Wild Fowl Publishing Company each come to work by a different one of five means: car, railroad, subway, and walking. They hold these positions at the company: art director, editor, publisher, receptionist, and secretary. Two of them are men named Finch and Marten, while three of them are women named Fulmer, Gannet, and Hawk. From the information given, determine the position held by each person as well as the means by which each one gets to work each day.

  1. Neither of the men walk to work but one is the art director and the other is not the publisher or secretary.
  2. The publisher is named Hawk or Fulmer and none of these takes the railroad or a car.
  3. Mr. Finch does not come by railroad and he is not editor.
  4. The female receptionist is not named Fulmer and neither of these two walks to work.
  5. The secretary does not take the bus to work.

Solution:

Math / Logic Problem

 

  • Mr. Finch is the Art Director and drives a Car.
  • Mr. Marten is the Editor and takes the Railroad.
  • Ms. Fulmer is the Secretary and takes the Subway.
  • Ms. Gannet is the Publisher and Walks to work.
  • Ms. Hawk is the Receptionist and takes the Bus.