xlstat

COMPLETE DISJUNCIVE TABLES (CREATING DUMMY VARIABLES)

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 k'th category and 0 for the other observations.