Details on Normalization


This dialog is used to transform a data table by normalizing the data in one or more of its columns.

Tip: You can replace a data table with a transformed version of itself.

  1. Select File > Add Data Tables... and add the data of interest.

  2. Click Show transformations.

  3. Select Normalization  from the drop-down list and click Add....

Tip: The Show transformations-section is also available when replacing data tables and when adding columns or rows to a data table.

  1. Select Insert > Transformations....

  2. In the Data table drop-down list, select the data table you want to add the transformation to.

  3. Select Normalization from the drop-down list and click Add....

norm_normalization_d.png

Option

Description

Result options

 

   Add columns

Click this radio button to add new normalized columns to the resulting data table. The old columns will also be kept.

   Replace selected columns

Click this radio button to replace the old columns with the new, normalized ones.

Available columns

Lists the columns available in the selected data source.

Add >

Moves the columns selected in the Available columns list to the Selected columns list.

< Remove

Removes the selected columns from the Selected columns list.

Remove All

Removes all columns form the Selected columns list.

Move Up

Moves the selected column in the Selected columns list up one step.

Move Down

Moves the selected column in the Selected columns list down one step.

Selected columns

Lists the columns that are selected to be normalized.

Method

Specifies the normalization method to use. See Normalizing Columns and the theory section for each method for further information about the various methods.

Baseline column

Specifies the baseline column to use (in some normalization methods only).

Percentage

Specifies the percentage value (P) to use when normalizing by percentile or by trimmed mean.

Description

Shows a brief description of the currently selected normalization method.

Column names setting

Specifies how the naming of the normalized columns should be handled. You can either add the word "Normalized:" to the column name of the original columns or use the expression (normalization equation) as a column name.

If you have selected to replace columns you will also get a third option where you can keep the current column names.

See also:

Transforming Data