How Do I Standardize Data in Excel
Using SigmaXL?

Standardize Data

This tool is used to Standardize ((Yi – Mean)/StDev) or Code (Ymax = +1, Ymin = -1) your data. This is particularly useful when performing Multiple Regression. Standardized Predictors have better statistical properties. For example, the importance of model coefficients can be determined by the relative size because units are removed. Another statistical benefit is reduced multicollinearity when investigating two-factor interactions.