XLSTAT - Full Disjunctive Coding

What is a complete disjunctive table?

A disjunctive table is a drill-down of a table defined by n observations and q qualitative variables V(1), V(2), ... V(q) into a table defined by n observations and p indicators (or dummy variables) where p is the sum of the numbers of categories of the q variables: each variable V(j) is broken down into a sub-table with q(j) columns where column k contains 1's for observations corresponding to the kth category and 0 for the other observations.

How to create a complete disjunctive table with XLSTAT

Simply select a category variable in the XLSTAT tool for creating a complete disjunctive table. The new dummy variables are created within seconds.

Here is an example of complete disjunctive table. From a data table with two category variables, with respectively two and three modalities, a complete disjunctive table is created containing five dummy variables.

Data table:

Complete disjunctive table: