No Detail Found!

Higher Order Runge-Kutta Method for Solving System of Ordinary Diferen- tial Equations Using MS Excel

Author(s)
Abdul Ghafoor Shaikh Department of Basic Sciences & Related Studies, QUEST, Nawabshah, Pakistan
Muhammad Usman Keerio Department of Electrical Engineering,QUEST, Nawabshah,Pakistan
Wajid Ali Shaikh Department of Mathematics, QUEST, Nawabshah, Pakistan
Lubna Naz Department of Natural Sciences, Begum Nusrat Bhutto Women University,Sukkur,Pakistan
Abstract
The real world problems are often hard to understand when data is scattered or not logically organized in a way that is conducive for us. These problems are obtained from physical and scientific phenomena and are modelled in terms of diferential equations. The diferential equations, solved numerically, are often implemented on simulation and computational tools. This requires programming skills. Excel spreadsheet has been used frequently for statistical analysis, however, it is rarely used for computation in mathematics, instead of having great usability and usefulness. It also easily enables a non-programmer to perform programming-like tasks in a visual tabular pen and paper approach. Many physical phenomena are modelled in terms of odes and PDEs, therefore, solving these equations, by cooperative iterative methods, is very important. There are several iterative methods, among which Euler and Runge-Kutta are the most famous ones for solving the diferential equations as well as system(s) of the diferential equation(s). Euler's method has slow convergence; therefore, methods of a higher order of accuracy are often needed. Since the iterative methods manually with pen-paper are quite tedious and laboring because it involves numerous repetitive calculations. In this paper, the Excel spreadsheet is applied to solve the system of ordinary diferential equations by applying the RK5 methods. It is demonstrated that the Excel spreadsheet method is faster and the solutions can be visualized by small or large alterations in the variables.
Publication Details
Page(s) 36-41
Published Journal: Quaid-e-Awam University Research Journal of Engineering, Science and Technology, Volume: 19, Issue: 2, Year: 2021

Request the full text from PASTIC

Keywords
Diferential equation, Runge Kutta method, Excel spreadsheet, Euler method
0

Citations

0

Downloads

54

Views