Manuel B. Garcia

Manuel B. Garcia serves as the Senior Director for Educational Technology and Digital Learning at FEU Institute of Technology, Manila, Philippines. Read More

Contact Info

1607, FEU Tech Building,
P. Paredes St, Sampaloc,
Manila, Philippines
mbgarcia@feutech.edu.ph

Follow Me

Should You Preregister Data Exclusion Rules Before Analysis?

Decisions about excluding observations can materially affect research findings. Learn which data exclusion rules should be prespecified, how to distinguish errors from valid unusual values, and how to document exclusions that become necessary after data collection.

1127
Preregistering Data Exclusion Rules Guide 1127 of 1272
01 · The Question

Should You Decide Which Data to Exclude Before Examining the Results?

You have completed data collection and are preparing your dataset for analysis. Some participants have incomplete responses, several observations appear unusually high, and a few records contain values that seem impossible. Should you exclude these observations? More importantly, should the rules for making those decisions have been established before you examined the data?

Data exclusions can be necessary for valid analysis. However, they can also change estimated effects, statistical significance, and the population represented by the findings. When exclusion decisions are made after researchers know how those decisions affect their results, it becomes difficult to distinguish legitimate data-quality procedures from selective analysis.

Preregistering exclusion rules can reduce this ambiguity, but it requires careful distinctions between invalid data, unusual yet valid observations, missing measurements, and participants who do not follow the intended research procedures.

02 · The Short Answer

Yes, Prespecify Consequential Data Exclusion Decisions

In Brief

You should generally preregister data exclusion rules for confirmatory analyses, particularly when excluding participants, observations, or measurements could materially affect the study's findings. Define the conditions for exclusion, how those conditions will be identified, when the rules will be applied, and whether excluded observations will remain available for sensitivity analyses.

Not every data problem can be anticipated. Unforeseen exclusions may be justified, but they should be documented transparently, with attention to whether the decision was influenced by observed outcomes. Unusual observations should not automatically be treated as invalid.

03 · What You Need to Know

How to Prespecify Data Exclusion Rules Without Introducing Bias

What Is a Data Exclusion Rule?

A data exclusion rule specifies when a participant, observation, measurement, or record will be omitted from a particular analysis.

Such rules may address duplicate records, confirmed measurement errors, invalid responses, technical failures, implausible values, or other circumstances that prevent data from being interpreted as intended.

Importantly, exclusion is not necessarily an all-or-nothing decision. A participant may contribute valid baseline information but have an invalid measurement at one follow-up occasion. Removing that measurement does not automatically justify removing the participant's entire record.

The appropriate unit of exclusion should therefore be specified.

Participant-level exclusion Removing an entire participant from a specified analysis population.
Observation-level exclusion Removing a particular measurement, response, trial, or record while potentially retaining other valid information.

Preregistration should explain which type of exclusion applies and why the resulting analysis remains appropriate for the research question.

Why Should Data Exclusion Rules Be Established in Advance?

Researchers often have several defensible ways to prepare the same dataset. They may choose different outlier thresholds, apply alternative missing-data procedures, remove incomplete records, or define invalid responses differently.

These choices can produce different estimates and conclusions. If researchers examine the results of several exclusion strategies and report only the most favorable one, the apparent strength of the evidence may be misleading.

Prespecification establishes which decisions were intended before relevant results became available. It helps distinguish planned data preparation from outcome-informed changes and makes the analysis easier to reproduce.

Nevertheless, preregistration does not establish that an exclusion rule is scientifically appropriate. A poorly justified rule can remain biased even when it was specified in advance.

Which Types of Data Exclusions Should Be Preregistered?

Prioritize rules that could change the composition of the analysis population, the estimated relationship, or the uncertainty associated with the findings.

