Description:

Derivative for data samples at point t with smoothing.

Excel Function Syntax:

DataDifferentiate(xValues, yValues, t, l)

Online Calculator:

Parameter Value Description
xValues Sample points (N), sorted ascending.
yValues Samples values (N) of each segment starting at the corresponding sample point.
t Point t to interpolate at.
l Minimum distance between abscissa of the points and that of point t. l=0 (no smoothing).
Result

All functions from Utilities category

# Function Description
1 UnitConverter Converts a number from one measurement system to another.
2 SG2API Converts a oil specific gravity to API gravity
3 API2SG Converts a API gravity to oil specific gravity (water=1.0)
4 DataDifferentiate Derivative for data samples at point t with smoothing.
5 ExpIntegralEi The exponential integral function - Ei(x)
6 ProximalInterpolate Proximal (Nearest-neighbor) Interpolation Algorithm. Interpolate at point t.
7 CubicSplineInterpolate A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Interpolate at point t.
8 CubicSplineDifferentiate A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Differentiate at point t.
9 CubicSplineIntegrate A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Integrate up to point t.
10 CubicSplineIntegrateT1T2 A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Integrate from point t1 up to point t2.
11 CubicSplinesIntersection x value of intersection point between two cubic splines.
12 LinearSplineInterpolate Linear Spline Interpolation Algorithm. Interpolate at point t.
13 LinearSplineDifferentiate Linear Spline Interpolation Algorithm. Differentiate at point t.
14 LinearSplineIntegrate Linear Spline Interpolation Algorithm. Integrate up to point t.
15 LinearSplineIntegrateT1T2 Linear Spline Interpolation Algorithm. Integrate from point t1 up to point t2.
16 LinearSplinesIntersection x value of intersection point between two linear splines.
17 StepInterpolate Step Interpolation Algorithm. Interpolate at point t.