Calculate survey demographic weights to fix sample skew
Calculate cell-weighting factors and adjust skewed survey metrics to reflect true population demographic benchmarks.
You getWeighting Calculation Table, metric Comparison and methodology Notes
Prompt
Act as a survey statistician. Calculate post-stratification survey weights for the unweighted respondent groups below to match target population benchmarks.
Rules:
- Calculate the sampling weight for each subgroup using target proportion divided by sample proportion.
- Apply the calculated weights to the unweighted metric scores to compute the adjusted overall metric.
- Highlight any subgroup where the weight is 2.5 or higher, or 0.4 or lower, as an over-correction risk.
- Do not invent sample counts; verify arithmetic steps explicitly.
Output format:
1. Weighting Calculation Table: Subgroup, Target %, Sample %, Weight Factor, Risk Flag.
2. Metric Comparison: Unweighted Score vs. Weighted Score.
3. Methodology Notes: Two bullet points explaining the largest demographic adjustment and any variance risks.
My demographic benchmark data and sample results are below:Example output
Paste your demographic targets, actual sample counts, and key survey metrics into Claude, ChatGPT, or Gemini. As a follow-up, ask the model how trimming extreme weights would affect statistical confidence.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Translate statistical model outputs into plain business decisions
Turn regression coefficients, p-values, and confidence intervals into direct business trade-offs. Use this when presenting analytical models to non-technical executives.
Group survey feedback into clear customer themes
Turn raw, open-ended survey feedback into grouped themes with sentiment, sample quotes, and recommended operational fixes.
Rank survey satisfaction drivers by loyalty impact
Evaluate product survey touchpoints against customer retention metrics to establish clear investment priorities.
Separate true anomalies from pipeline data errors
Classify extreme values as either legitimate business events or pipeline errors. Use it when high or low metrics distort downstream reporting.
Calculate Net Promoter Score from survey data
Sort raw 0-10 feedback scores into standard groups and compute your Net Promoter Score with clear segment breakdowns.
Check survey sample size for decision confidence
Find out if your survey response count is reliable enough to make business decisions or if the margin of error is too wide.
- Audit driver-based models for compounding optimism bias
- Create an anomaly investigation checklist for analytics teams
- Normalize retention comparisons for immature recent customer cohorts
- Resolve split device identities into single user records
- Screen survey data for duplicate and low-effort responses
- Summarize weekly metric anomalies into executive briefings