Excluding observations from analysis

Exclude observations, such as outliers or influential observations, from analysis to see their effect on the results.

Before you exclude observations from the analysis, you should fully investigate them. Rather than a nuisance, outliers can sometimes be the most interesting and insightful observations in the data.

  1. Activate the dataset worksheet.
  2. Select the cells containing the observations to exclude/include.
  3. On the Analyse-it ribbon tab, in the Dataset group, click Include / Exclude.

    The observations will be excluded (or re-included) in future analyses.

Observations to exclude from the analysis are enclosed in square brackets (for example, [65] or [Male]) in the dataset. Excluded observations are treated the same as missing values by an analysis.

We recommend you attach an Excel comment to the cell to document the reason for excluding the observation.