Prompt
Replace [OUTCOME VARIABLE], [SEGMENT VARIABLE(S)], and [N] with your own column names and threshold.
Setup
Code execution must be enabled for step 4’s verification to run. It’s on by default for Team and Enterprise accounts. Free, Pro, and Max users: enable it under Settings > Capabilities.How it works
1
Cross-tabulate
Compares your outcome variable across each segment. Rating-scale outcomes return a mean and full distribution. Categorical outcomes return counts and row percentages.
2
Exclude non-responses
Missing, blank, and non-response values, including markers like “SKIPPED”, are dropped before any calculation runs. This is explicit in the prompt, not left to default handling.
3
Flag thin cells
Any segment cell below your threshold (e.g., 10 respondents) is flagged, including cells with zero respondents. The total flagged count is computed from the full table at once, not assembled from parts.
4
Independent verification
Every number is recomputed using a genuinely different method before it’s reported. Re-running the same calculation doesn’t qualify as a check.
5
Plain-language summary
2–3 patterns, with explicit notes on which differences are meaningful versus likely noise given the sample size.
6
Exportable table
The final table is saved as a downloadable image, formatted for quick reading.
Verify your own results
The built-in checks catch a lot, but spot-check before you publish or present:- Do group sizes add up? Sum the segment counts and compare to your full dataset.
- Does at least one number match a manual check? Run a filter or pivot table on one percentage or mean.
- Are any segments very small? Treat anything reported for them as unreliable, even if not explicitly flagged.