The method used to perform this calculation in Excel is the finite difference method. To use the finite difference method in Excel, we calculate the change in “y” between two data points and divide by the change in “x” between those same data points:
Use Excel calculus function DERIVF to compute numerical derivative of a formula or VBA function using highly accurate adaptive algorithms.
Key words: derivative, numerical differentiation, partial derivative, higher order derivatives, DERIVF This video demonstrates how to use the function DERIVF () to compute first a...more