Exclusion category What to prespecify Important consideration
Duplicate records How duplicates will be identified and which record will be retained. Ensure that legitimate repeated observations are not mistaken for duplicates.
Invalid measurements Objective criteria for identifying measurements that cannot be interpreted. Distinguish confirmed errors from unusual but possible values.
Technical failures How documented equipment, software, or recording failures will be handled. Consider whether failures are associated with study conditions.
Outlying observations Any proposed detection thresholds and whether exclusion, transformation, or robust analysis is intended. Statistical extremeness alone does not establish invalidity.
Incomplete responses Minimum usable information and the treatment of missing values. Complete-case exclusion can introduce bias.
Attention or validity checks Exact criteria and consequences of failing a check. Check validity and possible differences across participant groups.
Protocol deviations Which deviations affect specific analyses and why. Post-assignment exclusions can undermine randomized comparisons.

Not every study needs every category. The rules should reflect foreseeable problems in the actual measurement and data collection procedures.

What Is the Difference Between an Invalid Observation and an Outlier?

An invalid observation contains information that cannot reasonably be treated as a valid measurement under the intended procedure. An outlier is an observation that differs substantially from other observations according to a statistical or substantive criterion.

These categories are not equivalent.

Suppose a questionnaire records age as 450 years. If the study concerns contemporary university students, that value is almost certainly a recording or entry error. It may require verification, correction, or treatment as missing.

By contrast, a participant who scores much higher than classmates on a valid achievement assessment may simply be an unusually high-performing student. Excluding that score because it is extreme could remove genuine variation from the population.

Outliers may be scientifically informative. They can reveal meaningful heterogeneity, model misspecification, or unexpected processes. Researchers should investigate their origin rather than assume that removing them improves the analysis.

Should You Preregister a Statistical Outlier Threshold?

When an outlier rule is consequential to the primary analysis, advance specification is generally advisable. However, the threshold should have a methodological justification.

Common approaches include standardized scores, interquartile-range fences, model residual diagnostics, and domain-specific plausibility limits. These methods identify different properties and are not interchangeable.

For example, an interquartile-range rule may identify observations below the first quartile minus 1.5 times the interquartile range or above the third quartile plus 1.5 times that range.

Illustrative Outlier Identification Rule
Lower fence = Q1 − 1.5 × IQR
Upper fence = Q3 + 1.5 × IQR

Q1: First quartile, or 25th percentile.

Q3: Third quartile, or 75th percentile.

IQR: Interquartile range, calculated as Q3 minus Q1.

1.5: A conventional multiplier used for exploratory outlier flagging, not a universal exclusion standard.

Suppose Q1 = 40 and Q3 = 60. The IQR is 20.

Lower fence = 40 − (1.5 × 20) = 10.

Upper fence = 60 + (1.5 × 20) = 90.

Observations below 10 or above 90 would be flagged for examination under this rule.

A flagged observation is not necessarily erroneous or unsuitable for analysis. The calculation identifies values outside conventional fences; it does not demonstrate that those values should be deleted.

For skewed distributions, bounded scales, clustered data, or other complex structures, the conventional rule may flag many valid observations. Researchers should choose diagnostics that reflect the measurement scale and analysis model.

Prespecification should distinguish the rule for identifying observations requiring investigation from the rule, if any, authorizing exclusion.

Should You Exclude Participants Who Fail Attention Checks?

Attention checks are sometimes used in surveys and experiments to identify responses that may not reflect adequate engagement with the task.

However, failing an attention check does not always establish that the participant's remaining responses are invalid. A failure may result from ambiguous instructions, language difficulties, accessibility barriers, or an isolated mistake.

If attention checks will influence the primary analysis, specify their content or operational criteria, the number of failures required for exclusion, and the intended treatment of affected records.

Researchers should also consider whether the checks are appropriate for the population and whether exclusion rates differ systematically across experimental conditions or participant groups.

Where feasible, analyses retaining all otherwise eligible observations can help assess whether conclusions depend on the exclusion rule.

How Should Missing Data Be Handled?

Missing data should not automatically trigger exclusion of an entire participant.

