Complete the following steps to standardize columns of data.

- In Input 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.
- Subtract 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.