Solving non linear systems by Newton's method using spreadsheet excel
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 us...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Subjects: | |
| Online Access: | http://eprints.uthm.edu.my/1908/ http://eprints.uthm.edu.my/1908/1/SOLVING_NON_LINEAR_SYSTEMS_TAY_KIM_GAIK_2009.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Summary: | 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. |
|---|