rnormalize

1 Menu Information
2 Brief Information
3 Additional Information
4 Command Line Usage
5 Variables
6 Description
7 Examples
8 Algorithm
9 Related X-Functions

Menu Information

Normalize Columns

Brief Information

Normalize the input range column by column

Additional Information

Minimum Origin Version Required: 8.1 SR0

Command Line Usage


rnormalize irng:=2:4 method:=min;
rnormalize irng:=Col(B) method:=specify val:=7 orng:=<new>;
rnormalize irng:=2:4 method:=ref type:=max refcol:=5 orng:=<new>;
rnormalize irng:=2:4 method:=cell cell:=1[10] orng:=<new>;

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Input	irng	Input Range	<active>	Specify the columns/ranges to be normalized.
Normalize Methods	method	Input int	1	Specify the method used to normalize the data. Option list: specify:Divided by a specified value Divide the input data by a specified value specified by the val variable.. range:Normalize to [0, 1] Normalize the input data to the range [0, 1]. snd:Transfer to N(0, 1) Transform to standard normal distribution. max:Divided by Max Divide the input data by the maximum value. min:Divided by Min Divide the input data by the minimum value. mean:Divided by Mean Divide the input data by the mean. median:Divided by Median Divide the input data by the median. sd:Divided by SD Divide the input data by the standard deviation. norm:Divided by Norm Divide the input data by the Norm. mode:Divided by Mode Divide the input data by the mode. sum:Divided by Sum Divide the input data input data by the sum. ref:Use Reference Column Normalize the input data by matching the statistic specified by the type variable to that of a reference column specified by the refcol variable. cell:Divided by Reference Cell Divide the input data using a reference cell specified by the cell variable.
User Defined Value	val	Input double	1.0	This variable is available only when method is set to specify. It specifies the value used to divide the input data.
Reference Column	refcol	Input Column	<optional>	This variable is available only when method is set to ref. It specifies the reference column.
Normalize to	type	Input int	0	This variable is available only when method is set to ref. It determines a statistic. After normalization, the statistic of any input column will match that of the reference column. Option list: min:Min Normalize the input columns such that the min value of each column matches that of the reference column. max:Max Normalize the input columns such that the max value of each column matches that of the reference column. mean:Mean Normalize the input columns such that the mean value of each column matches that of the reference column. median:Median Normalize the input columns such that the median value of each column matches that of the reference column. sum:Sum Normalize the input columns such that the sum of each column matches that of the reference column.
Reference Cell	cell	Input Range	<optional>	This variable is available only when method is set to cell. It specifies the cell used to divide the input data.
Output	orng	Output Range	<new>	Specify the output for the normalized columns. See the syntax here.

Description

This function adjusts column(s) or part of the column(s) to s specific "standard" level. It treats each selected column indepently and normalizes all the columns one by one.

Examples

The following script will show you an example of normalizing two sets of data according to a third dataset.

string fn$=system.path.program$ + "\Samples\Curve Fitting\Exponential Decay.dat "; 
impASC fname:=fn$;
rnormalize irng:=3:4 method:=ref refcol:=2 orng:=<new>;