Complete the following steps to standardize columns of data.
column(s), enter one or more columns to standardize.
In Store results
in, enter a column number (for example, C1) or a column name for each input column.If the name contains spaces, enclose the name in single quotation marks.
Select the method to standardize the data:
Subtract mean and
divide by standard deviation: Center the data and change the units to standard deviations. For a regression analysis, select this method to standardize predictors in order to reduce multicollinearity and to compare the size of the coefficients on a comparable scale.
mean: Center the data. For a regression analysis, select this method to standardize predictors in order to reduce multicollinearity. This method is helpful when your model contains highly correlated predictors, higher-order terms, and interaction terms.
Divide by standard
deviation: Standardize the scale for each variable that you specify, so that you can compare them on a similar scale. For a regression analysis, select this method to standardize predictor variables in order to determine which predictors have a larger effect, while controlling for differences in scale.
Subtract first value,
then divide by second: Enter your own values (such as known values for the mean and the standard deviation) to subtract from and divide by.
Make range from start
to end: Transform the data linearly so that the resulting data have the first value that you specify as a minimum, and the second value that you specify as a maximum.