Root Finding Methods Through GUI in Spreadsheets

Atteeq Razzak; Muhammad Hani Zaheer; Muhammad Bilal Khan; Zaheer Uddin

No Detail Found!

Root Finding Methods Through GUI in Spreadsheets

Author(s)

Atteeq Razzak Department of Mathematics, University of Karachi,Karachi,Pakistan

Muhammad Hani Zaheer Department of Physics, University of Karachi,Karachi,Pakistan

Muhammad Bilal Khan Department of Physics, University of Karachi,Karachi,Pakistan

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.

Publication Details

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

Request the full text from PASTIC

Keywords

Secant method, Teaching Mathematics, Bisection Method, False Position Method, Newton-Raphson Method, Root Finding Methods, Spreadsheets, Microsoft Excel

Citations

Downloads

127

Views