DERIVATIVE

The numerical values to compute the derivative of. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

divisor

A value to divide each value in data by. This can be a constant value or an expression evaluating to a constant.

Description

DERIVATIVE calculates the derivative of the values in a time-series. Each value is the difference between the current value and the value from the next time-step. If a value is provided for divisor, each value is divided by the specified value. DERIVATIVE returns one new column for each input column, each containing derivative of the values in the corresponding input column.

The length of the returned column will be one less than the length of the source data column (data).

Examples

TEMP = DERIVATIVE(5)

Creates a new column named TEMP containing all blank cells (at least two cell values are required to generate a result).

TEMP = DERIVATIVE(COLUMN(1, 2, 5))

Creates a new column named TEMP, containing the values 1 and 3.

TEMP = DERIVATIVE(V1)

Creates a new column named TEMP, where each value is the derivative of the contents of column V1.

TEMP = DERIVATIVE(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the derivatives of the contents of column V1, the values of the VX column are the derivatives of the contents of column V2, and the values of the VY column are the derivatives of the contents of column V3.

TEMP = DERIVATIVE(V1[10:20])

Creates a new column named TEMP, where the cells in rows 10-20 contain the derivatives of the corresponding rows of column V1. The other cells in TEMP are empty.

TEMP = DERIVATIVE(V1[1:5]:V2)

Creates two new columns named TEMP and VX, each with values in rows 1-5 (the other cells are empty). The values in column TEMP are the derivatives of the corresponding rows of column V1, and the values in column VX are the derivatives of the corresponding rows of column V2.

Related Functions

Function	Description
INTEGRAL	Computes the integral of the values in the specified data range