Skip to main content

[en] DataInvestigation_Z-Score_71x71.png Standardize z-score Tool

[en] Use Standardize z-score to perform 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.

[en] Supporting Macro Location

[en] This is a supporting macro so it does not show in the Tool Palette. You can find it in the following directory:

[en] Program Files\Alteryx\bin\RuntimeData\Macros\Predictive Tools\Supporting_Macros

[en] This tool has no configuration parameters.

[en] Output Details

  • [en] D anchor: Contains the standardized version of the numeric fields contained in the input stream.

  • [en] P anchor: Contains these fields:

    • [en] Name: The name of each transformed field.

    • [en] Mean: The field mean used in the standardization.

    • [en] SD: The field standard deviation used in the standardization. This information helps to implement scoring and other similar downstream processing.

: