Skip to content
Open navigation
OpenOpen workspace

Crosstabs evidence graph

One versioned source for the short answers, formulas, workflow claims, assumptions, and limitations published to people, search engines, AI answer systems, JSON clients, and the Crosstabs MCP server.

Machine-readable contract

Every item has a stable ID, locale, topic cluster, primary answer, explicit limitations, a public page, and evidence links. The current graph version is 2026-10-28.

Read the same material as JSON or in the complete LLM reference. Named independent statistical review remains pending; automated reference cases are evidence for their tested cases, not blanket certification.

Cross-tabulation (crosstab / contingency table)

cross-tabulation · survey_workflow · en

A cross-tabulation shows the joint frequency distribution of two categorical variables: one variable's categories are rows, the other's are columns, and each cell contains a count or percentage.

Use row percentages to compare column outcomes across row groups; use column percentages to compare row composition across column groups.

Limitations

  • A crosstab describes association, not causation.
  • Very sparse or high-cardinality tables can be unstable and difficult to interpret.

Primary page · /methods · /methods/validation

Chi-square test of independence

chi-square-independence · test_selection · en

The chi-square test of independence compares observed cell counts with the counts expected if two categorical variables were unrelated.

χ² = Σ (O − E)² / E; E = row total × column total / grand total; df = (rows − 1) × (columns − 1).

A small p-value is evidence against independence; inspect effect size, cells, assumptions, multiplicity, and study design before drawing a substantive conclusion.

Limitations

  • The p-value is asymptotic.
  • Warnings appear if any expected count is below 1 or more than 20% of expected counts are below 5.
  • Fisher exact coverage is limited; larger sparse tables need an appropriate exact or fixed-margin Monte Carlo method.
  • Ordinary weighted inference is limited to a saved, validated non-negative safe-integer frequency weight with weighted test bases. Untyped, calibration, and analytic weights fail closed; sampling weights require an approved design-aware execution.

Primary page · /methods · /methods/validation · /validation/statistical-reference-cases.json

Fisher's exact test

fisher-exact · test_selection · en

For an unweighted 2×2 table of non-negative integer counts, Fisher's exact test computes the two-sided Fisher–Irwin fixed-margin p-value by summing table probabilities no greater than the observed table's probability.

Use it when an exact fixed-margin 2×2 test matches the design and sparse expected counts make an asymptotic approximation questionable.

Limitations

  • Unavailable for fractional weighted cells, larger tables, or supports above 100,000 feasible fixed-margin tables.
  • It does not solve confounding, dependence, or sampling-design problems.

Primary page · /methods · /methods/validation · /validation/statistical-reference-cases.json

Cramér's V

cramers-v · association_measure · en

Cramér's V measures the strength of association between two categorical variables on a 0-to-1 scale derived from Pearson's chi-square statistic.

V = sqrt(χ² / (n × (min(rows, columns) − 1))).

Larger values indicate stronger association; contextual and degrees-of-freedom-aware interpretation is preferable to universal cutoffs.

Limitations

  • It does not provide direction or identify the cells driving the association.
  • Weighted results inherit the table's weight-design caveats.

Primary page · /methods · /methods/validation

Phi coefficient

phi-coefficient · association_measure · en

Phi is a signed measure of association for a 2×2 table; its magnitude equals Cramér's V for that table.

φ = (ad − bc) / sqrt((a+b)(c+d)(a+c)(b+d)).

The sign depends on row and column ordering; the absolute value expresses strength.

Limitations

  • Signed phi is a 2×2 measure and should not be confused with generalized sqrt(χ²/n) for larger tables.

Primary page · /methods · /methods/validation

Pearson's contingency coefficient

pearson-contingency-coefficient · association_measure · en

Pearson's contingency coefficient is a chi-square-derived association measure whose attainable maximum depends on table size.

C = sqrt(χ² / (χ² + n)).

Limitations

  • Values from differently sized tables are not directly comparable because the maximum is below 1 and depends on shape.

Primary page · /methods

Odds ratio

odds-ratio · association_measure · en

The odds ratio compares the odds of an outcome between two groups in a 2×2 table.

OR = (a × d) / (b × c) for [[a,b],[c,d]].

OR = 1 means equal odds; values above or below 1 indicate higher or lower odds under the chosen orientation.

Limitations

  • The displayed 95% interval is the large-sample Woolf log interval, not exact.
  • A zero cell produces an uninformative [0, infinity] interval because no continuity correction is added.
  • An odds ratio is not a risk ratio except as an approximation for rare outcomes.

Primary page · /methods · /odds-ratio-vs-risk-ratio

G-test (likelihood-ratio chi-square)

g-test · test_selection · en

The G-test is a likelihood-ratio alternative to Pearson's chi-square statistic for a contingency table.

G = 2 × Σ O × ln(O / E); df = (rows − 1) × (columns − 1).

Limitations

  • Its p-value uses the same asymptotic chi-square reference distribution, so switching statistics does not solve sparse-cell concerns.

Primary page · /methods · /methods/validation

Goodman and Kruskal's lambda

lambda · association_measure · en

Lambda is a proportional-reduction-in-error measure: it asks how much knowing one categorical variable reduces errors when predicting the other.

It ranges from 0 for no error reduction to 1 for complete error reduction.

Limitations

  • A value of zero can occur even when variables are associated if knowledge does not change the modal prediction.

Primary page · /methods

Goodman and Kruskal's gamma

gamma · association_measure · en

Gamma measures ordinal association from concordant and discordant pairs while ignoring ties.

γ = (C − D) / (C + D).

