Transform Node Options Tab
The Options tab enables you to specify the type of transformations you want to include. You can choose to include all available transformations or select transformations individually.
In the latter case, you can also enter a number to offset the data for the inverse and log transformations. Doing so is useful in situations where a large proportion of zeros in the data would bias the mean and standard deviation results.
For example, assume that you have a field named BALANCE that has some
zero values in it, and you want to use the inverse transformation on it. To avoid undesired bias,
you would select Inverse (1/x) and enter 1 in the Use a data
offset field. (Note that this offset is not related to that performed by the
@OFFSET sequence function in IBM® SPSS® Modeler.)
All formulas. Indicates that all available transformations should be calculated and shown in the output.
Select formulas. Enables you to select the different transformations to be calculated and shown in the output.
- Inverse (1/x). Indicates that the inverse transformation should be displayed in the output.
- Log (log n). Indicates that the logn transformation should be displayed in the output.
- Log (log 10). Indicates that the log10 transformation should be displayed in the output.
- Exponential. Indicates that the exponential transformation (ex) should be displayed in the output.
- Square Root. Indicates that the square root transformation should be displayed in the output.