Crosstabs involving Pick One - Multi and grid questions can be difficult to read, and have limited options (e.g., often no Statistics - Below or Statistics - right). Usually, the easiest solution is to restructure the data by changing the Question Type. However, in some situations, it can be useful to construct an output that looks more like a banner has been used (e.g. when conducting sensory tests or concept tests, where there is a need to compare ratings by demographics).
This article describes how to create banner tables using pick one - multi or grid questions.
Method
General filtering method
- Automate > Browse Online Library > Filter > Filter One Question by Another.
- If you desire, right-click on a column or row and select Swap Rows and Columns.
- If you wish to modify the spans, often the easiest approach is to right-click and select Revert, rearrange the rows or columns as you wish, select the rows or columns you wish to group, and select Create Span, using Find/Replace to tidy things up.
- By default, Q will only perform comparisons between columns with overlapping samples in Pick One - Multi in questions such as the one above, and also in grid questions. Thus, in the example above, Q will not, by default, compare between the data for males and females, even if they are within the same span (as they have no overlapping data). However, you can perform such comparisons by selecting the relevant tables and using Edit > Table Options > Statistical Assumptions and:
- Changing Proportions to Survey Reporter Proportions.
- Changing Overlaps to Dependent.
- Pressing OK.
- If you need to compare across spans, you can either:
- In Statistical Assumptions uncheck Recycle column letters. Next, select Comparisons... from the Table Context Menu check Compare all columns, and follow the prompts that appear to change further statistical assumptions.
- Override all the testing using Significance Testing in Tables - Independent Samples Column Means and Proportions Tests. However, this approach will generally have lower statistical power, by assuming paired data is independent.
Other filtering methods
In situations where there is a need to use different combinations of variables for different columns, some options are:
- First, create a variable with all relevant filtering variables, use the method described above, and delete any columns that are not required.
- Filtering - Apply Filters to Columns or Rows, which will allow you to create manually create filters, one-by-one.
Stacking
- Stack the data, so that each product is on top of the other product (see Stacking Data Files).
- Modify the Value Attributes of the variable called observation at the end of the stacked data file (e.g., if you have stacked the data to put products on top of each other, then you will give the name of the first product as the Label of the first product, etc.).
- Create a Banner question, using observation and any other required variables.
- If many of your analyses do not require the data to be stacked, set up using Multiple Data Files.
Note that while this method is most flexible in terms of quickly creating and modifying tables, any statistical testing will assume that the samples are independent, even when they are not.
Next
How to Change Q's Default Statistical Assumptions When Setting Up Projects