GAUSS_AREA

The cell range to compute the area under the Gaussian for. 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 mean, (same as the definition of data) see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

mean

The mean of the Gaussian. If this parameter is not provided, the default is zero. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. The number of columns in mean must equal the number of columns in data, unless mean is a constant or a single column. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

std

The standard deviation of the Gaussian. If this parameter is not provided, the default is one. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. The number of columns in std must equal the number of columns in data, unless std is a constant or a single column. For the format definition of std, (same as data), see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

GAUSS_AREA computes the area under the Gaussian (from

to the specified data value X) of the numbers in the specified data range (see the following figure). It returns one new column for each input column, each containing the area under the Gaussian of the corresponding input.

The mean and standard deviation parameters are treated as follows:

If no mean and standard deviation are provided, zero and one are used, respectively.

If mean and std are constants, these values are used to specify the Gaussian for all values in data.

If mean and std are single columns, the corresponding row values are used for each row of data.

If mean and std are column ranges (both must be the same number of columns as data), each cell in data uses its individual pair of corresponding cells in mean and std.

In the last case above, when mean and std are column ranges, the length of each column determines how many rows will be present in the corresponding output column. If a column of mean or std is a single cell, that value will be used for all row values of data. If mean or std contain multiple rows, the corresponding rows are calculated. Rows of data for which there are no corresponding values in mean and std are not computed.

Examples

TEMP = GAUSS_AREA(0) or TEMP = GAUSS_AREA(0, 0, 1)

Creates a new column named TEMP containing the value 0.5.

TEMP = GAUSS_AREA(V1)

Creates a new column named TEMP, where each value is the area under the Gaussian of the corresponding row of column V1, using a zero-mean, unit-variant Gaussian.

TEMP = GAUSS_AREA(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the areas under the Gaussians of column V1, the values of the VX column are the areas under the Gaussians of column V2, and the values of the VY column are the areas under the Gaussians of column V3. The Gaussian is zero-mean and unit-variant.

TEMP = GAUSS_AREA(V1[1:50]:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the areas under the Gaussians of rows 1-50 column V1, the values of the VX column are the areas under the Gaussians of rows 1-50 column V2, and the values of the rows of the VY column are the areas under the Gaussians of column V3. The Gaussian is zero-mean and unit-variant.

TEMP = GAUSS_AREA(V1, 0, 3.5)

Creates a new column named TEMP, where each value is the area under the Gaussian of the corresponding row of column V1. The Gaussian has a mean of 0 and a standard deviation of 3.5.

TEMP = GAUSS_AREA(V1, V2, V3)

Creates a new column named TEMP, where each value is the area under the Gaussian of column V1, using the corresponding row value of column V2 as the mean and the corresponding row value of column V3 as the standard deviation.

TEMP = GAUSS_AREA(V1:V2, V3:V4, V5:V6)

Creates two new columns named TEMP and VX. The column TEMP contains the areas under the Gaussians of the values in V1 using the corresponding rows of column V3 as the mean and the corresponding rows of column V5 as the standard deviation. The column VX contains the areas under the Gaussians of the values in V2 using the corresponding rows of column V4 as the mean and the corresponding rows of column V6 as the standard deviation.