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.

XLSTAT

This analysis is available in the XLStat-Base addin for Microsoft Excel

About KCS

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.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414