Excel Function
DataDifferentiate
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 |
Related Functions
12 items
CubicSplineDifferentiate
A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Differentiate at point t.
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.
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.
CubicSplineInterpolate
A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Interpolate at point t.
CubicSplinesIntersection
x value of intersection point between two cubic splines.
LinearSplineDifferentiate
Linear Spline Interpolation Algorithm. Differentiate at point t.
LinearSplineIntegrate
Linear Spline Interpolation Algorithm. Integrate up to point t.
LinearSplineIntegrateT1T2
Linear Spline Interpolation Algorithm. Integrate from point t1 up to point t2.
LinearSplineInterpolate
Linear Spline Interpolation Algorithm. Interpolate at point t.
LinearSplinesIntersection
x value of intersection point between two linear splines.
ProximalInterpolate
Proximal (Nearest-neighbor) Interpolation Algorithm. Interpolate at point t.
StepInterpolate
Step Interpolation Algorithm. Interpolate at point t.