What are the use cases for this prompt?

This prompt can be used for: Analyze a Survey.

What is the difficulty level and which AI tool should I use?

This prompt is intermediate level. It works with chatgpt.

Are there variants of this prompt?

Yes, 3 variants are available: Beginner, Intermediate, Advanced.

📊Analyse de donnéesIntermediateChatGPT

ChatGPT Prompt for Analyzing a Survey

Survey analysis is a crucial step for transforming raw data into actionable insights. Whether you collected responses via Google Forms, Typeform, or any other tool, ChatGPT can help you identify trends, segment respondents, and draw relevant conclusions in minutes. Where an analyst would spend hours cross-referencing variables and writing a report, AI significantly speeds up the process while maintaining methodological rigor. This prompt is designed to guide ChatGPT through a structured analysis of your survey results: synthesis of quantitative data, interpretation of open-ended responses, identification of significant correlations, and formulation of concrete recommendations. It works equally well for a customer satisfaction survey, a market study, or an internal questionnaire. The proposed approach combines descriptive statistical analysis and thematic qualitative analysis, offering you a complete and nuanced view of your results without requiring advanced data science skills.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

You are a data analyst specialized in quantitative and qualitative studies. I will provide you with the results of a survey. Analyze them following this methodology:

Overview: Number of respondents, completion rate, collection period, and general demographic profile.
Quantitative analysis: For each closed-ended question, calculate response percentages, identify the central tendency and notable values. Present results in summary tables.
Qualitative analysis: For open-ended questions, group responses by recurring themes, quantify the frequency of each theme, and quote 2-3 representative verbatims per theme.
Cross-tabulations and correlations: Identify significant links between variables (e.g., satisfaction by age, usage by profile). Report only relevant correlations.
Points of attention: List weak signals, surprising results, or inconsistencies in the data.
Recommendations: Formulate 5 actionable recommendations ranked by priority, each justified by the data.

Adapt your level of detail to the sample size. Be factual and clearly distinguish facts from interpretations.

Here are the survey data:
[PASTE YOUR DATA HERE]

Personalize this prompt with Léa

Answer 3 questions and Léa tailors the prompt to your situation.

Why this prompt works

This prompt is effective because it imposes a structured six-step analysis methodology, preventing ChatGPT from producing a superficial summary. Assigning the role of a data analyst activates the model's statistical knowledge, while the explicit distinction between facts and interpretations reduces hallucinations. The request for verbatims and tables forces an output grounded in actual data rather than generalizations.

Use Cases

Analyze a Survey

Variants

Expected Output

You will get a comprehensive analysis report with percentage tables for each question, a thematic mapping of open-ended responses illustrated with direct quotes, and a list of correlations between variables. The report concludes with prioritized recommendations directly actionable by your team.

Frequently Asked Questions

What format should I provide my survey data in to ChatGPT?

The most effective format is a CSV table or a copy-paste from a spreadsheet, with column headers matching the questions and each row representing a respondent. If your survey is too large, export a statistical summary from your tool (Google Forms, Typeform, SurveyMonkey) with percentages per question. For open-ended responses, a simple list is enough. Avoid screenshots: ChatGPT analyzes raw text far better than images of charts.

Can ChatGPT analyze a survey with hundreds of responses?

ChatGPT can efficiently process survey data, but its context window has a limit. For fewer than 200 responses, paste the raw data directly. Beyond that, two approaches: either export aggregated statistics (percentages, averages) from your survey tool, or break the analysis down by question blocks. For very large volumes, provide pre-calculated cross-tabulations and open-ended responses separately. The key is that ChatGPT has access to the key figures to produce a reliable analysis.

Are the survey analyses produced by ChatGPT reliable?

ChatGPT excels at qualitative synthesis, thematic grouping, and formulating recommendations, but it doesn't replace statistical software for complex calculations. It can make arithmetic errors on large datasets. Best practice is to verify the key percentages it states, cross-reference its conclusions with your field knowledge, and use it as an analysis accelerator rather than a single source of truth. For advanced statistical tests (chi-squared, regressions), prefer a dedicated tool like Excel, R, or Python.