Include Top

Home | Login | Live Help is Live Help

Included Menu

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.

  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. Standardize Data

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

  7. Standardize Results

Click here to download a Free 30-Day Trial.