ERIC Number: EJ781048
Record Type: Journal
Publication Date: 2008-Jan
Pages: 12
Abstractor: Author
ISBN: N/A
ISSN: ISSN-0020-739X
EISSN: N/A
Linear System of Equations, Matrix Inversion, and Linear Programming Using MS Excel
El-Gebeily, M.; Yushau, B.
International Journal of Mathematical Education in Science and Technology, v39 n1 p83-94 Jan 2008
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.)
Descriptors: Mathematical Applications, Matrices, Spreadsheets, Computer Uses in Education, Problem Solving, Mathematics Instruction, Teaching Methods, Worksheets, Graphs, Equations (Mathematics), Secondary School Mathematics, College Mathematics
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
Publication Type: Journal Articles; Reports - Descriptive
Education Level: High Schools; Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A