Limitations

  • Ignoring ties can make the magnitude appear stronger when ties are common.

Primary page · /methods

Kendall's tau-b and tau-c

kendall-tau · association_measure · en

Kendall's tau-b measures ordinal association with tie correction and is suited to square tables; tau-c adjusts the scale for rectangular tables.

tau-c = 2m(C − D) / (n²(m − 1)), where m = min(rows, columns).

Limitations

  • Category order must be substantively meaningful and specified correctly.

Primary page · /methods

Somers' d

somers-d · association_measure · en

Somers' d is an asymmetric ordinal association measure that treats one variable as the outcome and accounts for ties on the chosen side.

Choose the direction that matches the research question; reversing outcome and predictor can change the result.

Limitations

  • It is inappropriate when no defensible dependent-variable direction exists.

Primary page · /methods

Theil's U (uncertainty coefficient)

theils-u · association_measure · en

Theil's U is an entropy-based, directional measure of how much knowing one variable reduces uncertainty about another.

It ranges from 0 for no uncertainty reduction to 1 when the predictor fully determines the outcome.

Limitations

  • Direction matters, and sparse category estimates may be unstable.

Primary page · /methods

Adjusted standardized residual

adjusted-residuals · association_measure · en

An adjusted residual standardizes a cell's observed-minus-expected difference to show which cells contribute most to a table-level association.

An absolute value above 1.96 receives a nominal two-sided 0.05 flag in the workspace.

Limitations

  • Cellwise flags are nominal and are not adjusted for multiple comparisons.

Primary page · /methods

McNemar's test for paired binary change

mcnemar-paired-change · test_selection · en

McNemar's test evaluates marginal change in paired binary outcomes by comparing the two discordant directions in a paired 2×2 table; concordant pairs do not enter the statistic.

Uncorrected χ² = (b − c)² / (b + c), df = 1; continuity-corrected χ² = max(|b − c| − 1, 0)² / (b + c); the exact two-sided result uses Binomial(b + c, 0.5).

A small p-value indicates asymmetric movement between the two categories, not the magnitude or cause of that movement.

Limitations

  • Observations must be paired, binary, and independent across subjects or matched pairs.
  • The public calculator requires non-negative integer counts and does not accept percentages or survey weights.
  • Exact binomial tails are computed for at most 10,000 discordant pairs; larger inputs are explicitly labeled as a continuity-corrected normal approximation.
  • A significant result does not by itself establish a causal intervention effect.

Primary page · /which-statistical-test · /methods · /methods/validation

t test (Welch, Student, paired, one-sample)

t-test · test_selection · en

A t test asks whether a mean, or a difference between two means, is larger than sampling noise. Welch's independent-samples test does not assume equal variances and is the default; the paired test analyses within-pair differences; the one-sample test compares a mean with a fixed value.

Welch t = (x̄₁ − x̄₂) / √(s₁²/n₁ + s₂²/n₂) with Welch–Satterthwaite df; Student t uses the pooled SD and df = n₁ + n₂ − 2; paired t = d̄ / (s_d/√n), df = n − 1.

Report the mean difference with its confidence interval and Cohen's d or Hedges' g; a small p-value alone does not show a large or important difference.

Limitations

  • Assumes independent observations and roughly normal data or moderate samples.
  • Levene and Brown–Forsythe variance tests need raw data; summary-statistic input reports the SD ratio instead.
  • Weighted survey data and complex sample designs are outside the calculator's assumptions.

Primary page · /spss/independent-samples-t-test · /methods

One-way ANOVA with Welch's F and Tukey HSD

one-way-anova · test_selection · en

One-way ANOVA tests whether three or more independent group means are equal by comparing between-group and within-group variance; Welch's F drops the equal-variance assumption, Tukey's HSD identifies which pairs differ, and η² or ω² measure the share of variance explained.

F = MS_between / MS_within with df (k − 1, N − k); η² = SS_between / SS_total; ω² = (SS_between − (k − 1)MS_within) / (SS_total + MS_within).

A significant F means not all means are equal; Tukey's adjusted p-values and intervals show which pairs differ while controlling the familywise error rate.

Limitations

  • Each respondent must belong to exactly one group.
  • Levene's test and Kruskal–Wallis are reported for raw data only.
  • Repeated-measures and multi-factor designs need other models.

Primary page · /spss/one-way-anova · /methods

Pearson, Spearman and Kendall correlation

correlation · association_measure · en

Pearson's r measures linear association between two numeric variables; Spearman's rho and Kendall's tau-b measure monotonic association on ranks. Fisher's z transformation gives the confidence interval for r and a test comparing two independent correlations.

r = Σ(x − x̄)(y − ȳ) / √[Σ(x − x̄)² Σ(y − ȳ)²]; t = r√(n − 2)/√(1 − r²); CI = tanh(atanh r ± z/√(n − 3)).

The sign gives direction and the magnitude strength; r² is the share of variance the variables share. Correlation does not establish causation.

Limitations

  • Pearson's r misses curved relationships and is sensitive to outliers.
  • Fisher's two-correlation test requires independent samples.
  • Kendall's tau p-values use the normal approximation.

Primary page · /spss/pearson-spearman-correlation · /kendalls-tau-calculator · /methods

How to choose a categorical statistical test

statistical-test-selection · test_selection · en

Choose from the design first: independent nominal groups usually imply chi-square or an exact alternative; paired binary data imply McNemar; agreement implies kappa; ordered categories imply an ordinal association measure.

Limitations

  • No decision tree can repair dependence, confounding, invalid sampling, or a mismatch between the table and the estimand.

Primary page · /methods · /methods/validation

