Linear System of Equations, Matrix Inversion, and Linear Programming Using MS Excel

Autor/inn/en	El-Gebeily, M.; Yushau, B.
Titel	Linear System of Equations, Matrix Inversion, and Linear Programming Using MS Excel
Quelle	In: International Journal of Mathematical Education in Science and Technology, 39 (2008) 1, S.83-94 (12 Seiten)Infoseite zur Zeitschrift PDF als Volltext Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	0020-739X
Schlagwörter	Mathematical Applications; Matrices; Spreadsheets; Computer Uses in Education; Problem Solving; Mathematics Instruction; Teaching Methods; Worksheets; Graphs; Equations (Mathematics); Secondary School Mathematics; College Mathematics + Suchen Sie Ihr Suchwort? Angewandte Mathematik; Innermathematische Anwendung; Matrizenrechnung; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Computernutzung; Problemlösen; Mathematics lessons; Mathematikunterricht; Teaching method; Lehrmethode; Unterrichtsmethode; Grafische Darstellung; Equations; Mathematics; Gleichungslehre
Abstract	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 x 2 system. It is our hope that both teachers and students will find the approaches useful for teaching and learning. (Contains 3 figures.) (Author).
Anmerkungen	Taylor & Francis, Ltd. 325 Chestnut Street Suite 800, Philadelphia, PA 19106. Tel: 800-354-1420; Fax: 215-625-2940; Web site: http://www.tandf.co.uk/journals/default.html
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2017/4/10