Standardize z-score Tool
The Standardize z-score tool performs a z-score transformation on all the numeric fields in an input data stream. The z-score transformation consists of subtracting the mean value from each of the original values in a field and then dividing this difference by the standard deviation of the field. This results in standardized fields that each have a mean of zero and a standard deviation of one, but are perfectly correlated with the original field values.
Supporting macro location
This is a supporting macro so it does not show in the Tool Palette. You can find it in the following directory: Program Files\Alteryx\bin\RuntimeData\Macros\Predictive Tools\Supporting_Macros
This tool has no parameters that need to be configured.
View the output
- D anchor: Contains the standardized version of the numeric fields contained in the input stream.
- P anchor: Contains the fields:
- Name - The name of each transformed field
- Mean - The field mean used in the standardization
- SD - The field standard deviation used in the standardization. This information helps to implement scoring and other similar downstream processing.