A 'top 2 box' score is the total of the top two categories in a table. For example, in a five-point scale measuring brand attitude as per the example below, the top 2 box score is the sum of the proportion to "Like" and to "Love". The same would apply to any scale, such as an agreement scale or a numeric scale (eg: 1-10).
You can create 'Top 2 box' scores in Q in a number of ways, as outlined below. The same logic is applicable when creating 'top box' or 'bottom box' involving any number of categories (eg: 'bottom 3 box').
This article describes how to go from the table above, to a table showing the combined top 2 box categories, in this case the 'Like' and 'Love' categories:
Requirements
A data file containing a Pick One, Pick One - Multi or Numeric question with scaled values (agree/disagree, 1-10 scale, etc.).
Methods
Creating a top 2 box on a table
The most direct way for creating a Top 2 Box score in Q is through merging categories or creating NETs on a table. Using the following table as an example, drag and drop the second box response (Agree a little) onto the top box response (Strongly agree):
Once one category is placed over another, the word “Merge” appears.
Q will automatically name your merged categories as “Strongly agree + Agree a little”
You can also rename the category to whatever your heart desires. To do so, right-click on the category name, select Rename, type in the desired text, and click OK.
If you want to show the individual categories as well as the Top 2 Box score on one table, you will need to create a NET. This can be accomplished by selecting the 2 categories (by holding down the CTRL or SHIFT key), right-clicking, and then selecting Create NET.
Creating a top 2 box by restructuring the data
The other means for creating a Top 2 Box score is to restructure the data as a Pick Any (multiple response) question. The Pick Any question type allows you to tell Q to only count particular responses – in this case, to only count people in the top 2 categories. This approach makes it easier to create crosstabs which include top boxes for several items.
To do so:
- Right-click on a table showing your question.
- Find the name of the question in the context menu.
- Select Restructure Data > Multiple Categories (Pick Any).
- When prompted, make sure the top 2 categories are selected in the Count This Value column and click OK.
The question will now only display the Top 2 Box score when loaded to the Outputs tab.
Automated solutions
Q’s Online Library features some tools for creating top boxes in an automated way. This is helpful when you have a lot of different questions to work through. You can find options for creating top and bottom boxes in the Create New Variables section and the Modifying Data section of the Online Library.
The option Create New Top 2 Category Variables (That is, Top 2 Boxes), creates new variables that show Top 2 Box scores for Pick One and Pick One – Multi questions. Summary tables for these new questions will be listed under a new folder within the report tree. Categories that look like Don’t Know options will not be included in the top boxes. When Q identifies one of these categories, the script gives you the option to remove them. To use this option:
- Select Automate > Browse Online Library > Create New Variables >Top 2 Category Variable(s) (Top 2 Boxes).
- At the first prompt, choose between Q limiting your choices to questions it has identified as scales or presenting you with the full question list.
- Choose questions to create top boxes for. Hold down the SHIFT or CTRL keys to make multiple selections. Click OK.
- Q will now generate a new folder within your report tree called Top 2 category variables and generate summary tables for each of the newly created questions.
To add top box NETs, you can instead use the option Add Top K Category NETs. You will be presented with the same choices, with one additional choice to specify the number of top categories you wish to combine. That is, you can use this same tool to make top 3 boxes, and so on.