Linear system of equations, matrix inversion, and linear programming using MX Excel

• Autores: M. El-Gebeily, B. Yushau
• Localización: International journal of mathematical education in science and technology, ISSN 0020-739X, Vol. 39, Nº. 1, 2008, págs. 84-94
• Idioma: inglés
• DOI: 10.1080/00207390600741710
• Texto completo no disponible (Saber más ...)
• Resumen

  • In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we develop a worksheet method that is capable of solving and graphing a linear 2 × 2 system. It is our hope that both teachers and students will find the approaches useful for teaching and learning.In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we develop a worksheet method that is capable of solving and graphing a linear 2 × 2 system. It is our hope that both teachers and students will find the approaches useful for teaching and learning.In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we develop a worksheet method that is capable of solving and graphing a linear 2 × 2 system. It is our hope that both teachers and students will find the approaches useful for teaching and learning.In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we develop a worksheet method that is capable of solving and graphing a linear 2 × 2 system. It is our hope that both teachers and students will find the approaches useful for teaching and learning.