Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Tutorials
  • Distribution tutorial

Excluding outliers

Some statistics can be badly affected by outliers in the data, while others are robust. It is often worth considering how the results are affected by such observations.

  1. On the Analyse-it ribbon tab, in the Report group, click Goto Dataset.

    The dataset worksheet is displayed.

  2. Click in cell A34 containing the value -44.
  3. On the Analyse-it ribbon tab, in the Dataset group, click Include / Exclude.

    The value is enclosed in square brackets [] indicating it will be excluded from further analysis.

  4. Repeat steps 2 and 3 to exclude the value -2 (cell A58).
  5. Click on the Speed worksheet tab.
  6. On the Analyse-it ribbon tab, in the Report group, click Recalculate.

    The results are recalculated without the outliers and the analysis report updated.

After excluding the outliers the mean estimate has changed from 26.2 to 27.8 and the confidence interval is narrower.

Next topic: Changing the histogram classes

  •  Tutorials
  •  Distribution tutorial
  •  Plotting the distribution of the data
  •  Estimating the population mean
  •  Excluding outliers
  •  Changing the histogram classes
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy
Copyright 2026 Analyse-it Software, Ltd.
Statistical analysis and method validation software for Microsoft Excel.
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.