FreeStatisticalTools.com
Data cleaning and preparation

Outlier Calculator (Z-Score, IQR, Grubbs and Mahalanobis)

Screen your data for outliers before analysis. Each variable is checked with |z| > 3.29, Tukey’s 1.5 × IQR rule and Grubbs’ test, and every case gets a Mahalanobis distance with a chi-square p-value for multivariate outliers.

Free · No sign-upReplaces SPSS · PrismWorks with your data
Updated · By Bibin Xavier

Data 90 × 12

Paste from Excel, or drop a CSV, TSV or Excel file here.
Example data 90 rows, 12 variables. Data stays in this browser tab.
IDtext · 90 levelsGrouptext · 3 levelsGendertext · 2 levelsAgenumericHours_StudynumericAnxietynumericMotivationnumericPre_ScorenumericPost_ScorenumericExam_ScorenumericPassednumeric · codedSatisfactionnumeric · coded
S001ControlMale2311.2294.660626712
S002WorkshopFemale233.9283.554705402
S003OnlineFemale1810.132455576603
S004ControlMale2613.6413.552555903
S005WorkshopFemale229.7273.656636504
S006OnlineFemale207.9323.865826502
S007ControlFemale206.328372836103
S008WorkshopMale228293.164726213

Variables and options

Variables 3 selected · min 1
Results update automatically when you change an option.

Results

90 rows · example data
Table 1

Univariate outliers

VariableMSDIQR fences|z| > 3.29IQR outliersGrubbs GpMost extreme value
Pre_Score60.188.7534.50 to 86.50002.2661.00080.00 (case 46)
Post_Score65.0911.0531.50 to 99.50002.3611.00039.00 (case 33)
Exam_Score62.289.3238.38 to 85.38002.4371.00085.00 (case 11)

Note. Grubbs’ test (two-sided) checks whether the single most extreme value is an outlier, assuming normality. IQR fences: Q1 − 1.5 × IQR and Q3 + 1.5 × IQR (Tukey).

Table 2

Multivariate outliers (Mahalanobis distance)

CaseD²pPre_ScorePost_ScoreExam_Score

Note. Critical χ²(3) = 16.266 at p < .001. 0 of 90 cases exceed it. No multivariate outliers.

Mahalanobis distance by case

Cases screened90
Cases with a univariate flag0
Multivariate outliers0p < .001

Interpretation

No univariate outliers were found. No case is a multivariate outlier by Mahalanobis distance. Check flagged cases for data-entry errors first; remove or winsorize genuine outliers only with a stated rule, and report how many were affected.

Mahalanobis distance (χ²(3) critical value 16.27, p < .001) identified 0 multivariate outliers among 90 cases.

How to cite this tool

Using these results in a thesis, journal article, report or class assignment? Please cite this free tool so others can find it. It keeps the site free.

APA 7

Xavier, B. (2026). Outlier Calculator (Z-Score, IQR, Grubbs and Mahalanobis) [Web application]. FreeStatisticalTools.com. https://freestatisticaltools.com/outlier-calculator/

BibTeX

@software{xavier_outlierdetection_2026,
  author = {Xavier, Bibin},
  title = {Outlier Calculator (Z-Score, IQR, Grubbs and Mahalanobis)},
  publisher = {FreeStatisticalTools.com},
  year = {2026},
  url = {https://freestatisticaltools.com/outlier-calculator/},
  note = {Web application}
}

Suggested sentence for your methods section: “The analysis was carried out with the free Outlier Calculator (Z-Score, IQR, Grubbs and Mahalanobis) tool on FreeStatisticalTools.com (Xavier, 2026).”

What is outlier detection?

An outlier is a value far from the rest of the data. Univariate outliers are extreme on one variable; multivariate outliers have an unusual combination of values even if each value looks normal. This calculator checks every variable with |z| > 3.29, Tukey’s 1.5 × IQR fences and Grubbs’ test, and gives every case a Mahalanobis distance with a chi-square p-value.

When to use outlier detection

Use it during data screening, before t-tests, ANOVA, regression, factor analysis or SEM, because a few extreme values can change means, correlations and coefficients.

Assumptions

  • z-scores and Grubbs’ test assume roughly normal data; the IQR rule does not.
  • Mahalanobis distance assumes multivariate normality and is itself affected by outliers.

How to set up your data

One column per numeric variable, one row per case. Optionally choose an ID column to label flagged cases.

How to use this tool

  1. Enter your data. Paste columns from Excel, Google Sheets or SPSS with variable names in the first row, or upload a CSV or Excel file. The example data shows the expected layout.
  2. Choose the variables. Select the variables and case label (optional).
  3. Set the options. Fill in z-score cut-off and mahalanobis significance level.
  4. Read the results. Results update automatically. Read the plain-English interpretation, then use Copy table to paste APA-style tables into Word and Copy for the results sentence.

How to report outlier detection in APA style

“Using Mahalanobis distance (p < .001), three multivariate outliers were identified and removed, leaving N = 297.”

Frequently asked questions

How do you detect outliers?

For one variable, flag values more than 1.5 × IQR beyond the quartiles or with |z| above 3.29. For several variables at once, compute the Mahalanobis distance of each case and compare it with a chi-square distribution.

What is Mahalanobis distance?

The distance of a case from the multivariate mean, scaled by the covariance of the variables. Under multivariate normality D² follows a chi-square distribution with as many degrees of freedom as variables, so cases with p < .001 are usually treated as multivariate outliers.

What does Grubbs’ test tell me?

Whether the single most extreme value in a normally distributed variable is a significant outlier. Apply it one value at a time.

Should I remove outliers?

First check for data-entry errors. Remove or winsorize genuine values only with a rule decided in advance, report how many cases were affected, and consider robust methods instead.

What z-score is an outlier?

Common cut-offs are |z| > 3 or |z| > 3.29 (p < .001, two-tailed); in small samples, |z| > 2.5 is sometimes used.

Related tools

Browse all categories