Introduction
In this article, we look at some of the options in the Automate menu which lets you to do more with your multiple response data. The options covered in this article are:
- Automate > Browse Online Library > Create New Variables > Rebase Multiple Response Data to the NET
- Automate > Browse Online Library > Filtering > Filter One Question by Another Question
Method
Rebasing multiple response questions to the NET
Sometimes you’ll have a Pick Any (multiple response) question where the percentage in the NET is less than 100%. For example:
To rebase the file:
- Select Automate > Browse Online Library > Create New Variables > Rebase Multiple Response Data to the NET.
Building awareness or purchase into the base
It is common for researchers to want to choose a different base when analyzing Pick One – Multi questions (single response grids), Pick Any – Grid questions (multiple response grids), and other questions involving several variables. For example:
We may wish to re-base the data so that it only bases the figures only on people who indicated that they have shopped at each supermarket in the past month.
The desired bases are represented in this table:
To rebase the grid we can:
- Select Automate > Browse Online Library > Filtering > Filter One Question by Another Question
- When prompted to Select the question you want to filter, pick the Q14 – Brand Image question from the list and click OK.
- When prompted to Select the question whose categories you want to use as filters, select Q9 – Which of these have you shopped at in the past month?
- When asked if you want to split out the question by the filter categories, select No.
- When asked if you want Q to match up the filters automatically, click Yes (more on this below)
A new copy of the question is created, where the selections from Q9 are built in as “filters”. By this, I mean that people who did not select a brand are given a missing value for that brand in the new copy of the grid. The result looks like this:
Splitting up data according to brand
The same option may also be used to split up a variable which contains data for multiple brands. This is common when you pipe brands through the questionnaire. For example, you may begin by asking the survey respondent where they last shopped, and then later questions will all relate to that brand.
Such data will begin like this:
To create a new set of Likelihood to recommend variables, with one for each brand, I can do the following:
- Select Automate > Browse Online Library > Filtering > Filter One Question by Another Question
- When prompted to Select the question you want to filter, pick the Q12 – Likelihood to recommend question from the list and click OK.
- When prompted to Select the question whose categories you want to use as filters, select Q10 – Last Shop and click OK.
And the result is:
Note importantly that there is now room in the Brown drop-down menu for me to crosstab with an additional question.
The option Filter One Question by Another Question is a bit of a Swiss army knife that can do even more, but these are the two main uses.
A tip for working with the Automate menu
The Automate menu has grown to a massive size since we introduced it a few years ago, and it can be somewhat daunting to look for tools in the menu. If you are unsure if there is an automatic option for what you want to do, just type what you are interested in into the Search features and data box in the top-middle of the Q window. The QScripts and Rules section of the results will hopefully contain options that will save you a lot of time!