Running a Choice Based Conjoint Analysis (CBC) with XLSTAT-Conjoint

Dataset for Choice based conjoint analysis XLS79.0 KB

Tutorial video
Choice based conjoint analysis is part of: Download Trial version More details See users' feedback
  • Conjoint Conjoint analysis software

  • System configuration

    • Windows:
      • Versions: 9x/Me/NT/2000/XP/Vista/Win 7/Win 8
      • Excel: 97 and later
      • Processor: 32 or 64 bits
      • Hard disk: 150 Mb
    • Mac OS X:
      • OS: OS X
      • Excel: X, 2004 and 2011
      • Hard disk: 150Mb.


  • Easy and user-friendly
    Easy and user-friendly XLSTAT is flawlessly integrated with Microsoft Excel which is the most popular spreadsheet worldwide. This integration makes it one of the simplest available tools to work with as it utilizes the same philosophy as Microsoft Excel. The program is accessible in a dedicated XLSTAT tab. The analyses are grouped into functional menus. The dialog boxes are user-friendly and setting up an analysis is straightforward.
  • Data and results shared seamlessly
    Data and results shared seamlessly One of the greatest advantages of XLSTAT is the way you can share data and results seamlessly. As the results are stored in Microsoft Excel, anyone can access them. There is no need for the receiver to have an XLSTAT license or any additional viewer which makes your team-work easier and more affordable. In addition, results are easily integrable into other Microsoft Office software such as PowerPoint, so that you can create striking presentation in minutes.
  • Modular
    Modular XLSTAT is a modular product. XLSTAT-Pro is a core statistical module of XLSTAT which includes all the mainstream functionalities in statistics and multivariate analysis. More advanced features contained in add-on modules can be added for specific applications. This way you can adapt the software to your needs making the software more cost-efficient.
  • Didactic
    Didactic The results of XLSTAT are organized by analysis and are easy to navigate. Moreover useful information is provided along with the results to assist you in your interpretation.
  • Affordable
    Affordable XLSTAT is a complete and modular analytical solution that can suit any analytical business needs. It is very reasonably priced so that the return of your investment is almost immediate. Any XLSTAT license comes with top level support and assistance.
  • Accessible - Available in many languages
    Accessible - Available in many languages We have ensured XLSTAT is accessible to everyone by making the program available in many languages, including Chinese, English, French, German, Italian, Japanese, Polish, Portuguese and Spanish.
  • Automatable and customizable
    Automatable and customizable Most of the statistical functions available in XLSTAT can be called directly from the Visual Basic window of Microsoft Excel. They can be modified and integrated to more code to fit to the specificity of your domain. Adding tables and plots as well as modifying existing outputs becomes easy. Furthermore, XLSTAT includes some special tools on the dialog boxes to generate automatically the VBA code in order to reproduce your analysis using the VBA editor or to simply load pre-set settings. This effortless automation of routine analysis will be a huge time saver on your part.

What is Conjoint Analysis?

Conjoint analysis is a marketing method that allows to know the expectations of consumers about a product and to model their choices. The conjoint analysis method is now extremely common in marketing. Modeling of consumer choice is a key area of marketing. Conjoint analysis is used to simulate competitive markets using a single analysis; it is its biggest advantage.

Conjoint analysis is a method that helps you to find out the expectations of consumers towards new products and to model their choices - both crucial steps of a marketing analysis. Two methods of conjoint analysis are available: full profile conjoint analysis and choice based conjoint analysis (CBC). XLSTAT-Conjoint is a complete statistical program which allows you to run through all the analytical steps of conjoint analysis which can be divided in five steps:

  1. Choice of the relevant factors and their modalities to describe the products.
  2. Generation of design of experiments based on full factorial, fractional factorial, D-optimal and incomplete block designs.
  3. Collection of the results in Microsoft Excel sheets.
  4. Data analysis with specific regression methods - MONANOVA (monotone regression), multinomial logit, conditional logit, etc.
  5. Simulation of new markets with various methods: first choice, logit, Bradley-Terry-Luce, randomized first choice.

These steps can be carried out both for a full profile conjoint analysis and for a choice based conjoint analysis (CBC).

In this tutorial, we will detail the steps necessary for the implementation and interpretation of a conjoint analysis with XLSTAT-Conjoint.

Dataset to conduct a conjoint analysis

An Excel spreadsheet containing the results of this example can be downloaded by clicking here The results are divided into different sheets:

  1. Factors: this sheet contains the characteristics of the selected factors.
  2. CBC Design: this sheet contains the profiles generated, and the choices given by the 10 individuals.
  3. CBC: this sheet contains the results of conjoint analysis (CBC).
  4. Simulated market: this sheet contains the complete market to simulate.
  5. Market Simulation: this sheet contains the results of the market simulation.

