Have an idea?

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

MBC Counts analysis for 1 menu screen/task containing 85 check/no check items

I am considering a study using Sawtooth MBC software. My client has decided to present respondents with a build-your-own exercise consisting of 1 menu screen/task containing 85 items with checkboxes (the items will be organized into feature type groups to make the task at least a bit easier for respondents). So all respondents will see the same one menu screen/task and select which of the 85 items they wish to purchase (they can select as few or as many items as desired). The price of each of the 85 items will not be shown (so price variation per item will not be part of the study).

For analysis, the client is only interested in counting analysis ā€“ that is, knowing the top 100  combinations of menu items selected by the largest number of respondents. Can Sawtooth MBC software conduct this counting analysis for this 1 screen menu task with 85 items? If so, are there any references for steps to follow (Iā€™m new to MBC software) ā€“ such as exactly how to format input data and obtain count of respondents selecting top combinations?

The client would also like to segment respondents based on the combinations they select in the build-your-own exercise. Is there an approach Sawtooth would recommend to do this using Sawtooth tools?

Thank you.
asked Sep 16, 2016 by anonymous

1 Answer

0 votes
We appreciate your interest in MBC software.  But, honestly, such a counting analysis is so straightforward in other software tools that you may already have on hand that it doesn't seem to make much sense to invest in MBC software with its accompanying subscription fee.

However, if you already have access to MBC software, then it is quite straightforward to do combinatorial counting analysis for your project.  

The .CSV format (you can prepare this in Excel and just save to .CSV format) is:

CASEID, Choice1, Choice2, etc....Choice85

One row per respondent (since each respondent only completed one menu task, there is just one row per respondent for your study).

Make the ChoiceXX variables be coded as (1=chosen; 2=not chosen).

Open the .CSV file within MBC software.  Define all variables on the variables tab as Dependent Variables.  And, for each dependent variable (sorry, you have to do this by selecting each dependent variable one-at-a-time on the varibles tab) click that category 2 is the "Offstate" category.

Next, go to the Counts tab and click the option for "most frequently chosen combinations" and specify that it should report to you the top 100 combinations.

Hope this is clear and easy!
answered Sep 19, 2016 by Bryan Orme Platinum Sawtooth Software, Inc. (191,140 points)
Thank you for the very helpful answer.