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.

Performing segmentation in the Excel simulator

The Excel Plugin helps with charting outputs, including simulations charts from the online simulator (scenario modelling and price elasticity charts), colouring for TURF analysis, and other useful utility functions.

This question from our users was answered on 25 September 2020. If there is anything else you'd like to know, please do not hesitate to contact us.