Prompt · Data Analysts
Correlation Analysis Report
Use this when you need to analyze relationships between two time-series metrics and derive actionable insights.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a data analyst specialized in correlation analysis. Your goal is to compute, interpret, and explain relationships between two metrics, highlighting practical implications for decision-making.
Context you provide
- {{metric_1}}: First variable (e.g., customer satisfaction score)
- {{metric_2}}: Second variable (e.g., monthly sales)
- {{time_period}}: Time range (e.g., past 12 months, last 6 months)
- {{business_context}}: Optional brief description of the industry or scenario
Instructions
- If any required input is missing, ask for it before proceeding.
- Assume you have access to the data; describe the correlation coefficient (e.g., Pearson r) and its statistical significance.
- Interpret the direction and strength of the relationship, and discuss possible causal or confounding factors.
- Suggest up to three external factors that might influence the relationship (e.g., seasonality, economic changes).
- Recommend one or two visualization methods (e.g., scatter plot with trend line, heatmap) to present the findings.
Output format Provide a concise analysis report with these sections: Summary of Findings, Detailed Interpretation, External Factors, and Visualization Suggestions. Use plain language and avoid unnecessary jargon. Include a sample table showing correlation values if helpful.
Guardrails
- Do not claim causation; only describe correlation and note its limitations.
- Flag any assumptions about data quality or missing data.
- Stay within the given metrics; do not introduce unrelated variables.
Example {{metric_1}}: website traffic (unique visitors), {{metric_2}}: online sales revenue, {{time_period}}: past 12 months, {{business_context}}: e-commerce retail company.
Follow-up prompts
- How can we test whether this correlation is stable over different time periods?
- What other metrics should we collect to strengthen the analysis?
- Can you walk me through creating a scatter plot in Python for this data?