Have an idea?

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

Best way to analyze/manipulate Sawtooth data output for Case 2 BWS experiment?

What is the best way to format/manipulate Sawtooth data output to conduct MNL modeling on a Case 2 BWS experiment that was constructed using the MaxDiff Set with prohibitions amongst levels of each attribute to set-up the design?
asked Nov 8, 2017 by ZachD (120 points)

1 Answer

0 votes
If you've set up "conjoint-style" prohibitions in the MaxDiff study, you'll note that this gives you the proper design for BW Case 2.  But, the attributes aren't in the right order each time (the attribute order is randomized across tasks).  For example, if you always want a full-profile product shown to respondents in the order: Attribute 1, Attribute 2, Attribute 3, etc. you'll need to export the design from Lighthouse Studio to .CSV and then re-arrange the columns per attribute so that the lower index item numbers appear before higher index item numbers in the task layout.  After manipulating the .CSV file to re-arrange the item numbers per task, re-import the design to overwrite the old design.  Test the design again using Lighthouse Studio's test design feature.  The one-way frequencies, two-way frequencies should be the same as before.  But, now the items are in different positions in the task from before (they're always sorted in a given order according to the order you wish to display the attributes for the conjoint profiles).

Now, you may or may not find that the look of the question is exactly how you want it to be.  There are automatic reformatting options in Lighthouse Studio for changing around the look of your MaxDiff task.  But, if you cannot get it to look just like you want it, you can program a "custom free-format MaxDiff" question using your own HTML skills via Lighthouse Studio's Free Format questions.  There is documentation in Lighthouse Studio MaxDiff area regarding creating advanced questionnaires that use Free Format layouts.

Now, you're ready to field and analyze.  Nothing additional or tricky needed for the analysis past what you normally do for any regular BW Case 1 questionnaire.
answered Nov 8, 2017 by Bryan Orme Platinum Sawtooth Software, Inc. (154,405 points)
Thank you so much for your advice. I was able to export the design and sort appropriately. One and two-way frequencies are the same and positions are now fixed per attribute.