Survey Cross-Tabulation in Excel
Compare groups with percentages and caution.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Plan a cross-tabulation of survey results. Questions and groups to compare: [QUESTIONS_GROUPS]. Number of respondents and how they were sampled: [SAMPLE]. Show how to build the pivot or formula-based table of counts and column percentages, add totals, and handle blanks. Provide a simple way to flag small cell counts (for example fewer than 20) and to avoid over-reading them. Explain in plain language a chi-square test for the table and where Excel can compute it, and mark statistical points that need checking with a statistician [VERIFY]. Add a template for writing results that mentions the sample, the percentage differences, and the limits. Add a section on weighting when the sample does not match the population, explained in plain terms with a warning to seek help from a statistician if decisions depend on it [VERIFY]. Add a short guide to labelling tables clearly with the question text, the base (who answered), and the date of collection, so that figures cannot be misread later.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.
See an example result (fictional data)
Invented table: Satisfied with service by age group (n=300) Age | Satisfied | Not satisfied | Total | Satisfied % 18-34 | 80 | 40 | 120 | 67% 35-54 | 70 | 30 | 100 | 70% 55+ | 55 | 25 | 80 | 69% Small cells warning: any cell under 20. Sentence for report: 'Satisfaction was similar across age groups (67 to 70 percent); differences are small relative to sampling error.' Reporting rule: show n for each group, and give the date of data collection and how respondents were recruited, so readers can judge the limits.
Illustrative only, made-up data. Your results will differ and must be reviewed.