Interactive Excel simulator
How do I export the interactive simulator to excel
You can download the interactive simulator by adding it to your analysis cart. Click on the “Add more outputs” dropdown menu on the right side of the export cart and click on the “Interactive simulator” option. This will add a tab that you can use as a simulator.
How do I use the interactive simulator
As well as the user-friendly online simulator, Conjoint.ly also allows you to export an interactive Excel simulator. To use it, please refer to the
Additionally, you can explore its inner workings by looking at the hidden sheets labelled
SimXXX. For example:
Sim1contains individual preferences.
Sim2translates the simulator parameters into
Sim3is a matrix obtained by
Sim6calculates the individual share of preference through the multinomial logit formula:
How do I perform segmentation in the Excel simulator?
You can create segments in the Excel simulator by adjusting the Weight of each respondent within the Individual Preferences tab.
By default, the weight for each respondent is 1, meaning that all respondents are included in all simulations. To create a new segment, the weight for each respondent will need to be set to 1 to include them within the segment, or 0 to exclude them.
Can you build a custom Excel simulator?
Yes, preference share simulators are commonly customised for specific conjoint studies. It is particularly useful for more complicated types of conjoint analysis.