XLSTAT - Variable Transformation
Use of variable transformation
Variable transformation is often necessary to get a more representative variable for the purpose of the analysis.
Deciding on the appropriate transformation will often improve the quality of your results.
XLSTAT variable transformation functions
This function allows you to transform a quantitative variable using many different analytical functions.
XLSTAT provides the following analytical functions:
- Standardize (n-1)To standardize the variables using the unbiased standard deviation.
- Standardize (n)To standardize the variables using the biased standard deviation.
- CenterTo center the variables.
- 1/ Standard deviation (n-1)To divide the variables by their unbiased standard deviation.
- 1/ Standard deviation (n)To divide the variables by their biased standard deviation.
- Rescale from 0 to 100
- Binarize (0/1)To convert all values that are not 0 to 1, and leave the 0s unchanged.
- Sign (-1/0/1)To convert all values that are negative to -1, all positive values to 1, and leave the 0s unchanged.
- Box-Cox transformationTo improve the normality of the sample.
- WinsorizeTo remove data that are not within an interval defined by two percentiles.
This analysis is available in the XLStat-Basic addin for Microsoft Excel™