Data > Standardize
The Standardize utility performs data transformation
on columns of data, including scaling and moving the center of data
in a column, as well as adjusting the range of the data.
To use the utility, select Data > Standardize
.
- In the Input Column(s) text box, enter the names
of the columns. Separate column names by spaces (e.g. c2 c4),
and use a dash to indicate a range of columns (e.g. c10-c15).
- In the Store results in column(s) text box,
enter valid column names where the results will be stored.
The number of input columns must be the same as
the number of columns for storing results.
The results of standardizing the input column(s) will be
stored in the store columns in order.
- Select one of the following options:
- Subtract mean and divide by standard deviation:
For each number in the column, subtract the mean of the
column data set and divide by the standard deviation.
- Subtract
Then divide by
:
For each number in the column, subtract the first specified
number and then divide by the second specified number.
- Make range From:
To:
: For
each number in the column, shift and scale so that the range of
the data goes from From to To.
- Click OK to finish.