Sparse expected cells

sparse-cells · test_selection · en

Sparse expected counts make chi-square reference approximations less reliable; inspect the pattern, consider defensible category consolidation, or use a design-appropriate exact or Monte Carlo method.

Limitations

  • Do not merge categories solely to obtain significance.
  • Fisher's exact test on this site is limited to eligible 2×2 integer-frequency tables.

Primary page · /methods · /methods/validation

Survey weighting and raking for crosstabs

survey-weights · survey_workflow · en

A weighted crosstab multiplies each eligible respondent by a positive finite weight before calculating counts and percentages, while retaining the unweighted base for diagnostics; raking creates calibration weights by iteratively matching trusted population margins.

Limitations

  • The quick workspace rejects an untyped numeric weight instead of assuming frequency semantics.
  • Saved projects can create a raked sampling weight with guided survey weighting from explicit population targets after preview and human confirmation; that weight does not authorize ordinary inference.
  • Saved tab-book projects can assign a supported Taylor-linearized or replicate-weight survey design, with explicit strata, PSU, FPC, lonely-PSU, confidence, and replicate policies plus Rao–Scott or adjusted-Wald association; unsupported or invalid designs fail closed, and independent statistical review remains pending.

Primary page · /survey-crosstab-tool · /methods · /capacity · /local-mode

Multi-select crosstabs

multi-select · survey_workflow · en

A select-all-that-apply question should become auditable option-level binary outcomes and be crossed with an independent grouping variable; report percent of cases to show each option's incidence among included respondents rather than treating combined answer strings as exclusive categories.

Percent-of-cases rows can sum above 100% because one respondent may select multiple options; percent of responses uses a different denominator and answers a different question.

Limitations

  • An omnibus Pearson chi-square across overlapping option rows is invalid; option-level binary comparisons answer a narrower question.
  • Bonferroni correction covers banner-column pairs within each option but not the complete family across options, tables, or exploratory cuts.
  • All-blank skipped sets are excluded while explicit all-zero answered cases remain in the respondent base.
  • An approved survey design uses respondent-case item estimates and separate selected/not-selected Rao–Scott tests with adjusted-Wald alternatives; response-denominator percentages remain descriptive, and independent statistical review remains pending.

Primary page · /methods · /local-mode · /crosstab-significance-letters

Crosstab significance letters

significance-letters · survey_workflow · en

Column significance letters encode pairwise column-proportion tests by labeling a cell with the columns it differs from under the configured threshold and correction policy.

Limitations

  • Small bases and multiple comparisons can produce misleading flags.
  • Untyped weighting cannot produce ordinary significance letters.

Primary page · /methods

Tracker wave schema drift

tracker-schema-drift · tracker_workflow · en

Treat each imported tracker wave as immutable: fingerprint both schemas, match stable identifiers before labels, classify structural and semantic drift, preview and approve explicit transforms, apply them to a copy, validate bases and distributions, and retain the source, audit record, and guarded inverse before comparing waves.

A successful structural repair does not prove longitudinal comparability; question wording, universe, routing, recall period, concept, and representation must still remain defensibly comparable.

Limitations

  • Automatic suggestions and label similarity are not evidence of semantic equivalence.
  • Exact reversal is refused after later project changes because restoring the old snapshot would erase subsequent work.
  • The current Workspace UI exposes compatible-wave import, rename mapping, retained waves, and comparison, but not the engine's full approval and reversal interface.

Primary page · /methods · /local-mode · /capacity · /survey-tab-book

Tab-book project model

tab-book-project · survey_workflow · en

A tab-book project keeps row sets, multibanners, filters, weights, tests, table order, waves, coding variables, findings, and the export recipe in one versioned graph rather than as unrelated outputs.

Limitations

  • A definition-only manifest intentionally omits respondent rows; it rebuilds a working analysis only when applied to a new data file, and definitions that do not fit that file are listed and skipped.

Primary page · /local-mode · /data-processing

Auditable open-end coding

open-end-coding · ai_governance · en

Crosstabs provides a browser-local manual workflow for open ends: define or reuse themes, assign responses, attest that review is complete, approve the coding, apply it as project variables, and retain decision history with a guarded undo path.

Limitations

  • The manual workflow does not send responses to a model. Optional AI open-end coding sends the answers to one chosen question through the crosstabs.com server to OpenAI only after the researcher confirms that run, and returns proposed themes and codes for review.
  • A researcher remains responsible for theme definitions, assignment coverage, approval, interpretation, and any sensitive-content handling.
  • Supplying responses to a separate AI assistant is governed by that assistant's data policy, not the Crosstabs local boundary.

Primary page · /privacy · /data-processing · /local-mode · /subprocessors

Outcome metrics and key-driver modeling

outcome-modeling · survey_workflow · en

The outcome studio fits a regularized logistic model to an explicitly selected binary outcome and drivers, then reports deterministic holdout AUC, accuracy, Brier score, calibration, observed segments, and reviewable actions.

Limitations

  • Association and prediction do not establish causality.
  • At least 60 complete rows, 25 successes, and 25 other outcomes are required.
  • Synthetic scenarios are labeled modeled estimates rather than observed evidence.

Primary page · /methods · /capacity

Editable report refresh

editable-report-refresh · reporting · en

A compatible Crosstabs PPTX or DOCX can refresh current generated values without replacing the whole edited package: stable anchors identify selected tables, metadata, statistics text, and PowerPoint charts; supported equal-shape content is patched in place while manual regions, unselected objects, and unrelated package parts remain under analyst control.

