Correlation analysis between variables
Analyze correlations between dataset variables with business interpretation and heatmap visualization.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
J'ai un dataset contenant [NOMBRE_VARIABLES] variables : [LISTE_VARIABLES]. Le dataset comporte [NOMBRE_OBSERVATIONS] observations sur la période [PERIODE]. L'objectif est de comprendre les relations entre ces variables pour [OBJECTIF_METIER].
Réalise une analyse de corrélation complète :
- Calcule la matrice de corrélation (Pearson pour variables continues, Spearman si distribution non-normale, Kendall pour variables ordinales)
- Identifie les paires de variables avec corrélation forte (|r| > 0.7) et modérée (|r| > 0.4)
- Distingue corrélation et causalité pour les relations identifiées
- Détecte la multicolinéarité problématique pour de futures analyses de régression
- Représente graphiquement la matrice de corrélation (heatmap) avec le code approprié
- Propose des hypothèses métier pour expliquer les corrélations les plus significatives
- Identifie des variables potentiellement redondantes pouvant être supprimées
Contexte business : [CONTEXTE_BUSINESS]
Outil préféré : [OUTIL] (Python pandas/seaborn, R, Excel)
Fournis une interprétation en langage accessible pour des non-statisticiens.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
<p>The prompt is effective because it requests both technical calculation and accessible business interpretation, bridging the gap between statistical analysis and managerial decision-making. It avoids the correlation/causation trap.</p>
Use Cases
Expected Output
Annotated correlation matrix, identification of significant relationships, visualization code, and business interpretations.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt GuideComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Sora Prompt for Survey Analysis
Survey analysis is a major challenge for marketing, HR, and research professionals. With hundreds or even thousands of responses to process, extracting relevant insights manually is time-consuming and prone to interpretation bias. Sora transforms this complex task into a structured, fast process. By feeding it your raw survey data, the AI identifies statistical trends, detects correlations between variables, and synthesizes open-ended responses into actionable themes. Whether you are analyzing a customer satisfaction survey, an internal employee engagement survey, or a market study, Sora helps you move from raw data to strategic decisions. The tool particularly excels at processing qualitative responses, where it spots patterns that the human eye might miss. By combining quantitative and qualitative analysis, Sora produces comprehensive reports that directly support your decision-making.
Pivot table analysis
Perform an in-depth analysis of an Excel pivot table to extract trends and actionable insights.
Annual HR Report
HR Reporting
Web analytics metrics analysis
Comprehensive web analytics metrics analysis to understand visitor behavior and identify optimization areas.