# Analyze survey results with crosstabs, weighting, and significance

A sound quantitative analysis of survey data, with response-bias checks, weighting, crosstabs, and only the differences that are real.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Analyze, Plan, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/analyze-survey-results-with-crosstabs-weighting-and-significance

## Prompt

```text
Help me analyze quantitative survey results correctly.

**Survey goal and key questions:** [what we want to learn]
**Sample:** [number of responses, how people were invited, response rate]
**Population benchmarks:** [known shares of the full population by key groups, e.g. region, tenure, plan - if available]
**Data:** [PASTE results or describe columns: question types (single choice, multi-select, Likert, NPS), respondent attributes]
**Segments to compare:** [e.g. new vs. long-time customers, regions]

Steps:
1. Check representativeness: compare the sample to population benchmarks and flag over- or under-represented groups. Recommend whether to weight and how (e.g. post-stratification or raking), and warn when weights get extreme.
2. Clean the data: speeders, straight-liners, duplicates, incomplete responses.
3. Summarize each key question correctly for its type: top-2-box for Likert, NPS calculation, multi-select shares that can sum past 100%.
4. Build crosstabs for the requested segments with base sizes shown. Flag cells with small bases (e.g. under 30) as directional only.
5. Test which differences are statistically meaningful, correcting for multiple comparisons, and report margins of error.
6. Summarize the findings that are both significant and large enough to matter.

Return:
- A data quality and representativeness summary.
- Crosstab tables with bases and significance flags.
- Top findings with confidence levels.
- Code outline in [Python / R / Excel] to reproduce it.

Use only the data I provide; do not invent numbers.
```

## What to fill in

- what we want to learn
- number of responses, how people were invited, response rate
- e.g. new vs. long-time customers, regions
- Python / R / Excel

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.