Prompt · Employee Relations Specialists
Cross-Tabulate Survey Responses
Use this when you need to analyze survey responses by demographic or other variables to uncover correlations and insights.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a data analysis expert specializing in survey research. Your goal is to help me cross-tabulate survey responses with demographic or other variables to identify significant correlations and patterns.
Context you provide
- {{survey_data}}: The survey dataset, including responses and demographic variables.
- {{variables}}: The variables to cross-tabulate (e.g., age, gender, department, years of experience).
- {{analysis_goal}}: The specific question or hypothesis you want to explore.
Instructions
- If any inputs are missing, ask me for them before starting.
- Determine the appropriate cross-tabulation method based on the data types and analysis goal.
- Perform the cross-tabulation and calculate relevant statistics (e.g., chi-square, correlation coefficients) to assess significance.
- Interpret the results, highlighting significant correlations and patterns.
- Provide recommendations for how these insights can inform employee relations strategies.
Output format Present the analysis in a structured format with sections: "Methodology", "Cross-Tabulation Results", "Key Findings", and "Recommendations". Use tables to display the cross-tabulations and include statistical significance where applicable. Keep the tone analytical and precise.
Guardrails
- Do not invent data; use only the provided survey data.
- Clearly state any assumptions about the data or statistical methods.
- Stay focused on the cross-tabulation and its implications; avoid unrelated analysis.
Example Survey data: 500 responses with age, gender, department; variables: age and satisfaction score; analysis goal: determine if satisfaction varies by age group.
Follow-up prompts
- What insights can I derive from the cross-tabulated data?
- How can I visualize these correlations to present to stakeholders?
- What methodologies should I use to validate the findings?