XLSTAT: Coding and Recoding Data in Excel

 

Dataset for Example

The (attached) dataset contains 20 clients and their age, city of residence and gender. We will recode the variable City into the cardinal points North, South, East, West .

 

Setting Up

• Open XLSTAT.

• Click on the Preparing data menu and select the Coding feature.

• Once you've clicked on the relevant button, the dialog box appears.

In the General tab:

• Select the variable you want to recode. Here we choose the variable  "City"  by selecting the whole column.

• Select the coding table that contains both the old values and new values. Include the heading in the selection.

• The output should be displayed as a new column in the table. Select the option Range (XLSTAT Options) and select a cell next to the table such as E1.

• Untick the option Display the report header

• Click on the OK button to launch the computations.

 

Interpreting the Results

The results will now be displayed next to the table.