Complete-case analysis, which uses only records containing all variables required for a particular analysis, can be appropriate under some conditions. However, it may reduce precision and introduce bias when the probability of having complete data is related to relevant variables or outcomes.

Alternative approaches include multiple imputation, likelihood-based estimation, and models designed for particular missing-data structures. Their validity depends on assumptions about the missingness process and the statistical model.

A preregistration should identify the intended strategy and any relevant conditional procedures. It should also specify how missingness will be described and whether sensitivity analyses will examine departures from key assumptions.

The primary outcome definition should be coordinated with these decisions, particularly when incomplete assessments affect scoring or analysis eligibility.

Why Are Post-Randomization Exclusions Especially Sensitive?

Random assignment is intended to create comparable groups with respect to potential outcomes, subject to chance variation. Excluding participants after assignment can compromise that comparability when exclusion depends on treatment, adherence, outcomes, or related characteristics.

For example, excluding students who did not complete an intervention may create groups that differ in motivation or academic preparation, even if the original assignment was randomized.

The appropriate analysis depends on the intended estimand and design. An assignment-based analysis and a per-protocol analysis may address different causal questions and require different assumptions.

Researchers should therefore distinguish participant eligibility criteria from post-enrollment analysis exclusions. A participant who was eligible at enrollment does not automatically become ineligible because of nonadherence or missing follow-up information.

Can You Use Robust Statistical Methods Instead of Deleting Outliers?

Sometimes. Robust estimation, suitable transformations, distributionally appropriate models, and sensitivity analyses may reduce the influence of extreme observations without discarding valid data.

For example, an analysis of highly skewed response times may benefit from a model appropriate for positive, asymmetric measurements rather than automatic deletion of the slowest responses.

However, robust methods are not universally preferable. They estimate particular quantities under particular assumptions and may answer a different question from the originally planned analysis.

When several defensible methods are available, identify the primary approach and the role of alternatives in the prespecified analysis plan.

What Should Happen When an Unexpected Data Problem Appears?

No preregistration can anticipate every software error, measurement failure, or data-integrity problem.

If an unforeseen issue arises, first investigate its origin and determine whether the affected information can be corrected or validated. Exclusion should not be the automatic first response.

Where a change is necessary, document the original rule, the newly identified problem, the revised procedure, the decision date, and the information available when the decision was made.

Ideally, the decision should be made without knowledge of its effect on the principal results. Blinded data review or consultation with an independent analyst may be useful when feasible.

Follow the principles for amending a preregistered research plan. Transparency about a deviation does not automatically eliminate its statistical consequences, but it allows readers to evaluate those consequences.

How Should Exclusions Be Reported in the Final Study?

The final report should distinguish the number of observations initially obtained, the number excluded, the reasons for exclusion, and the number included in each important analysis.

Where applicable, report whether exclusions were prespecified, whether the criteria changed, and how conclusions differ when alternative defensible rules are applied.

For randomized trials, the CONSORT reporting framework emphasizes transparent participant flow and analysis populations. For observational research, STROBE addresses participant selection, missing data, and relevant reporting considerations.

Researchers should follow reporting guidance appropriate to their design rather than assuming that a single exclusion table satisfies every methodological requirement.

04 · A Practical Example

Preregistering Data Exclusions in an Online Learning Experiment

Hypothetical Example

A Study of Adaptive Online Practice

Researchers plan a randomized experiment comparing adaptive online practice with conventional practice. The primary outcome is performance on a 40-item achievement assessment.

The research team expects occasional duplicate submissions, missing responses, and technical interruptions. Before collecting data, it establishes rules for investigating and handling these problems.

Identify duplicate submissions

Each participant receives a unique study identifier. When duplicate submissions are detected, the team will examine submission logs and retain the designated valid assessment attempt according to a prespecified rule, rather than selecting the highest score.

Define technical failures

Assessments affected by a documented system interruption that prevents valid scoring will be flagged. The team will distinguish recoverable responses from measurements that cannot be reconstructed.

Handle incomplete assessments

