The conditional logit model with XLSTAT-Conjoint

The conditional logit model

The conditional logit model is a statistical method similar to logistic regression.

The conditional logit model is a method mostly used in its evolved form as part of the conjoint analysis, it is nevertheless useful when analyzing a certain type of data.

It is McFadden (1973) who introduced this model. Instead of having one line per individual, there will be as many lines as alternatives. Thus, it is no longer the characteristics of individuals that are modeled but those alternatives.

If one seeks to study travel modes, we will have four travel modes (car / train / air / bus), each travel mode has is own characteristics (price, speed) but an individual can choose only one of the four modes.

As part of a conditional logit model, we have for N individuals, N*4 rows with 4 rows associated with the four choices. The binary response variable will indicate the choice of the individual (1) and 0 if the individual did not choose this option.

A column associated with the name of the individuals (with 4 lines per individual for our example) has to be selected in XLSTAT. The explanatory variables will also have N * 4 rows.

Dataset for the conditional logit model

The example discussed below is a classic case in which one seeks to compare the travel modes proposed to go on vacation. It comes from Greene, W.H. (2003). Econometric Analysis, 5th edition. Upper Saddle River, NJ: Prentice Hall.

An Excel file containing both the data and the results can be downloaded by clicking here.

The data correspond to a sample of 210 individuals, each one having 4 possibilities (air, car, bus and train). We asked each of them the travel mode they would choose to go on vacation.

The data set has 840 rows. The first column identifies the individual, the second is the binary variable modeling the travel mode. Then there are two quantitative variables, respectively, the overall cost and the waiting time during the trip associated with each travel mode for each individual. Finally, the categorical variable associated with the transportation is in the last column (air, train, bus or car).

Set a conditional logit model

To activate the dialog box, start XLSTAT, then select XLSTAT / XLSTAT-Conjoint / Conditional Logit , or click the corresponding button on the XLSTAT-Conjoint toolbar (see below).


Once you have clicked the button, the dialog box appears.

Select the data on the Excel sheet.

The response variable corresponds to the binary variable.
The subject labels correspond to the numbers associated with the individuals (you can also have names of individuals instead).
In our case there are three predictors, one qualitative - the travel mode - and two quantitative - global cost and waiting time. As we selected the labels of the variables, we must select the variables labels option.


Once you click the OK button, the calculations are performed and the results displayed.

Interpret the results of a conditional logit model

The following table gives several indicators of the quality of the model (or goodness of fit). These results are similar to R² and to the analysis of variance table of linear regression and ANOVA. The most important value is the Chi-square associated with the log ratio (LR). This is the equivalent of the F test of Fisher's linear model: an attempt to assess whether the variables provide a significant amount of information to explain the variability of the binary variable. In our case, as the probability is less than 0.0001, we can conclude that the variables provide a significant amount of information.


These goodness of fit statistics show that our model is significantly better than the model without any predictors. The following table confirms these initial impressions:


The p-values ​​are all very small and the impact of the three variables is significant in the type III analysis table.


Finally, the coefficients of the model show that the air is preferred and that the waiting time has a significant negative effect on the choice of travel mode.



The analysis of residuals may also be useful and provide other information about individuals' choices.

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