UTHM Institutional Repository

Numerical differentiations spreadsheet calculator

Tay , Kim Gaik and Sie-Long, Kek and Abdul Kahar, Rosmila (2013) Numerical differentiations spreadsheet calculator. In: Prosiding Seminar Kebangsaan Aplikasi Sains dan Matematik 2013 (SKASM 2013) , 29-30 Oktober 2013, Batu Pahat, Johor .


Download (310kB)


In this paper, we have developed a spreadsheet calculator for numerical differentiations. In this spreadsheet calculator, users may select either a given function or a given data to approximate the numerical differentiation. For a given function option, users are only required to key in the value of x, the functionflx) and the step size h. The spreadsheet calculator will then tabulate the (x, Ax)) data into a given table. On the other hand, for a given data option, users only have to key in the (x, y) data into the given table. For both options, the first derivative at the specified value of x will be approximated by using 2- point forward, 2-point backward, 3-point central, 3-point forward, 3-point backward and 5-point formulas, whereas the second derivative at the specified value of x will be calculated by using 3-point central and 5-point formulas. With this numerical differentiations spreadsheet calculator, we hope to help educators to prepare their marking scheme easily and to assist students in checking their answers.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: numerical differentiation; 2-point forward; 2-point backward; 3-point central; 3-point forward; 3-point backward and 5-point formulas
Subjects: T Technology > TA Engineering (General). Civil engineering (General) > TA329-348 Engineering mathematics. Engineering analysis
Divisions: Faculty of Applied Science and Technology > Department of Science and Mathematics
Depositing User: Normajihan Abd. Rahman
Date Deposited: 19 Nov 2013 03:45
Last Modified: 21 Jan 2015 07:29
URI: http://eprints.uthm.edu.my/id/eprint/4523
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item


Downloads per month over past year