MaxDiff Analysis from external data export

Hi everybody,

our client provided us the MaxDiff results of our market survey as raw data (Collected with the market survey program Alida). It is an excel file with one line per respondent and per screen seen (we had 13 screens per respondent and thus have 13 lines per respondent).

In each line we have the information whether a feature has been seen, has not been seen, has been selected most attractive or has been selected least attractive. That is the structure of our raw data - and we have two questions regarding this:

1. Is it possible at all and if yes, how to calculate the relative MaxDiff scores per feature across all respondents in excel directly?

2. If the first approach is not feasible, is it possible to upload such a data structure in the sawtooth program to calculate those scores there?

Thank you a lot in advance!
Best
Adrian

Resolved
8 replies