Excel Function

Description:

Derivative for data samples at point t with smoothing.

Excel Function Syntax:

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

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.

An unhandled error has occurred. Reload 🗙