In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Correlation, Causation and Confounder Check
Prompt
The claim or pattern I found: {{CLAIM}}
Variables, how each was measured, and the time order between them: {{VARIABLES_AND_TIMING}}
The data's scope: who or what is included and excluded, and the period: {{DATA_SCOPE}}
What decision might follow if the claim is true: {{DECISION_AT_STAKE}}
Evaluate it like a referee:
1. Restate the claim as a testable statement and the evidence it rests on.
2. List alternative explanations: reverse causation, a common cause (confounder), selection or survivorship in who is in the data, chance with many comparisons, seasonality or trend shared by both series, and measurement artefacts. For each, say what in my description makes it more or less likely, and name the data I could check.
3. Identify the weakest link in the argument.
4. Suggest checks I can do in a spreadsheet: split by subgroup, compare before and after, control for the likely confounder, look at the scatter plot instead of the coefficient.
5. Say what kind of evidence, such as a controlled test, would be needed to support a causal claim, and what wording is fair if I only have correlation.
Do not provide numbers I haven't given you. Be direct if the evidence is thin.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Correlation, Causation and Confounder Check” is a free prompt for ChatGPT in the Reasoning & Problem-Solving category, 210 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{CLAIM}}, {{VARIABLES_AND_TIMING}}, {{DATA_SCOPE}}, {{DECISION_AT_STAKE}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 5 times.
Browse all Reasoning & Problem-Solving prompts, the AI prompt database or use the AI prompt finder to search every prompt.