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 .

[img]
Preview
PDF
303Kb

Abstract

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 Science, Technology and Human Development > Department of Science and Mathematics
ID Code:4523
Deposited By:Normajihan Abd. Rahman
Deposited On:19 Nov 2013 11:45
Last Modified:21 Jan 2015 15:29

Repository Staff Only: item control page