Overview for Standardize

Standardize columns of data that have differences in center or scale. You can standardize columns of data to combine and analyze them together, or to simplify comparisons among them. The standardized data are placed in new columns in the worksheet.

For example, a researcher wants to model pulse rates using heights and weights. The researcher standardizes the predictors Height and Weight.

C1 C2 C3 C4 C5
Height Weight Pulse Standardize Height Standardize Weight
66.00 140 64 -2.72527 -5.0989
72.00 145 58 3.27473 -0.0989
73.50 160 62 4.77473 14.9011
73.00 190 66 4.27473 44.9011
69.00 155 64 0.27473 9.9011
... ... ... ... ...

In regression, standardizing the predictors using the Subtract the mean option can reduce multicollinearity in models that contain polynomial terms and interaction terms.

Where to find this command

  • Mac: Data > Standardize
  • PC: DATA > Standardize
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy