Introduction to Auto Category variables

An Auto Category variable generates a list of the most frequently used words or code labels from a question’s response data. Auto Category variables can be used to analyse open-ended questions or multiple response closed questions. They are often used with word clouds.

Auto category variables can help you to

  • Limit the number of codes to those with the highest number of responses. The codes may change when the data changes.
  • Create an “Other” category to group the codes that are outside the limit.
  • You can choose to remove words that add nothing to the analysis, by adding them to the list of stop words.
  • Order the codes by the number of counts
  • Set options on how to categorise words in the response

Auto category variable and word clouds

Creating an Analysis Cloud automatically adds an Auto Category variable.

  1. In the Survey Overview, open the survey required.
  2. Click Analysis Cloud  AnalysisCloudIcon.png  on the Snap XMP Desktop toolbar. This opens the Analysis Definition window to create a word cloud.
  3. In Analysis, enter the question name. This question usually contains comments given by the respondent.
  1. Click Save SaveIcon.png to save the Analysis Cloud.
  2. Click Analysis VariablesAnalysisVariablesIcon.png on the Snap XMP Desktop toolbar to show the list of analysis variables. The Auto Category variable, named AV.Q7, was automatically created when you saved the Analysis Cloud. This is shown in the list of analysis variables.

Editing the Auto Category variable

You are able to edit most of the settings in the Auto Category variable.

  1. Click Analysis VariablesAnalysisVariablesIcon.png on the Snap XMP Desktop toolbar. This opens the Analysis Variables window. All the Auto Category variables have the Method “AutoCategory Variable” in the list.
  2. Double-click the Auto Category variable that you wish to edit. This opens the Auto Category Variable Details window.
  1. If any analysis depends on the variable then the name is read-only, otherwise you can edit the name.
  2. Changing the Source question may change the name, if any analysis uses the original Auto Category variable. This creates a new Auto Category variable when you save.
  3. Limit codes sets the maximum number of codes for use, for example, a word cloud analysis will show the top 25 most commonly used words. Categories that are outside the limit codes setting appear with the category number in brackets.
  4. With Other groups the codes outside the Limit codes setting. For example, if Limit codes is 25, only the top 25 codes are shown and the remaining codes are grouped in the category ‘Other’.
  5. Select Order by counts to order the codes by the number of times they occur in the responses. You can also sort the categories by clicking on the column header.
  6. Click SaveIcon.png to save your changes.

Include or exclude categories

  1. Open the Auto Category Variable Details window.
  2. Select Change codes ch_codes to display the Include column.
Including codes in the Auto Category variable details
  1. Clear Include to exclude the code or select it to include the code in the analysis, such as a word cloud. The excluded code moves to the bottom of the list.
  2. Click Save SaveIcon.png to save the changes.

Stopping unwanted words

When a respondent enters a comment, the response often includes common words, such as ‘the’ or ‘and’. The default stop words list includes many of these words, which means they will not appear in the Auto Category variable or the word cloud. You can add your own stop words and you can also choose to include any of the default stop words.

  1. Click the Stop words button to open the Stop Words dialog where you can add stop words or allow a default stop word.
Stop Words dialog
  1. In Stop words, type any words you wish to exclude. Use spaces to separate the words.
  2. In Allow stopped words, type any words from the Default stop words that you wish to include. Use spaces to separate the words. This is only relevant when using the Default stops words list.
  3. Clear the Use checkbox if you do not want to use the Default stop words list. The default is to use the Default stop words list.
  4. Click OK to save your changes.

Options

You can choose different ways of categorizing the multiple response or open-ended questions by selecting different options.

  1. Click the Options button. This opens the Auto category Options dialog.
Auto category options
  1. In the Multi Choice section, select Separate Codes to treat each code in the response as separate, otherwise the codes are categorized as a group.
  2. Select Case Sensitive if you want the same word entered in different cases to be in a different category, otherwise make sure this is clear.
  3. Select Separate Words unless you know that there will be common phrases (e.g., zip codes) that you wish to use as codes.
  4. Select Customise Delimiters if you want to specify the delimiters.
  5. Click OK to save the options.

Creating an Auto category variable for a chart

An Auto Category Variable can also be used as the source variable for a standard chart such as a bar chart.

Create the Auto Category Variable

  1. Click Analysis Variables AnalysisVariablesIcon.png to show the list of Analysis Variables.
  2. Click New Analysis Variables Item NewSurveyIcon.png on the Snap XMP Desktop toolbar then select New Auto Category Variable from the list. This opens the Auto Category Variable Details dialog.
  3. In Name, enter a name for the Auto category variable. In this example, the name is AVQ4a as the source question is Q4a.
  4. In Source, enter the source question. When you tab off the field the label will update with the question text.
  1. In Limit codes enter the maximum number of codes. This determines the number of bars in the chart.
  2. Check Order by counts to order from the highest to lowest number of counts.
  3. Click Save SaveIcon.png to save the Auto Category Variable.

Create the Analysis Chart

  1. Click Analysis Chart AnalysisChartIcon.png on the Snap XMP Desktop toolbar. This opens the Analysis Definition dialog.
  2. In Analysis, enter the Auto Category variable name, for example, “AVQ4a”.
  3. Select Transpose.
  1. Click Apply to update the chart display. This shows a bar chart of the top 5 other items ordered.
Contents