Complete AI Training

Prompt · Data Analysts

Correlation Analysis Report

Use this when you need to analyze relationships between two time-series metrics and derive actionable insights.

All 18 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

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

  1. If any required input is missing, ask for it before proceeding.
  2. Assume you have access to the data; describe the correlation coefficient (e.g., Pearson r) and its statistical significance.
  3. Interpret the direction and strength of the relationship, and discuss possible causal or confounding factors.
  4. Suggest up to three external factors that might influence the relationship (e.g., seasonality, economic changes).
  5. 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?