Preservation is regional, not universal: the existing Office package remains the target, and the refresh audit distinguishes updated anchors, preserved anchors, blocking reasons, and package entries that were not rewritten.

Limitations

  • Selected generated table text is replaced by current approved Crosstabs values; selected PowerPoint chart series and its embedded workbook are also replaced.
  • Equal-shape table formatting and geometry are supported, but arbitrary structural edits inside generated objects are not.
  • A missing or duplicate stable anchor, changed table shape, incompatible chart, corrupt package, or unanchored third-party file fails atomically before a modified file is returned.
  • The current Workspace Export menu refreshes the open tab-current table; it does not expose arbitrary multi-table selection or automatic schema-changing reflow.

Primary page · /workspace · /local-mode · /data-processing · /methods/validation · /survey-tab-book

Local browser analysis

local-mode · trust · en

Browser import, table computation, filters, supported survey designs, tests, project state, review, manual open-end coding, and exports run locally without uploading source files. Local MCP is a separate on-device option. Every table and statistic is computed deterministically; optional AI insights send data to OpenAI only when the person clicks an AI button.

Limitations

  • Browser memory, storage quotas, device performance, and file width can constrain work before row count alone does.
  • A full project package contains rows and is not encrypted.

Primary page · /privacy · /data-processing · /capacity

Multidimensional workload envelope

workload-envelope · trust · en

Crosstabs publishes tested workload envelopes across rows, file representation, category shape, output cells, memory, filters, weights, statistical tests, cancellation, and browser execution mode instead of claiming unlimited rows.

Limitations

  • Published fixtures are evidence for tested dimensions and environments, not a universal device guarantee.

Primary page · /capacity · /methods/validation

Evidence-linked AI analysis

ai-evidence-governance · ai_governance · en

Crosstabs computes every table deterministically; its optional hosted AI insights (OpenAI) receive only a suppression-checked table, questionnaire metadata, or, after confirmation, one question's open-ended answers, and never respondent rows. An external agent can use public evidence and bounded aggregate tools without uploading a file, or the local MCP, which keeps files on the device. Evidence validation fails closed: AI findings with numbers must quote the computed table verbatim or are dropped. Deterministic evidence, typed operations, project revisions, approval requirements, audit history, and guarded undo are distinct from model-generated interpretation.

Provider routing and model agreement can improve availability or offer another opinion, but neither validates statistical claims nor grants authority to change a research project.

Limitations

  • AI-client policies apply independently to anything shared with an assistant.
  • Exact undo is refused after later project changes because restoring the earlier snapshot would overwrite subsequent work.
  • Model providers can still make errors, and independent statistical review and third-party certification evidence remain pending where explicitly disclosed.

Primary page · /security · /privacy · /methods · /open-end-coding · /survey-tab-book

Crosstabs Codex plugin and MCP server

codex-plugin · ai_governance · en

The published crosstabs 1.5.3 package passed fresh public installation checks: 39 statistical tools, six market-research tools, database and survey-platform pull tools plus runtime status on the statistical server, and 37 local project tools including portable Plan → Validate → Run → Review workflows, explicit guided weighting preview/apply and Statistics procedures. Immutable PyPI artifacts, exact source provenance and the MCP Registry record were verified. The 1.5.0, 1.4.0, 1.3.0 and 1.2.2 evidence remains historical. Plugin source installation, native-host review and directory approval are separate states; see the exact source binding on the MCP page.

Install the local package (pip install crosstabs) and add its stdio servers to your MCP client; files remain on the device. Any AI client has its own data policies.

Limitations

  • The browser worker and local MCP enter the same HeadlessCrosstabsService and share TabBookProject, initial-analysis, deterministic calculation, project revision, audit, replay, and undo orchestration. Browser interaction and local MCP transport remain separate release-tested surfaces.
  • Package publication and source installation do not establish native-host widget review, directory submission, approval or listing.
  • The local plugin does not reproduce browser interaction state or browser-local manual open-end coding.
  • Any file supplied to an AI assistant remains subject to that assistant's data boundary and the user's configuration.

Primary page · /mcp · /methods · /methods/validation · /local-mode · /privacy

Shapley value regression vs Johnson's relative weights

relative-importance-shapley-johnson · survey_workflow · en

Shapley value regression and Johnson's relative weights both divide a regression model's R² among correlated drivers: Shapley averages each driver's R² gain over every order of entry (2^p subset regressions); Johnson's method approximates the same split in one step from an orthogonal transformation of the drivers.

Shapley_j = Σ_{S ⊆ D∖{j}} |S|!(p − |S| − 1)!/p! × [R²(S ∪ {j}) − R²(S)]; RW_j = Σ_k λ_jk² β*_k² with β* = Λ⁻¹ r_xy and Λ = VΛ^½V′ from R_xx = VΛV′.

Shares sum to 100% of the explained variance; drivers within a point or two of each other should be reported as tied.

Limitations

  • Importance is associative, not causal.
  • The relative importance tool decomposes a linear R²; it is not a logistic model for yes/no outcomes.
  • Exact Shapley needs 2^p regressions, so the tool accepts at most 15 drivers.

Primary page · /tools/relative-importance-analysis · /methods

Van Westendorp price sensitivity meter

van-westendorp-psm · survey_workflow · en

The Van Westendorp price sensitivity meter asks four open price questions (too cheap, cheap, expensive, too expensive), plots their cumulative shares, and reads the point of marginal cheapness, optimal price point, indifference price point and point of marginal expensiveness from the curve crossings; PMC to PME is the range of acceptable prices.

PMC: too cheap = 1 − cheap; OPP: too cheap = too expensive; IPP: cheap = expensive; PME: 1 − expensive = too expensive; crossings by linear interpolation between answered prices.

Limitations

  • The PSM measures price acceptance, not revenue; revenue needs the Newton-Miller-Smith purchase questions or a Gabor-Granger test.
  • Respondents whose four answers are out of order are excluded by default and counted.

Primary page · /tools/van-westendorp · /methods

Gabor-Granger demand curve

gabor-granger-demand · survey_workflow · en

The Gabor-Granger method asks purchase intent at several specific prices; the weighted share who would buy at each price is a demand curve, price × demand is expected revenue per respondent, and the tested price with the highest revenue is the revenue-maximising tested price.

demand(p) = Σ wᵢ buyᵢ(p) / Σ wᵢ; revenue(p) = p × demand(p); arc elasticity E = [(d₂ − d₁)/((d₁ + d₂)/2)] / [(p₂ − p₁)/((p₁ + p₂)/2)].

Limitations

  • Stated intent overstates purchase, so the level of the curve is optimistic.
  • No value between tested prices is assumed; competitors and features are not modelled.

Primary page · /tools/gabor-granger · /methods

NPS margin of error and significance testing

nps-margin-of-error · survey_workflow · en

Because NPS is the promoter share minus the detractor share from the same respondents, its standard error is 100 × √{[p_P(1 − p_P) + p_D(1 − p_D) + 2·p_P·p_D] / n}; two independent NPS results are compared with z = (NPS₂ − NPS₁) / √(SE₁² + SE₂²).

MOE = z × SE; n_required = z² × [p_P(1 − p_P) + p_D(1 − p_D) + 2·p_P·p_D] / MOE².

Limitations

  • The independent-samples test is not valid for a panel that answered both waves.
  • Weighted data use the Kish effective sample size; the interval covers sampling error only.

Primary page · /tools/nps-calculator · /methods

Survey data cleaning: speeders, straight-liners and duplicates

survey-data-cleaning · survey_workflow · en

Survey data cleaning flags interviews with predefined rules before tabulation and weighting: speeders below a fraction of the median duration, straight-liners with one answer across a rating grid, repeated IDs or exact duplicate rows, and interviews with too many blanks; flagged rows are listed with reasons, counted per rule and kept in an audit file.

Limitations

  • A flag is evidence of low effort, not proof; short grids can produce sincere identical answers.
  • Rules should be fixed before results are seen and applied identically to every wave.

Primary page · /tools/data-cleaner · /methods

K-means vs latent class segmentation

kmeans-vs-latent-class · survey_workflow · en

K-means assigns respondents to the nearest of k centres on standardised numeric variables and is compared across k by the average silhouette; latent class analysis fits a finite mixture model by maximum likelihood, handles categorical, ordinal and numeric indicators and missing answers, gives class membership probabilities, and is compared across class counts by BIC.

Silhouette s(i) = (bᵢ − aᵢ) / max(aᵢ, bᵢ); latent class P(yᵢ) = Σ_c π_c Π_j P(y_ij | c); BIC = −2 log L + q ln n.

Limitations

  • Both methods return the number of segments requested even without real group structure.
  • K-means drops respondents with any blank clustering variable; latent class estimation skips missing indicators under a missing-at-random assumption.

Primary page · /tools/segment-builder · /tools/latent-class-analysis · /methods

Linear and logistic regression on survey data

survey-regression · survey_workflow · en

Linear regression models a numeric survey outcome and reports B per unit of each predictor; binary logistic regression models a yes/no outcome and reports odds ratios Exp(B). A declared sampling weight changes the point estimates, but ordinary regression standard errors are not valid under a sampling design, so design-based inference needs Complex Samples procedures.

y = b₀ + Σ b_j x_j + e; log[p/(1 − p)] = b₀ + Σ b_j x_j; Beta_j = b_j s_xj / s_y; odds ratio = e^{b_j}.

Limitations

  • In Statistics mode a declared sampling weight yields weighted point estimates only; tests, standard errors and intervals are withheld, and stepwise selection is refused.
  • Cross-sectional regression adjusts for measured variables only and does not establish causation.

Primary page · /spss/linear-regression · /spss/binary-logistic-regression · /spss/complex-samples-glm · /methods

Bonferroni and Holm corrections for crosstab column tests

bonferroni-column-tests · test_selection · en

Column-proportion letters compare every pair of banner columns within a row, so the family-wise false-positive rate grows with the number of pairs; Bonferroni multiplies each pairwise p-value by the number of pairs m, and Holm's step-down procedure controls the same family-wise error rate with at least as much power.

Bonferroni p̃ᵢ = min(1, m·pᵢ); Holm p̃₍ᵢ₎ = min(1, max_{j ≤ i} (m − j + 1)·p₍ⱼ₎); m = k(k − 1)/2 column pairs per row.

Limitations

  • Crosstabs corrects across the column pairs within each row; comparisons across rows, tables and banners are not corrected together.
  • Holm, Benjamini–Hochberg or no correction can be chosen in saved tab-book projects; Bonferroni is the default.

Primary page · /crosstab-significance-letters · /survey-crosstab-tool · /methods

Design effect and effective sample size

design-effect · survey_workflow · en

The design effect is the variance of an estimate under the survey design divided by its variance under a simple random sample of the same size; the effective sample size is n / deff. For unequal weights Kish's approximation is n_eff = (Σw)² / Σw², so deff = 1 + CV² of the weights, and margins of error grow by √deff.

n_eff = (Σwᵢ)² / Σwᵢ²; deff_w = n / n_eff = 1 + CV_w²; clustering deff ≈ 1 + (m̄ − 1)ρ; MOE = z√deff √(p(1 − p)/n).

