Example of Standardize

A materials engineer at a furniture manufacturing site wants to assess the stiffness of the particle board that the manufacturer uses. The engineer collects stiffness data from particle board pieces that have various densities at different temperatures.

To compare the temperature and density on the same scale and with the same center, the engineer standardizes these variables.

  1. Open the sample data, ParticleBoard.MTW.
  2. Choose Calc > Standardize.
  3. In Input column(s), enter Density Temp.
  4. In Store results in, type 'Std Density' 'Std Temp'.
  5. Select Subtract mean and divide by standard deviation.
  6. Click OK.


The standardized columns are in the worksheet. The engineer can compare the standardized density and temperature on the same scale with the same center.

C1 C2 C3 C4 C5
Density Stiffness Temp Std Density Std Temp
9.5 14.81 70.6 −0.99293 0.95796
8.4 17.50 73.3 −1.18466 2.07910
9.8 14.01 66.2 −0.94064 −0.86674
... ... ... ... ...