UTHM Institutional Repository

Solving non linear systems by Newton's method using spreadsheet excel

Tay , Kim Gaik and Kek, Sie Long and Abdul Kahar, Rosmila Solving non linear systems by Newton's method using spreadsheet excel. In: 3 R D Internationalconference on Science and Mathematics Education, 10-12 November 2009, Penang.

[img] PDF

Download (475kB)


Tay (2006) had proposed solving numerical methods using the Casio fx-570MS calculator to overcome the tediousness of doing recursive calculations. Here, we present another alternative, that is solving a non-linear system using Newton's method in Microsoft Office Excel. For this, we just make use of the MULT function to do matrix multiplication and MINVERSE function to do the matrix inverse operation. The concept presented here can be developed into a solver where the user just needs to input the initial vector X, the corresponding formula of Jacobian matrix J(x, y) and non-linear system vector F(x, y) The full solutions will be displayed automatically. The solver is easy and user friendly for students and educator who needs its full solutions quickly.

Item Type: Conference or Workshop Item (Paper)
Subjects: Q Science > QA Mathematics > QA273 Probabilities. Mathematical statistics
Divisions: Faculty of Applied Science and Technology > Department of Science and Mathematics
Depositing User: Ahmad Faisal Ishak
Date Deposited: 05 Oct 2011 01:25
Last Modified: 05 Oct 2011 01:25
URI: http://eprints.uthm.edu.my/id/eprint/1908
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item


Downloads per month over past year