XLSTAT: Creating a Disjunctive Table in Excel

 

Dataset for Example

The (attached) dataset contains 20 clients with their age class, city of residence and gender.

We will transform the variables Age, City and Gender into a disjunctive table (splitting each category variable into corresponding binary variables, 0 and 1).

 

Setting Up

• Open XLSTAT.

• Click on the Preparing data menu and select the Complete Disjunctive tables feature.

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

In the General tab: 

• Select the category variables you wish to split.

• Select Age, City and Gender by selecting the columns.

• The option Variable labels should be ticked (columns A, B and C contain variable labels)

• Deselect the option 'Display the report header' to avoid having text written above the results.

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

The results are now displayed next to the original variables. You can see the correspondence between the category variables and their disjunctive tables.