Running a conjoint analysis with XLSTAT-Conjoint

Dataset for Conjoint analysis XLS699 KB

Tutorial video
  • 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.

Benefits

  • 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.

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 allows you to run through all the analytical steps of conjoint analysis which can be divided into five steps:

  1. Choice of the relevant factors and their modalities to describe the products.
  2. Generation of a design of experiments based on full factorial, fractional factorial, or D-optimal.
  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 full profile 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. CA Design: this sheet contains the profiles generated, and the rankings given by the 10 individuals.
  3. Conjoint Analysis: 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 concurential 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 have the drink in order to, first, please the greatest number of people, and, secondly, gain market shares in an already concurential 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. The obtained profiles will be ranked by 10 interviewed people.

Second step: the selection of the profiles

XLSTAT-Conjoint uses experimental designs to select a number of profiles and allow interviewed people to make their rankings.

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

barCJT1.gif

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) and the number of profiles to be generated (12).

cjt1.gif

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

cjt2.gif

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.

cjt3.gif

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.

cjt4.gif

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

The first table summarizes the generated model.

cjt5.gif

The second table is the table of the conjoint analysis with the profiles on the left. The right part of the table has to be filled with the rankings of the respondents.

cjt6.gif

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.

cjt7.gif

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 "Conjoint Analysis" sheet.

To start the analysis, click the icon CJT and choose the function conjoint analysis.

barCJT3.gif

You can then select the data. Select the 10 columns of the conjoint analysis table completed using the rankings of the individuals (right part of the table) as responses. Select the four columns associated to the profiles as profiles (without the names of the profiles). Choose the ranking option as response type.

cjt8.gif

In the options tab, select the MONANOVA method in order to apply a monotone transformation to the responses.

cjt9.gif

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

The most important results are the partial utilities as well as the individual importances. They can be found in the first tables. We see that the utilities are individual as well as importance.

cjt10.gif

Their averages are calculated and give an idea of the importance of each factor.

cjt11.gif

These first results show that temperature is the most important factor both at the individual level ant at the average level. The fact that the drink is ice has a largely positive if you look at the utilities (in terms of averages).

XLSTAT-Conjoint allows to make segmentations of the individuals by using statistical clustering methods. This option allows to see if homogeneous groups of individuals emerge.

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:

cjt13.gif

To start the simulation, click the CJT icon and choose the function conjoint analysis simulation .

barCJT5.gif

You can then select the data. Utilities are those obtained in the "Conjoint analysis" sheet, the table of information about variables is that obtained in the "Conjoint analysis" 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 Full profile model and the logit method for simulation.

cjt12.gif

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 almost 30%. This result seems satisfactory in order to launch the product on the market.

cjt14.gif

The associated pie chart validates our interpretation.

cjt15.gif

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