Use Banner Tables to detect significant differences in your data by downloading various data files to work with offline. Compare banners across multiple questions, obtain the specific p-values, and view full details of your survey's statistical tests.

In This Article

• Exporting Banner Tables
• Working with the Export

Exporting Banner Tables

1. Click on the Banner Tables tab on the left hand tool bar.
2. Click the Add banner drop-down to add your desired banner(s)

3. Select the preferred Data Format from Show counts only, Show percentages only, or Show both counts and percentages. If Show percentages is chosen, the checkbox Percentage decimal place will appear. Choose how many decimal places to display—or round to whole numbers if preferred.

   💡 Tip: If you select Show counts, the decimal place option will be disabled—it doesn't apply to raw counts.

4. Under Significance Testing, use the sliders to set your primary and secondary confidence levels (defaulting to 95% and 90%). Then configure how significance markers are applied by selecting one of the three comparison modes:

   • Compare against total only — each banner column is compared against the Total column only; within-banner pairwise comparisons are omitted.
   • Compare within banners only — columns are compared pairwise within the same banner group only; Total column comparisons are omitted.
   • Compare against total and within banners — both total and within-banner comparisons are applied. This is the default.

   Check Show significance testing to include significance markers in your export. Uncheck it to export the data without any significance notation.

5. Check the boxes next to Top and Bottom 2 Box, Top and Bottom 3 Box, Top and Bottom 1.5 Box, and Mean to include the respective Summary Metrics in your export.

   💡 Tip: Top Box calculations apply to Slider, Progressive Matrix, Radio Button, and Smiley/Star question types only.

6. Click Run and Download to download the excel file.

Working with the Export

Once you open your exported Banner Tables, you'll find three tabs:

• Index: Click on any question or sub-question and be taken to that question's specific table in the Tables tab.

• Tables: This tab stores the data with significance testing included. The banner(s) and associated banner groups appear in columns. Scroll down to see how the respondents who fell into each split of the banner answered each survey question. Tables export in a compact layout—blank rows between data rows are removed automatically, so you don't need to filter them out by hand. Each answer's label appears directly on its data row instead of on a separate row above it.

  ⚠️ Note: If you use Excel macros with exported banner tables, they may need to be updated to work with the new table formatting.

• Legend: View the notation and color keys.
  • Cells with uppercase letters show that there is a significant difference at the primary confidence level selected (in this case, 95%). The significantly higher cell is shaded in dark teal.
  • Cells with lowercase letters show that there is a significant difference at the secondary confidence level selected (in this case, 90%). The significantly higher cell is shaded in light teal.

Here's what that looks like in practice:

⚠️ Note: When significance testing is included, tables stay compact. If a question has a significant result, letter codes appear directly under the relevant answer row, and the Significant Differences label appears once, near the top of that question's answers—not repeated for every answer option.