During a survey of 1000 respondents, when searching for the preferred 2 or 3 attributes from a list of 11 attributes, MaxDiff is preferred over simple ranking. In this MaxDiff example respondents answer 15 questions, each containing a mix of 4 Attributes of the 11 possible. Respondent checks his Most Preferred and Least Preferred from the 4 options. This exposes Respondent to at least 5 occurrences of each of the 11 attributes if 15 repetitions (questions) are employed. The matrix of combinations is obtained by Excel models on the internet for that purpose. However, the results come back as numbers and I need to convert the numbers to phrases in a list. I do not know how to do that, but believe it is best done with the use of Index/Match equations, or something equally elegant.
I would prefer a solution which would allow me to use more or fewer than the 15 sets or questions in my attached example.
Bookmarks