A simple conjoint analysis example in Excel

Posted on 1 October 2019

Download conjoint analysis example in Excel

Conjoint analysis (also called trade-off analysis) is used in many social sciences and disciplines, including marketing, product management, and pricing. In this post, we provide a conjoint analysis example in Excel (also available as a Google Sheet conjoint example – which you can copy to edit). This example will show:

  1. Inputs into a conjoint study
  2. Questions (choice sets) that respondents see
  3. Calculations of partworth utilities (relative preferences and importance scores of attributes)

This example is limited to:

If you’d like to experience a real online conjoint analysis tool, sign up and take a look at example reports.