GAUSS

The cell range to compute the Gaussian 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.

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

Syntax

GAUSS computes the Gaussian value of the numbers in the specified data range. It returns one new column for each input column, each containing the Gaussian value of the corresponding input. GAUSS is computed as follows:

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.

Examples

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

Creates a new column named TEMP containing the value 0.4.

TEMP = GAUSS(V1)

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

TEMP = GAUSS(V1:V3)

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

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

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

TEMP = GAUSS(V1, 0, 3.5)

Creates a new column named TEMP, where each value is 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(V1, V2, V3)

Creates a new column named TEMP, where each value is 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(V1:V2, V3:V4, V5:V6)

Creates two new columns named TEMP and VX. The column TEMP contains 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 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.

Related Functions

RANDOM_GAUSS

Returns the specified number of random values from a Gaussian distribution