Author(s):
1. Atteeq Razzak:
Department of Mathematics, University of Karachi,Karachi,Pakistan
2. Muhammad Hani Zaheer:
Department of Physics, University of Karachi,Karachi,Pakistan
3. Muhammad Bilal Khan:
Department of Physics, University of Karachi,Karachi,Pakistan
4. Zaheer Uddin:
Department of Physics, University of Karachi,Karachi,Pakistan
Abstract:
Root finding Methods like the Bisection Method, Newton Raphson Method, Secant Method, and False Position Method have been revisited through a new approach. EACH METHOD'S user-friendly GUI computer programs have been developed on an Excel spreadsheet. A root locator graph is introduced in the spreadsheets, which helps identify the initial guess(es) required to calculate root using these methods. All real roots are now easily calculable by any of the four methods. The detailed steps to calculate roots are also shown on the spreadsheet. The spreadsheet can be made ready for the next calculation with a single click. We have developed a technique for Excel that helps accept polynomial in variable 'x' without directly mentioning cell location.
Page(s):
37-43
DOI:
DOI not available
Published:
Journal: Proceedings of the Pakistan Academy of Sciences: A. Physical and Computational Sciences, Volume: 59, Issue: 1, Year: 2022
Keywords:
Secant method
,
Teaching Mathematics
,
Bisection Method
,
False Position Method
,
NewtonRaphson Method
,
Root Finding Methods
,
Spreadsheets
,
Microsoft Excel
References:
References are not available for this document.
Citations
Citations are not available for this document.