Limitations

  • The Kish design effect covers unequal weighting only; clustering and stratification need design-based estimation.
  • Each subgroup has its own effective base; one overall design effect does not fit every column.

Primary page · /margin-of-error-calculator · /survey-weighting-raking · /methods

卡方独立性检验

zh-chi-square · test_selection · zh-CN

卡方独立性检验先按行列边际计算独立假设下的期望频数,再用 χ² = Σ(O − E)² / E 汇总观察值与期望值的差异,用于判断两个相互独立观测的分类变量是否存在统计关联。

χ² = Σ (O − E)² / E;E = 行合计 × 列合计 / 总样本量。

较小的 P 值反对独立性原假设;还应报告 Cramér's V、样本基数、期望频数诊断、关键单元格和研究设计,不能把统计关联解释为因果。

Limitations

  • P 值使用渐近卡方分布;最小期望频数小于 1 或超过 20% 的期望频数小于 5 时,近似可能较差。
  • 观察应相互独立;同一对象前后两次的配对二分类表应使用 McNemar 等配对方法。
  • 输入应是互斥类别的观察频数,百分比不能替代检验所需的样本基数。
  • 本网站的 Fisher 精确结果只覆盖合格的非加权 2×2 非负整数频数表和有界工作量。
  • 设计或校准权重、分层和整群抽样需要设计型方差与 Rao–Scott 等方法。
  • 调整标准化残差是诊断量;跨多个单元格、列对、问题或表格的推断仍需定义检验族并处理多重比较。

Primary page · /chi-square-calculator · /zh-cn/which-statistical-test · /zh-cn/chi-square-expected-count-less-than-5 · /methods · /methods/validation

Crosstabs Codex 插件与 MCP 统计服务器

zh-codex-plugin · ai_governance · zh-CN

已发布的 crosstabs 1.5.3 通过了公开索引全新安装验证:统计服务器提供 39 个统计工具、6 个市场研究工具、数据库与调查平台拉取工具及运行时状态,项目服务器提供 37 个本地工具,包括可移植的计划 → 验证 → 运行 → 审阅流程、经明确批准的引导式加权预览及应用和统计过程工具。PyPI 不可变发布文件、准确源码来源和 MCP Registry 记录均已验证;1.5.0、1.4.0、1.3.0 和 1.2.2 的证据保留为历史记录。插件源码安装、原生宿主审查和目录批准属于不同状态;准确的源码绑定见 MCP 页面。

安装本地包(pip install crosstabs),并把其 stdio 服务器添加到 MCP 客户端;文件留在设备上。AI 客户端的数据政策另行适用。

Limitations

  • 浏览器 Worker 与本地 MCP 进入同一个 HeadlessCrosstabsService,并共享 TabBookProject、初始分析、确定性计算、项目修订、审计、重放与撤销编排。浏览器交互与本地 MCP 传输仍是分别测试的发布界面。
  • 包发布和源码安装不代表原生宿主组件审查、目录提交、批准或上架。
  • 本地插件不复制浏览器交互状态,也不提供浏览器本地的开放题人工编码。
  • 提供给 AI 助手的任何文件仍受该助手的数据边界与用户配置约束。

Primary page · /zh-cn/mcp · /mcp · /methods · /methods/validation · /local-mode · /privacy

McNemar 配对二分类变化检验

zh-mcnemar-paired-change · test_selection · zh-CN

McNemar 检验通过比较配对 2×2 表中两个不一致方向 b 与 c,判断同一对象前后或一一匹配对象的二分类边际比例是否发生不对称变化;一致配对 a 与 d 不进入统计量。

未校正 χ² = (b − c)² / (b + c),df = 1;连续性校正 χ² = max(|b − c| − 1, 0)² / (b + c);精确双侧结果使用 Binomial(b + c, 0.5)。

较小的 P 值表示两个变化方向不对称,不表示变化幅度,也不会单独证明变化由干预造成。

Limitations

  • 对象或匹配对之间应相互独立,且每次结果只有两个互斥类别。
  • 公开计算器只接受非负整数频数,不接受百分比、小数或调查权重。
  • 不一致配对不超过 10,000 对时计算精确二项尾概率;更大输入明确标为连续性校正正态近似。
  • 复杂抽样、失访、混杂和多时点重复测量需要适合完整设计的方法。

Primary page · /mcnemar-test-calculator · /zh-cn/which-statistical-test · /methods · /methods/validation

分类数据统计检验选择

zh-statistical-test-selection · test_selection · zh-CN

分类数据检验应从研究设计开始:独立分类变量通常使用 Pearson 卡方或适合的精确方法;合格的稀疏 2×2 整数频数表可用 Fisher;配对二分类结果使用 McNemar;对同一对象的分类一致性使用 Cohen's kappa;有序变量还应报告保留顺序信息的关联指标。

Limitations

  • P 值和关联不能单独证明因果。
  • 普通交叉表方法不适合连续结局、复杂抽样、聚类或未建模的重复测量结构。
  • 本网站的 Fisher 精确检验只覆盖合格的非加权 2×2 非负整数频数表。

Primary page · /which-statistical-test · /methods · /methods/validation · /mcnemar-test-calculator · /cohens-kappa-calculator

期望频数小于 5

zh-sparse-cells · test_selection · zh-CN

期望频数过小会削弱卡方渐近近似;应先检查稀疏分布,再考虑有理论依据的类别合并、2×2 Fisher 精确检验或适合设计的精确/蒙特卡洛方法。

