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.
• Arcsin
• 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-Base addin for Microsoft Excel

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.