Survey analysis prompt

What most people type

I have 400 customer survey responses (rating 1-5 and a comment). how should I analyze them and what should I report to my boss?

It works, but the AI has to guess your survey topic, decision or goal and boss's data familiarity, so the first answer usually needs another round. The version below asks for exactly what a professional would deliver.

Give me a practical plan to analyze 400 customer survey responses and report the results to my boss. Each response has a 1-5 rating and a free-text comment.

Context: [what the survey is about, e.g. product, service or support experience]. My boss will use the results to decide [decision or goal]. [Boss's familiarity with data, e.g. non-technical]. I'm working with [tool, e.g. Excel, Google Sheets, Python].

Cover:
1. Data prep: cleaning and checking the data, and handling blank or duplicate responses.
2. Rating analysis: the key numbers to calculate, such as the score distribution and average, and how to show uncertainty given 400 responses. Also any comparisons by [segments, if available, e.g. product, date, customer type].
3. Comment analysis: how to code the comments into themes and sentiment by hand or with a tool, how to link themes to ratings, and how to pull representative quotes.
4. Report for my boss: a one-page structure with the headline finding, 3-5 key insights, supporting charts (suggest the chart type for each), limitations of the data, and recommended actions.

Keep it concise and step by step. Don't invent any results. Where a method depends on my tool or goal, give a short option for each.

Replace the [brackets] with your details before you send it: decision or goal, Boss's familiarity with data, e.g. non-technical, tool, e.g. Excel, Google Sheets, Python, segments, if available, e.g. product, date, customer type.

Why this version works

• Turned vague question into structured analysis plan. Covers prep, ratings, comments and reporting in order.
• Added placeholders for goal, tool, segments. Advice depends on these unknowns.
• Specified boss-report contents. Gets a usable summary, not generic tips.
• Noted uncertainty and no invented results. 400 responses limit what conclusions are safe.

What a professional survey analysis prompt covers

• Quantitative and theme analysis steps
• Report structure for a manager
• Asks for visuals or table suggestions

Best AI model for this prompt

This is a everyday task: needs sound analysis method advice, but no heavy calculation or code. You don't need the most expensive model. The cheapest model at each company that handles it well:

Pay-per-use list prices for this prompt and its expected answer (about 800 tokens). On a monthly chat plan, the same choice shows up as more messages before you hit your limit. See today's AI prices.