Standardize columns of data

Calc > Standardize

Complete the following steps to standardize columns of data.

  1. In Input column(s), enter one or more columns to standardize.
  2. 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.
  3. 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.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy