Analyse-it
You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.
Topic: Using Analyse-it > Preparing data in Excel > Defining variables > Excluding outliers

Excluding outliers

Observations deemed to be outliers can be excluded from analysis by enclosing the value in square brackets, or included again by removing the square brackets surrounding the value. Analyse-it provides a simple way to mark or unmark an observation as an outlier. We rtecommend attaching a Note/Comment to cells containing outliers to explain why they are excluded.

To mark (or unmark) an observation as an outlier:

  1. Select the Excel cell containing the observation to mark (or unmark) as an outlier.
  2. Click Mark/Unmark outlier on the Analyse-it tab/toolbar. 
  3. The observation will be marked/unmarked as an outlier.


Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.