Creating a disjunctive table in XLSTAT

Dataset for creating a disjunctive table

An Excel sheet with both the data and the results can be downloaded by clicking here. In this tutorial we will show how to create a disjunctive table fron category variables.

The 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. This means that we will split each category variable into corresponding binary variables (coded in 0 and 1).

Creating the disjunctive table

After opening XLSTAT, select the XLSTAT / Preparing data / Complete Disjunctive tables command, or click on the corresponding button of the "Preparing data" toolbar (see below).

statistical softwarestatistical software

Once you've clicked on the button, the dialog box appears. Select the category variables you wish to split. Select the variables Age, City and Gender by selecting the whole columns.

The output should be displayed in an appended table so tick the option Range and select the cell E1 to begin displaying the results.

The columns A, B and C contain variable labels so the option Variable labels should be ticked.

Moreover to avoid having text written above the results we deselect the option Display the report header.

data analysis software

Once you have completed the tasks click on the OK button.

Disjunctive table in XLSTAT

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

PLS regression software

This video shows you how to reproduce those results.

Click here for other tutorials.

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey


Like us on Facebook Facebook

Get in Touch

  • Email:
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414