Your data analysis solution

Coding and recoding data in Excel

2017-10-20

This tutorial will help you re-code your data based on a reference coding table in Excel using the XLSTAT software.

Dataset to be recoded

Download data file

An Excel sheet with both the data and the results can be downloaded by clicking here

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 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 be 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 with this tutorial.

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283