Coding and recoding data in XLSTAT

Dataset to be recoded

An Excel sheet with both the data and the results can be downloaded by clicking here. In this tutorial we will show how to generate a contingency table.

Recoding the data using a coding table

The dataset contains 20 clients and their age, city of residence and gender. We will recode the variable City using a coding table.

After opening XLSTAT, select the XLSTAT / Preparing data / Code command, or click on the corresponding button of the Preparing data toolbar (see below).

statistical softwarestatistical software

Once you've clicked on the relevant button, the dialog box appears.
Select the variable you wish to recode.
Here we choose the variable "City" by selecting the whole column. Then select the coding table that contains both the old values and new values. Note that you should include the heading in the selection.

The output should be displayed as a new column in the table so select the option Range and select a cell next to the table such as E1.

To avoid having text written above the results we untick the option Display the report header.

Partial Least Squares software

When ready click on the OK button.
The results will now displayed next to the table. You can verify that the code has been properly used.

Principal component analysis software

This video shows you how to proceed witth this tutorial.

Click here for other tutorials.

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


Like us on Facebook Facebook

Get in Touch

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