Spot trends that reverse in subgroups
Prompt that checks whether an overall number looks reversed within groups and recommends the right view. Paste it into an AI tool of your choice, which then checks the subgroups.
- Topic
- Spreadsheets & data
- Type
- Prompt
- Level
- Intermediate
- Time
- about 15 min
Results depend on the tool, the model and what you enter.
Result preview
Example: written by our editors, not real AI output.
| Group | Q1 rate | Q2 rate | Share Q2 | | Mobile | 2.0 % | 1.8 % | 30 % | | Desktop | 5.0 % | 4.6 % | 70 % | | Total | 2.9 % | 3.8 % | 100 % | Reversal: total rises, both groups fall Reason: desktop share grew from 30 % to 70 % Recommendation: report group values
Fill in
What you type stays in this browser window. We store and send nothing.
- two periods
- two variants of a test
- two locations
- before and after a change
- two customer groups
- channel or source
- device
- region
- product category
- new and existing customers
- whether a change works
- where budget goes
- how to report
- whether a team performs better
- which change comes next
Your prompt
You have edited the prompt. Changes in the fields above no longer overwrite it.
This is an instruction for an AI, not the result itself.
Where this prompt works
These AI tools are a good fit for this prompt:
How to use it
- Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
- Copy the finished prompt into an AI tool of your choice.
- Paste a table with case count and result per group for both sides of the comparison, without personal data.
Why does this work?
A rate can rise overall while it falls in every group, simply because more cases come from the strong group. Anyone who sees only the total then decides wrongly.
Tips
- Have results that carry an important decision checked by a second person or a statistics adviser as well.