Abstract
The traditional numerical computation of the first derivative f′(x) of a given function f (x) of a single argument x by central differencing is known to involve aspects of both accuracy and precision. By analysing both we arrive at an algorithm that closely approximates the most accurate answer obtainable by this method, typically with at least 9 accurate decimals, while preserving a minimal footprint. The results apply to software based on the IEEE-754 specification, and are illustrated with Excel.
Similar content being viewed by others
References
Levenberg K 1944 Quart. Appl. Math. 2 164
Marquardt D W 1963 SIAM J. Appl. Math. 11 431
Abadie J 1978 In Design and implementation of optimization software (ed.) H J Greenberg (Sijthoff & Noordhoff) pp 335–363
Lasdon L S and Waren A D 1978 In Design and implementation of optimization software (ed.) H J Greenberg (Sijthoff & Noordhoff) pp 363–397
Press W H, Teukolsky S A, Vetterling W T and Flannery B P 2007 Numerical recipes (Cambridge University Press) 3rd edn, pp 229–232
de Levie R 2008 Advanced Excel for scientific data analysis (Oxford University Press) 2nd edn
IEEE Standard for Binary Floating-Point Arithmetic, ANSI/IEEE Std 754-1985, reprinted in SIGPLAN Notices 22#2, 9–25 (1987), http://portalparts.acm.org/30000/24686/fm/frontmatter.pdf, accessed December 2008
Floating-point arithmetic may give inaccurate results in Excel, Microsoft’s Knowledge Base 78113 at http://support.microsoft.com/kb/78113/en-us, last reviewed 26 February 2007, accessed December 2008
Kahan W How futile are mindless assessments of roundoff in floating-point computation?, http://www.cs.berkeley.edu/~wkahan/Mindless.pdf, 11 January 2006, accessed December 2008
Rice J R 1983 Numerical methods, software, and analysis (McGraw-Hill) p. 186
The MacroBundle and xMacroBundle are freely downloadable from my website http://www.bowdoin.edu/~rdelevie/excellaneous. Volpi’s software packages BigMatrix and Xnumbers can also be downloaded from this website, as well as from his own website, ref. 12
Leonardo Volpi’s website is found at http://digilander.libero.it/foxes/Software Download.htm. A substantial extension of Xnumbers.xla called XN.xla (or, for Excel 2007, XN.xlam) has recently been released by John Beyers, and is downloadable from steve@thetropicalevents.com
Richardson L F 1910 Philos. Trans. Roy. Soc. London A210 307
Richardson L F 1927 Philos. Trans. Roy. Soc. London A226 299
Ridders C J F 1982 Adv. Engin. Software 4 75
Author information
Authors and Affiliations
Corresponding author
Additional information
Dedicated to the memory of the late Professor S K Rangarajan
Rights and permissions
About this article
Cite this article
de Levie, R. An improved numerical approximation for the first derivative. J Chem Sci 121, 935–950 (2009). https://doi.org/10.1007/s12039-009-0111-y
Published:
Issue Date:
DOI: https://doi.org/10.1007/s12039-009-0111-y