Limitations

  • 不要只为获得显著结果而合并类别。
  • 本网站的 Fisher 精确检验仅适用于合格的 2×2 非加权整数频数表。

Primary page · /methods · /methods/validation

调查加权与 Raking(迭代比例拟合)

zh-survey-weights · survey_workflow · zh-CN

加权交叉表让每位合格受访者按正数有限权重贡献到单元格;应使用加权百分比表达估计,同时保留未加权样本基数用于样本量和数据质量诊断。Raking 通过迭代调整权重,使指定加权边际接近可信总体目标。

加权单元格 = Σ wᵢI(rowᵢ = r, columnᵢ = c);权重离散诊断 n_eff = (Σwᵢ)² / Σwᵢ²。

Limitations

  • 快速工作区会拒绝未声明语义的数值权重,不会把它默认为频数权重。
  • 已保存项目可通过引导式调查加权,按明确的总体目标并经预览和人工确认生成 Raking 抽样权重;该权重不会授权普通推断。
  • 已保存项目可执行受支持的 Taylor 线性化或重复权重设计,并报告分层、PSU、FPC、设计自由度以及 Rao–Scott 或调整 Wald 关联;无效或不受支持的设计会关闭失败。

Primary page · /survey-weighting-raking · /survey-crosstab-tool · /methods · /capacity

Cramér's V 效应量

zh-cramers-v · association_measure · zh-CN

Cramér's V 将卡方统计量转换为 0 到 1 的分类变量关联强度指标。

V = sqrt(χ² / (n × (min(行数, 列数) − 1)))。

Limitations

  • 它不表示方向,也不说明哪些单元格推动了关联。

Primary page · /methods · /methods/validation

多选题(可多选)交叉分析

zh-multi-select · survey_workflow · zh-CN

“选择所有适用项”应定义或整理为选项级二分类结果,再与独立分组变量交叉;通常报告基于个案的百分比,表示每个 Banner 组中选择该选项的受访者比例,而不是把答案组合当成互斥类别。

同一受访者可选择多个选项,所以基于个案的各行百分比总和可以超过 100%;基于响应的百分比使用全部选择次数作为不同分母。

Limitations

  • 不能对相互重叠的所有选项行运行一个普通总体 Pearson 卡方检验。
  • 每个选项内部的 Banner 列对使用 Bonferroni 校正,但不会跨所有选项、表格或探索性切分控制完整推断族。
  • 所有选项均为空的跳题记录默认排除;明确作答且全为 0 的个案仍保留在受访者基数。
  • 设计或校准权重下的普通列比例检验只能视为近似结果。

Primary page · /multi-select-crosstab · /crosstab-significance-letters · /methods · /local-mode

交叉表显著性字母(A、B、C)

zh-significance-letters · survey_workflow · zh-CN

交叉表中的显著性字母表示同一结果行内的成对列比例检验:每个 Banner 列先分配一个字母,某单元格中的字母标出该单元格所在列的比例显著高于哪些列。

例如 A 列单元格显示“42% B”,表示 A 列的 42% 在设定阈值和多重比较校正下显著高于 B 列同一行的比例;字母不表示差异大小、总体关联强度或因果关系。

Limitations

  • Crosstabs 对每行内所有合格 Banner 列对使用合并方差双比例 z 检验和 Bonferroni 校正;校正范围不跨其他行、表格或探索性切分。
  • 检验列合计小于 30 的列不参与字母检验;普通表超过 12 个 Banner 列或 250 个行类别时不生成字母;没有字母不等于两列相同。
  • 所选权重时不生成普通列比例字母;受支持的已保存调查设计也不会回退到普通加权列比例检验。
  • 显著性字母应与百分比、未加权基数、置信阈值、效应量和研究设计一起报告。

Primary page · /crosstab-significance-letters · /zh-cn/multi-select-crosstab · /zh-cn/survey-weighting-raking · /methods

调查追踪项目的波次结构漂移

zh-tracker-schema-drift · tracker_workflow · zh-CN

把每个导入波次视为不可变源数据:比较结构指纹,优先使用稳定内部 ID,分类记录结构与语义漂移,预览并审批明确转换,只在副本上执行,验证基数与分布,并保留来源、审计记录和受保护的逆操作后再比较波次。

结构修复成功不等于纵向可比;题目措辞、目标总体、跳转逻辑、回忆期、概念和表示方式仍须由研究人员确认。

Limitations

  • 自动建议和标签相似不能证明语义等价。
  • 项目在修复后已改变时必须拒绝精确回退,以免覆盖后续工作。
  • 当前工作区支持兼容波次导入、改名映射、保留旧波次与比较,但尚未提供底层引擎完整的审批与回退界面。

Primary page · /tracker-schema-drift · /methods · /local-mode · /capacity · /survey-tab-book

交叉表 AI 分析治理

zh-ai-evidence-governance · ai_governance · zh-CN

Crosstabs 的所有表格与统计均由确定性引擎计算;可选的托管 AI 解读(OpenAI)只接收经小格抑制的汇总表、问卷元数据,或经确认后某一道开放题的回答,从不接收受访者行数据。外部智能体可使用公开证据和有界汇总计算,或通过本地 MCP 处理只保存在设备上的私有项目。Crosstabs 把结果绑定到确定性证据,并在输入无效时默认拒绝;项目变更使用类型化操作、当前修订、本地审计记录与受保护撤销,而不把模型文字当成授权。

多模型路由或模型间一致只能改善可用性或提供另一种意见,不能验证统计结论,也不能授予模型修改研究项目的权限。

