Normalizing numeric values

"Normalize" operation adjust values measured on different scales to a notionally common scale.

Zafer Çavdar avatar
Written by Zafer Çavdar
Updated over a week ago

Keywords: normalization, scaling, normal distribution, probability distribution, standardization

Normalization in statistics is used to bring the entire probability distributions of adjusted values into alignment.

Step-by-step guide

1. Select the numeric field

Select the numeric field you want to normalize in the Schema View.

2. Open the operation configuration window

Click the "Add operations" button at the top of the workspace, then click the "Numerical operations" tab, then click "Normalize".

3. Set the parameters of the operation

The following parameters can be set:

  • Numeric path: Name of the input numeric source field.

  • Method:

    • Standard normalizer: The mean value of the distribution is adjusted to 0 while the standard deviation of the distribution is adjusted to 1.

    • Standard deviation normalizer: The standard deviation of the distribution is adjusted to 1.

    • Mean normalizer: The mean value of the distribution is adjusted to 0.

    • Min-max normalizer: The distribution is scaled to the [0-1] range. The minimum value becomes 0 and the maximum value becomes 1.

    • Max absolute value normalizer: Maximal absolute value in the distribution is scaled to 1.

  • Output field name: Normalized values will be stored as a decimal number under this field.

4. Apply the operation

Click "Apply". A new decimal number field (named "normalized" by default) has now been generated and added to the schema.

Did this answer your question?