To normalize the numeric value, you can select “normalize” from the Column Header Menu.
Work with Numeric Function -> normalize
This opens Create Calculation Dialog like below.
And this will create normalized (mean:0, SD:1)
<column_num> , center =
<logical> , scale =
- center (Optional) - The default is TRUE. Either a logical value of TRUE or FALSE, or a numeric value. If it is TRUE then centering is done by subtracting the mean (omitting NAs) of the column values. If center is FALSE, no centering is done.
- scale (Optional) - The default is TRUE. Either a logical value of TRUE or FALSE, or a numeric value. When it is TRUE and center is TRUE, scaling is done by dividing by the standard deviation. In other words, it will end up as calculating
(x - mean(x)) / sd(x). When it is TRUE and center is FALSE, scaling is done by dividing by the root-mean-square, which is same as calculating
x / sqrt(sum(x^2)/(length(x)-1)). When it is a numeric value, input values are devided by this numeric value. When it is FALSE, no scaling is done.