Numerical differentiations spreadsheet calculator
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...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Published: |
2013
|
| Subjects: | |
| Online Access: | http://eprints.uthm.edu.my/4523/ http://eprints.uthm.edu.my/4523/1/NUMERICAL_DIFFERENTIATIONS_SPREADSHEET.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Summary: | 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. |
|---|