How Do I Standardize Data in Excel Using SigmaXL?

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.

1. Click Sheet 1 Tab of Customer Data.xls.
2. Click SigmaXL > Data Manipulation > Standardize Data.
3. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
4. Select Responsive to Calls and Ease of Communications and click Numeric (Y) Columns to Standardize >>.





5. Click OK. The results are given on the Standardize sheet: