Creating a contingency table in XLSTAT
Dataset to create a contingency table
A MS Excel spreadsheet with both the data and the results can be downloaded by clicking here. In this tutorial we show how to generate a contingency table.
The dataset contains information on 20 clients: their age, city of residence and gender. We will create a contingency table on the Age and City variables.
Creating a contingency table
After opening XLSTAT, select the XLSTAT / Preparing data / Create a contingency table command, or click on the corresponding button of the "Preparing data" toolbar (see below).
Once you've clicked on the relevant button, the dialog box appears. Select the category variable you wish to use in rows. Select the variable Age by selecting the entire column. Then select the variable to be used in Colum, select the variable City.
The output should be displayed in a new sheet so tick the option Sheet.
The columns B and C contain variable labels so the option Variable labels should be ticked.
now you should proceed to the next tab Options. Here you can decide how the categories of the variable should be treated. Also you can do a Chi-square test. In this case, however, we will only select the optionSort the categories alphabetically.
In the tab Outputs, select the Contingency table as well as the observed and theoritical frequencies.
Select the 3D view of the contingency table in the tab Charts.
The computations begin once you have clicked on the OK button, and the results are displayed on a new sheet.
Results of the creation of a contingency table
The first result is the contingency table.
Notice that there isn't a client in all crossed categories. For example thre is no client in Paris aged 25-34.
The next result is the 3-D plot, which is a good visualization of the data distribution.
Next are the two tables containing the frequencies Age/City.
You can compare the actual distribution of the clients and the theoritical distribution if the distribution was random.
Click here for other tutorials.