UPCOMING WEBINAR: Faster (and better) survey analysis 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 Structure. 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.
Please note these steps require a Displayr license.
Method
General filtering method
- Anything > Filter > Filter One Variable Set by Another
- If you desire, click Switch Rows and Columns from the object inspector.
- If you wish to modify the spans, often the easiest approach is to right-click and select Reset, rearrange the rows or columns as you wish, select the rows or columns you wish to group, and select Create Span.
- By default, Displayr will only perform comparisons between columns with overlapping samples in Nominal - Multi questions such as the one above, and also in grid questions. Thus, in the example above, Displayr 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 clicking on Appearance > Significance > Advanced from the object inspector and:
- Changing Test Type > Proportions to Survey Reporter Proportions.
- Changing Column Comparisons > Overlaps to Dependent.
- Clicking Apply to Selection.
- If you need to compare across spans, you can either:
- In Appearance > Significance > Advanced uncheck Column Comparisons > Recycle column letters.
- Next, click a column in the table, and from the object inspector, go to Significance > Advanced and tick Column Comparisons > All columns, and follow the prompts that appear to change further statistical assumptions.
- Override all the testing using How to Apply Independent Samples Column Means and Proportions Tests to a Table. 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, you can create a variable with all relevant filtering variables, use the method described above, and delete any columns that are not required.
Stacking
- Stack the data, so that each product is on top of the other product (see How to Stack Data in Displayr).
- Modify the Labels 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, 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.