First step: the choice of the factors

In this tutorial we will look at a classic case of conjoint analysis on the introduction of a new product in a competitive market. This product is a drink based on tea.

A brand of softdrink want to introduce a new product and in order to answer two questions, a conjoint analysis is applied. What are the characteristics that should bring the drink in order to, first, please the greatest number of people, and, secondly, to gain market shares in an already competitive market?

The first step in the conjoint analysis is done in collaboration with experts in the beverage market. It is the choice of the important characteristics to define a drink. The selected factors are:

  1. temperature (very hot, hot, iced)
  2. sugar (no sugar, 1 sugar, 2 sugar)
  3. Lemon (yes, no)
  4. intensity (strong, medium, light)

From these factors, you can get 54 different products. Judges will not be able to evaluate all these products. So we will use experimental designs to reduce the number of products presented to the respondents. In addition, in the choice based conjoint analysis (CBC), selections of products are presented to the individuals who will choose the one they would buy.

Second step: the selection of profiles and generation of the comparisons

XLSTAT-Conjoint so you can select a number of profiles defined to gather them in the form of comparisons and thus allow those interviewed to make choices.

Once XLSTAT is started, click on the CJT icon and choose the function Design for choice based conjoint analysis.


Once the button is clicked, the dialog box appears.

You can then enter the name of the analysis, the number of factors (four in our case), the number of profiles to classify (12), the number of comparisons (20, this number has to be greater than the number of profiles) and the number of profiles per comparison (3).


In the "Factors" tab, use the option of "selecting data in the worksheet" and select the data in the "Factors" sheet. Do not select labels associated to each column.


In the Output tab, do not activate the individual sheets in the case of this example because the generation of these sheets is not necessary. In a comprehensive analysis, they can be very useful in order to fill the results directly by individuals.


Once you click the OK button, a new dialog box appears. This allows you to select the fractional factorial design of experiments or to optimize the design (D-optimal). We use the "optimize" option.


Once you click the Optimize button, the calculations are made, then the results are displayed.

The first table summarizes the generated model. The second table is the table of profiles


The following table is the table of choice, it is in the sheet "CBC" and must be completed after individuals have been interviewed. The choices are between 1 and 3 for each individual. The numbers on the left of the table are associated with profiles of the profile table.


Step 3: Fill the conjoint analysis of tables

The conjoint analysis tables can either be filled directly after interviewing individuals about their choices externally or directly using the individual sheets and automatic referencing of results. This is especially interesting in the context of CBC analysis because completing the overall table can be complex.

Important: When using the optimize version of the design algorithm. Please check the validity of the design by responding to a set of question and running the model. If utilities are well displayed, then, you can make your respondents fill the rest of the table.

Step 4: Results of the analysis

As part of this analysis, 10 individuals have been questioned about their preferences in terms of tea. The results are in the CBC sheet.

To start the analysis, click the icon CJT and choose the function conjoint analysis based on the choice . You can then select the data.

Select the 10 columns of the table of responses completed by individuals as answers. Select the three columns of the numbers of choice (without the names of the selections) as a table of choices and select the profile table as profiles (without the names of the profiles).


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

A multinomial logit model derived from a specific conditional logit model is used for estimation. The most important results are the utilities and importances. They can be found in the first tables. We see that the utilities are not individual but related to all individuals.

result CBC utilities

This shows that the temperature factor is the most important factor in the analysis with an importance of more than 50%, then the lemon has an importance of 30%. Concerning utilities, we see that the iced temperature has a positive effect on choice. The choice of individuals will therefore to a frozen light drink, without lemon and sugar.

Step 5: Simulation of the market

The main advantage of conjoint analysis is to simulate a market even if the products in the market have not been tested by the individuals.

In our case, the market for a tea-based beverages is analyzed and we would like to know the impact and market shares associated to a new product. This product is a strong iced tea with lemon and no sugar. We know that in today's market there are 4 tea-based beverages that have different characteristics, the following table shows the simulated market:


To start the simulation, click the CJT icon and choose the function conjoint analysis simulation . You can then select the data.

Utilities are those obtained in the CBC sheet, the table of information about variables is that obtained in the CBC sheet. The simulated market is in the simulated market sheet (do not select the names of products). You can also select the name of the product just behind the Product ID button. Select the CBC model and the logit method for simulation.


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

The table shows that the market share for the new product are greater than 20%. This result seems satisfactory in order to launch the product on the market.

result cbc market simulation

The associated pie chart validates our interpretation.

plot market simulation cbc conjoint

Much more advanced analysis are possible with XLSTAT-Conjoint (use of segmentation variables, weights...).