|
If min and max are provided, these values are used for the minimum and maximum, respectively. If these parameters are provided with the ROW keyword, min and max can be columns, specifying a min and max value for each row of data. If min and max are columns, the columns must be either the same length as data or scalar (that is, contain a single value which is used as a constant applied to all values in the corresponding column of data).
|
|
If base_data is provided, the minimum and maximum of this data range are calculated and used to normalize data. The columns in base_data must contain two or more cell values.
|
|
Since all returned values are between 0.0 and 1.0, any values computed using Equation (above) less than 0.0 are returned as 0.0. Similarly, any values greater than 1.0 are returned as 1.0. NORM_MINMAX always returns a data range with the same dimensions as the input data range. The ALL keyword specifies to compute the mean and standard deviation over the entire input data range. The COL keyword specifies to compute a mean and standard deviation for each input column and to use those values for normalizing that column. The ROW keyword specifies to compute a mean and standard deviation for each row in the specified data range and to use those values for normalizing that row.
|
Creates a new column named TEMP containing the value zero.
|
Creates a new column named TEMP containing the values 0, 0.5, and 1. (The minimum and maximum [3 and 5] are calculated from the data range automatically.)
|
Creates a new column named TEMP containing the values 0.3, 0.4, and 0.5. (This time the minimum and maximum [0 and 10] are provided as arguments.)
|
Creates a new column named TEMP containing normalized values of the contents of column V1. The minimum and maximum values used for normalization are calculated over the column V1.
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated over columns V1, V2, and V3.
|
Creates three new columns named TEMP, VX, and VY, each with values in rows 1-5. The contents of column TEMP are the normalized values of the corresponding rows in column V1, the contents of column VX are the normalized values of the corresponding rows of column V2, and the contents of column VY are the normalized values of the corresponding rows of column V3. The minimum and maximum for normalization purposes are calculated over rows 1-5 of columns V1-V3.
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated over columns V4, V5, and V6.
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated for each column independently (that is, a min/max is calculated for column V1, a separate min/max is calculated for column V2, etc.).
|
Creates three new columns named TEMP, VX, and VY, each with values in the first 41 rows. The contents of column TEMP are the normalized values of rows 10-50 of column V1, the contents of column VX are the normalized values of rows 10-50 of column V2, and the contents of column VY are the normalized values of rows 10-50 of column V2. The minimum and maximum for normalization purposes are calculated independently across rows 10-50 for each column.
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated for each column independently using columns V4-V6 (that is, a min/max is calculated over column V4 for normalizing column V1, a separate min/max is calculated over column V5 for normalizing column V2, etc.).
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated over independently over each row across columns V1, V2, and V3.
|
Creates three new columns named TEMP, VX, and VY, each with values in the first 11 rows. The contents of column TEMP are the normalized values of rows 10-20 in column V1, the contents of column VX are the normalized values of rows 10-20 of column V2, and the contents of column VY are the normalized values of rows 10-20 of column V3. The minimum and maximum for normalization purposes are calculated over each of the rows 10-20 of columns V1-V3.
|
Creates three new columns named TEMP, VX, and VY. Each contains the normalized values of the contents of columns V1, V2, and V3, respectively. The minimum and maximum values used for normalization are calculated independently for each row across columns V8-V10.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|