Computing Numerical Derivatives in Excel

Compute numerical derivative of a function

Use DERIVF to compute first and higher order derivatives of a function f(x) at x=p using highly accurate adaptive algorithm.

Compute numerical derivative from discrete data points

Use DERIVXY to compute a numerical derivative at a point within a discrete set of (x,y) data points using cubic splines.

Compute partial derivatives

You can nest DERIVF to compute partial derivatives of any order.

Video Illustrations

How to compute accurate numerical derivatives with DERIVF()

Description

This video demonstrates how to use the function DERIVF to compute first and higher order derivatives of any function in both Excel and Google Sheets. The video also demonstrates how to nest DERIVF to compute mixed and partial derivatives of any order

How to differentiate an (x,y) graph with DERIVXY()

Description

This video demonstrates how to use the function DERIVXY to compute first and higher order derivatives of a graph generated from discrete (x,y) data set points in both Excel and Google Sheets.
Question or Comment? Email us:
support @ excel-works.com

ExceLab: Transforming Excel into a Calculus Power House

ExceLab functions and methods are protected by USA Patents 10628634, 10114812, 9892108 and 9286286.

Share
© 2015-2025, ExcelWorks LLC
Massachusetts, USA