Unanswered assessment items will be treated according to the instrument's scoring specification. A completely missing posttest will be recorded as missing outcome data and handled under the prespecified analysis plan.

Evaluate unusual scores

Very high and very low achievement scores will not be excluded solely because they are extreme. Scores will be checked for recording or scoring errors, while valid observations will remain eligible for the primary analysis.

Apply the rules before evaluating effects

Where feasible, data-quality checks will be completed without examining treatment-group differences. The team will maintain a dated record of corrections, exclusions, and unresolved problems.

Report the analysis population

The publication will identify the number randomized, the number with observed posttest scores, the number of invalid records, and the observations contributing to each analysis. Any unplanned exclusions will be disclosed.

Suppose 200 students are randomized, 190 provide posttest records, and three of those records contain unrecoverable technical errors. The researchers would report these quantities separately rather than simply describing the final dataset as containing 187 valid participants.

Whether the primary analysis includes additional information from participants with missing posttests depends on the specified estimand and statistical method. The example illustrates transparent data handling, not a universal recommendation to conduct complete-case analysis.

05 · What Researchers Often Get Wrong

Common Misconceptions About Excluding Research Data

Misconception

Every Statistical Outlier Is an Invalid Observation

An extreme value may be genuine. Statistical outlier detection identifies observations requiring consideration, not automatic deletion. Exclusion requires a defensible rationale connected to measurement validity or the intended analysis.

Misconception

Removing Outliers Always Makes Results More Accurate

Removing valid extreme observations can distort the population distribution and change the estimand. Depending on the research question, robust methods or sensitivity analyses may be preferable to exclusion.

Misconception

Preregistered Exclusions Cannot Introduce Bias

Prespecification documents the intended rule but does not guarantee its validity. A rule based on post-treatment characteristics or variables related to the outcome may introduce selection bias even when planned in advance.

Misconception

Participants With Missing Data Must Be Removed Entirely

Missing observations do not necessarily invalidate other measurements from the same participant. Appropriate treatment depends on the analysis, missingness assumptions, and available information.

Misconception

Data Cleaning Is Too Routine to Require Preregistration

Some cleaning operations are routine, but consequential decisions about exclusions, transformations, and missing data can alter results. These decisions deserve advance specification when they affect confirmatory inference.

Misconception

Any Unplanned Exclusion Invalidates the Entire Study

Unforeseen errors may require correction or exclusion. Their implications depend on the reason, timing, affected observations, and inferential consequences. Transparent reporting and appropriate sensitivity analyses can help readers evaluate the departure.

06 · What This Means for You

How to Decide Whether Data Should Be Excluded

Begin by asking whether the observation is valid for the intended measurement and analysis. Do not begin by asking whether its inclusion strengthens or weakens the hypothesis.

Next, determine whether the problem can be corrected, whether only part of the record is affected, and whether exclusion would introduce selection bias or change the quantity being estimated.

A simple decision framework

If an observation contains a verified recording or scoring error
Correct it using an auditable procedure when possible. If correction is impossible, apply a justified missing-data or exclusion rule.
If an observation is unusual but plausibly valid
Avoid automatic deletion. Examine measurement validity and consider an appropriate model or sensitivity analysis.
If a participant has incomplete measurements
Apply the planned missing-data strategy and retain other valid information when methodologically appropriate.
If exclusion depends on behavior occurring after treatment assignment
Assess whether the exclusion changes the estimand or compromises comparability between groups.
If an unforeseen problem requires a new exclusion rule
Document the problem and amendment promptly, including whether relevant results were already examined.

When exclusions materially affect the results, consider reporting analyses with and without the affected observations, provided both analyses are scientifically interpretable. Such comparisons can reveal sensitivity to the exclusion rule, although they do not automatically identify which estimate is less biased.

Coordinate the exclusion plan with sample-size and stopping decisions. Anticipated exclusions and missing observations can affect statistical precision, recruitment planning, and the interpretation of the achieved sample.

