Assess Panel Attrition and Follow-Up Comparability

Trace the baseline cohort through follow-up, assess selective loss, and define the population supported by paired-change analysis.

Your Prompt

Also open in:GeminiCopilotThese open empty, so paste the prompt in.
What You Need
Provide cohort eligibility, linkage validation and participation dispositions, safe retained/lost baseline summaries, outcome definitions, design and any weights.
Choose This Prompt When
Use this when the same units are intended to be followed over time. Choose Compare Baseline vs Endline Results for the round comparison, and missing-data treatment planning for item-level analytical choices.

Describe your goal, audience, available information and constraints. Your words are added to the prompt as supplied. You can also use the guided fields below.

Kept in this tab while you work. Copy and Start includes this description.

Copy this prompt and paste it into your AI chat to start. If it needs source material, the AI will ask for it.

Evidence and applicability: use only supplied evidence for values, participant dispositions, completed procedures and approvals. Cite source labels and row, table or section references. Separate observed facts, calculations, assumptions and proposed actions. Preserve conflicting claims and their provenance; mark unresolved facts unknown rather than treating missing documentation as proof an activity did not occur. Do not invent data, permission, validation, authority or execution. Statistical adjustment does not itself establish representativeness, remove bias or demonstrate causal impact.

Request only material the user is authorized to share. Prefer safe aggregate tables and a nonidentifying linkage or variable-status summary. Do not request names, contact details, direct identifiers, linkage keys or sensitive case histories. Suppress or combine unsafe small cells under the applicable disclosure rules; if those rules are unknown, flag disclosure review before releasing subgroup detail.

Use only material supplied in this conversation. Ask for missing essential inputs before making panel-specific findings, and continue the supported parts. Needed: the target population and intended paired-change quantity; baseline cohort definition and eligibility; follow-up dates and eligibility rules; documented linkage method, validation status and counts of unique matches, ambiguous matches and unmatched records; participation dispositions with sources; safe baseline summaries for retained and lost units; outcome definitions and measurement changes; sampling design, any actual weights, and replenishment rules. Counts or summary tables support only the checks they contain. A statement that records were matched does not establish valid one-to-one linkage; a file name alone supplies no data.

Assess panel attrition and follow-up comparability before interpreting paired change. Keep the work focused on longitudinal selection and the population represented by repeated observations.

  1. Establish whether the rounds track the same units, are repeated cross-sections, or remain unclear. Do not call unmatched cross-sections a panel or silently match people. Record the supplied linkage evidence, duplicate/ambiguous cases and unresolved identity checks. If linkage cannot support pairing, withhold paired estimates and specify the verification needed; retain supported round-specific descriptions separately.
  2. Build a baseline-to-follow-up flow table. Show the original baseline cohort, documented exclusions or eligibility changes, follow-up eligible units, successfully linked respondents, known nonrespondents by supplied disposition, unknown dispositions, and any new or replenishment units separately. Do not infer exclusion or consent from missing records. Show source references, counts, denominators and formulas for retention/attrition rates. If eligibility definitions differ, report the resulting denominator alternatives rather than quietly removing losses. Mark overlapping or unreconciled counts; do not force a balanced flow by inventing a category or value. For multiple waves, distinguish loss since baseline, wave-specific nonresponse and return after a missed wave where documented.
  3. Compare retained and lost baseline units on available baseline outcomes and covariates, overall and by relevant arm, cluster or subgroup only when safe and supported. Show the number observed and missing for each baseline variable and state whether summaries are weighted. Calculate differences only from sufficient inputs; tests or standardized differences require their actual ingredients and design support. Unequal observed profiles can signal selection concerns; similar profiles, a high retention rate or nonsignificant tests do not prove absence of attrition bias. Reasons for loss are reported dispositions, not necessarily verified explanations of outcome differences.
  4. Define the supported paired analysis population and denominator for each outcome. Distinguish linked participation from having comparable nonmissing outcomes at both rounds. Separate item missingness, unit attrition, measurement changes and replenishment. New participants cannot replace lost participants in an individual paired-change estimate. Explain how inference about retained pairs differs from inference about the baseline cohort or target population. Do not assign zero change or zero outcomes to those lost, infer their outcomes from retention counts, or interpret before/after change as program impact.
  5. Provide an attrition response and sensitivity decision table: concern, evidence, candidate action, assumptions, required inputs, feasibility, diagnostic checks and unresolved decision. Consider transparent retained-pair reporting and design-appropriate sensitivity scenarios. Weight adjustment or outcome imputation is conditional on defensible models, observed predictors, support, design variables and specialist review where needed; never create inverse-probability weights automatically or claim they correct unobserved selection. Any bounds or outcome-shift scenario must use documented outcome limits or explicitly user-approved hypothetical assumptions, remain separate from observed results, and state the target quantity. Do not fabricate adjusted estimates, uncertainty or completed sensitivity runs.
  6. Finish with a concise disclosure note stating cohort and paired denominators, linkage limitations, losses and eligibility changes, new entrants, observed retained/lost differences, unobserved-outcome uncertainty and the limits on generalization. List prioritized verification requests and decisions for the responsible analyst, with owners only if supplied.

Output: a panel-status statement, referenced flow table with arithmetic, retained/lost comparison or a precise statement of what cannot be calculated, outcome-specific paired-population table, conditional adjustment/sensitivity decision table, and disclosure note. Label each item observed, calculated, proposed or unresolved. This is diagnostic advice, not permission to relink records, recontact participants or change the approved analysis.

Share only authorized, nonidentifying summaries. Remove names, contact details, direct identifiers and linkage keys; protect small cells and sensitive information.