Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

WTP - segmentation

Hello, I am currently doing an analysis on WTP and I want to segment my data. On categorical variables it works well but I would like to also segment my data based on numerical variables. In my specific case, I have age as numerical values but I would like to make two categories (younger generation, older generation) to investigate WTP in these two segments. How can I do that? Thanks in advance!
asked Apr 15, 2021 by Melanie Schreiner (120 points)

1 Answer

0 votes
You can create discrete segments from continuous data.  Inside Lighthouse, under the Analysis menu, you can first set up a filter where you define logic, like QuestionName < 30 and QuestionName>30.  Then also under the Analysis menu, you can add columns to your data based on those filters, like Age2 where you assign a 1 in the data if they are in the first filter or a 2 if they are in the second filter.

Alternatively (and maybe a little easier in your case) is you could download/export a CSV of the data, delete all columns except respondent number and the age column, then in Excel write a simple if statement to produce the 1/2 values yourself.  Then you can import the new CSV back into Lighthouse to append your new variable.
answered Apr 15, 2021 by Brian McEwan Platinum Sawtooth Software, Inc. (55,820 points)