Above all, maintain an auditable record. Researchers should be able to explain what was removed, why it was removed, when the decision was made, and how the resulting analysis relates to the original research question.

07 · A Quick Checklist

Before Preregistering Data Exclusion Rules

Before finalizing your data preparation plan, check:
Identify foreseeable data-quality problems that could affect the primary analysis.
Distinguish participant eligibility, post-enrollment exclusions, and observation-level exclusions.
Define objective procedures for identifying duplicate, invalid, or technically compromised records.
Specify whether flagged outliers will be investigated, retained, transformed, or excluded, with justification.
Prespecify consequential attention-check and response-validity criteria, where applicable.
Describe the intended treatment of incomplete observations and missing outcomes.
Evaluate whether exclusions could introduce selection bias or change the intended estimand.
Identify appropriate sensitivity analyses for consequential exclusion decisions.
Establish a dated audit trail for exclusions, corrections, and subsequent amendments.
Plan to report the number and reasons for exclusions in the final research report.
08 · Frequently Asked Questions

Frequently Asked Questions About Preregistering Data Exclusions

Do I have to preregister every data-cleaning operation?

Not necessarily. Prioritize decisions that materially affect the analysis population, variables, estimates, or inferential conclusions. Routine operations may be documented in analysis code or a data-processing protocol, while consequential exclusions deserve explicit advance specification.

Can I exclude outliers after seeing the data?

Potentially, but the decision requires a defensible methodological rationale. Distinguish data inspection needed to identify errors from selecting exclusions because they produce favorable results. Disclose unplanned rules and consider sensitivity analyses.

Is the 1.5 × IQR rule a valid reason to delete observations?

Not by itself. The rule identifies observations outside conventional exploratory fences. It does not establish that those observations are erroneous or irrelevant to the intended population.

Should I exclude participants who fail an attention check?

Only when the check and exclusion procedure are appropriate for the research context. Specify the rule, assess its validity, and consider whether failures reflect measurement problems or characteristics relevant to the study.

Can I exclude participants who did not follow the intervention?

Not automatically. In randomized studies, post-assignment exclusions may introduce bias and change the causal question being answered. Define the intended estimand and distinguish primary assignment-based analyses from appropriately justified adherence analyses.

Should missing responses be treated as exclusions?

Missingness and exclusion are related but distinct. A participant may have valid information for some variables or occasions. Use a missing-data strategy appropriate to the study design rather than automatically deleting the entire record.

Can I change an exclusion rule after preregistration?

Yes, when justified. Preserve the original rule, document the revised procedure and its timing, and explain whether the decision was informed by observed results. Report consequential deviations transparently.

Should I publish the number of excluded observations?

Yes, when exclusions affect the reported analyses. Provide counts and reasons at the appropriate level, distinguish planned from unplanned exclusions, and identify the analysis population. The reporting detail should reflect the study design and applicable guidelines.

09 · The Bottom Line

Decide What Makes Data Unusable Before Knowing Which Exclusions Favor Your Results

The Bottom Line

Preregister consequential data exclusion rules before examining relevant results. Specify what makes an observation invalid, how problems will be identified, which information will be removed, and how exclusions will affect the planned analysis.

The purpose is not to eliminate every unusual value or prohibit justified corrections. It is to prevent selective data removal, preserve valid information where possible, and make the relationship between the original plan and final analysis transparent.

10 · Sources and Further Reading

Authoritative Sources on Data Exclusions and Transparent Analysis

11 · Cite this Guide

How to Cite This Guide

This guide is intended to be read, shared, and used in research, teaching, and academic work. If you draw on its ideas, explanations, or other content, please acknowledge the source by citing the guide. Doing so gives appropriate credit and helps your readers locate the original resource.

Has the Field Guide helped your research?

If a guide helped clarify a question, inform a research decision, or move your work forward, I would love to hear about your experience. Your story may also help other researchers discover the Field Guide.

Share Your Experience
Takes only a few minutes