Arte SheetsLearn. Try. Understand.

Survey Statistics & Research Design

Kish Unequal-Weight Effective Sample Size (n_eff) Formula

Calculate Kish’s unequal-weighting effective sample size n_eff = (SUM w)^2 / SUM(w^2), weighting design effect DEFF_w = 1 + CV_w^2, and efficiency n_eff / N in Excel and Arte Sheets.

Why raking or propensity weights shrink precision from nominal N to Kish n_eff

Even in an unclustered sample, post-stratification raking or inverse-propensity weighting assigns unequal weights w_i across respondents, inflating sampling variance whenever a few observations carry huge weights. Kish (1965, 1992) showed that under homoskedastic outcomes uncorrelated with weights, variance inflates by DEFF_w = 1 + CV_w^2 = (N * SUM(w_i^2)) / (SUM w_i)^2, reducing effective sample size to n_eff = (SUM w_i)^2 / SUM(w_i^2)!

Audit N = 6 weighted respondents B2:B7 = {1, 1, 1, 1, 2, 6}: total weight is SUM(w) = 12 ((SUM w)^2 = 144), while squared weights sum to 1+1+1+1+4+36 = 44. Kish effective sample size drops to n_eff = 144 / 44 = 3.2727 (weighting efficiency 3.2727 / 6 = 0.5455, or 45.45% precision loss!) with DEFF_w = 6 / 3.2727 = 1.8333. Trimming or equalizing weights to {1,1,1,1,1,1} restores full n_eff = 6.0000 and DEFF_w = 1.0000.

Kish Weighting DiagnosticSpreadsheet FormulaSample Output
Effective Sample Size (n_eff)(SUM(w))^2 / SUMPRODUCT(w, w)3.2727 (vs Nominal N = 6)
Weighting Design Effect (DEFF_w)N / n_eff = 1 + VAR_P(w) / AVERAGE(w)^21.8333
Weighting Efficiency (Eff_w)n_eff / N0.5455 (54.55% Retained)

Kish Unequal-Weight Effective Sample Size n_eff = (SUM w)^2 / SUM(w^2) Formula

Notice that Kish n_eff is completely scale-invariant: multiplying every weight by 1,000 leaves (SUM w)^2 / SUM(w^2) unchanged! Guard against negative weights or zero total weight.

=LET(w_col, B2:B7, sum_w, SUM(w_col), IF(OR(MIN(w_col) < 0, sum_w <= 0), "Invalid Survey Weights", ROUND((sum_w^2) / SUMPRODUCT(w_col, w_col), 4)))

Unequal-Weighting Design Effect DEFF_w = (N * SUM(w^2)) / (SUM w)^2 Formula

Monitor DEFF_w during survey raking: when DEFF_w exceeds 2.0 (efficiency < 50%), analysts routinely cap extreme weights at the 95th or 99th percentile and check bias-variance trade-offs.

=LET(w_col, B2:B7, n_nom, ROWS(w_col), sum_w, SUM(w_col), IF(OR(MIN(w_col) < 0, sum_w <= 0), "Invalid Survey Weights", ROUND((n_nom * SUMPRODUCT(w_col, w_col)) / (sum_w^2), 4)))

Try the example

Use the original values or change them to test your understanding.

Further reading