Limitations

  • 私有项目应留在浏览器或本地 MCP;交给外部智能体的任何文件仍受该智能体的数据边界约束。
  • 项目后来发生变化时会拒绝精确回退,以免覆盖后续工作。
  • 模型仍可能出错;页面明确披露的独立统计审查与第三方认证证据仍处于待完成状态。

Primary page · /ai-analysis-governance · /security · /privacy · /open-end-coding · /survey-tab-book

可编辑 PPTX 与 DOCX 选择性刷新

zh-editable-report-refresh · reporting · zh-CN

兼容的 Crosstabs PPTX 或 DOCX 可以通过稳定锚点识别选中表格、元数据、统计文字和 PowerPoint 图表,只在支持的等形生成区域内更新当前值,同时保留人工区域、未选中对象和无关 Office 包部件。

保留是按区域定义的,而不是任意往返编辑承诺;现有 Office 文件保持为目标,刷新审计分别记录已更新锚点、已保留锚点、阻止原因与未重写部件。

Limitations

  • 选中生成表格内的文字会替换为当前获批 Crosstabs 值;选中 PowerPoint 图表的序列和嵌入工作簿也会替换。
  • 仅支持等形表格的格式与几何保留,不支持生成对象内任意结构修改。
  • 锚点缺失或重复、表格形状变化、图表不兼容、文件损坏或第三方文件没有锚点时会原子失败,不会返回部分修改的文件。
  • 当前 Workspace Export 菜单刷新打开的 tab-current 表格,尚未提供任意多表选择或结构变化后的自动重排。

Primary page · /editable-pptx-docx-refresh · /workspace · /local-mode · /data-processing · /methods/validation · /survey-tab-book

可审计的开放题编码

zh-open-end-coding · ai_governance · zh-CN

Crosstabs 在浏览器本地提供开放题人工编码流程:定义或复用主题、逐条分配、确认审核完成、批准编码表、把已批准主题作为 0/1 项目变量应用,并保留决策历史和受保护的撤销。

Limitations

  • 人工流程不会把回答发送给模型。可选 AI 开放题编码只在研究者确认本次运行后,经 crosstabs.com 服务器把所选一道题的回答发送给 OpenAI,并返回待审核的主题与编码提案。
  • 主题定义、分配覆盖、批准、解释和敏感内容处理始终由研究者负责。
  • 应用后数据如有其他修改,撤销会被拒绝,以免覆盖后续工作。
  • 把回答提供给其他 AI 助手时,适用该助手的数据政策,而不是 Crosstabs 的本地边界。

Primary page · /open-end-coding · /privacy · /data-processing · /local-mode · /subprocessors

交叉表多重比较 Bonferroni 校正

zh-multiple-comparisons · test_selection · zh-CN

k 个 Banner 列两两比较共有 k(k − 1) ÷ 2 次;Bonferroni 校正把每次比较的阈值降为 α 除以比较次数,使同一组比较中至少出现一次假阳性的概率不超过 α。

m = k(k − 1) / 2;α′ = α / m;校正 P = min(1, m × P)。

Limitations

  • Crosstabs 的显著性字母默认只在每个结果行内的合格列对之间校正,不跨其他行、题目、表格或筛选切分。
  • 列基数低于 30 的列不参与检验;没有字母不证明两列相同。
  • 已保存项目的表格设计器可改用 Holm、Benjamini–Hochberg 或不校正。

Primary page · /crosstab-significance-letters · /zh-cn/crosstab-significance-letters · /methods

设计效应与有效样本量

zh-design-effect · survey_workflow · zh-CN

设计效应是实际抽样设计下估计量方差与同样本量简单随机抽样方差之比;有效样本量为 n 除以设计效应,误差范围随设计效应的平方根扩大。

Kish:deff = n·Σw² / (Σw)² = 1 + CV²;n_eff = (Σw)² / Σw²;整群:deff ≈ 1 + (m − 1)ρ。

Limitations

  • Kish 近似只反映权重不等造成的方差膨胀,不包含分层与整群,也不能代替设计型方差估计。
  • 误差范围计算器接受输入的设计效应或由权重列计算 Kish 设计效应;完整调查设计推断需要已保存项目中受支持的 Taylor 或重复权重设计。
  • 报告时应分别给出未加权基数和有效基数。

Primary page · /margin-of-error-calculator · /zh-cn/margin-of-error-calculator · /zh-cn/survey-weighting-raking · /methods

问卷表格册项目模型

zh-tab-book-project · survey_workflow · zh-CN

表格册项目把题目组、多组表头、筛选、权重、检验设置、表格顺序、波次、编码变量、发现和导出设置保存在一个有版本的模型中,而不是一组互不关联的输出文件。

Limitations

  • 仅定义清单刻意不含受访者数据行;只有应用到新的数据文件时才会重建分析,与该文件不匹配的定义会被列出并跳过。

Primary page · /survey-tab-book · /local-mode · /data-processing

问卷数据的线性回归与设计型回归

zh-survey-regression · survey_workflow · zh-CN

线性回归为数值结果给出每个预测变量的 B;声明抽样权重会改变点估计,但普通回归的标准误在抽样设计下不成立,设计型推断需要复杂抽样 GLM 的 Taylor 线性化标准误和设计自由度。

y = b₀ + Σ b_j x_j + e;设计自由度 = PSU 数 − 分层数。

Limitations

  • 统计模式中声明抽样权重时只给出加权点估计,不显示检验、标准误和区间,并拒绝逐步法。
  • 横截面回归只能控制已测量的变量,不能证明因果关系。

Primary page · /survey-regression-guide · /spss/complex-samples-glm · /methods