New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
One row sits ten times bigger than everything around it, and deleting it feels risky either way.
What you'll have at the end
A written decision, correct, keep, or remove, naming the specific cause, not a blanket rule applied to every extreme value.
You need
A column of amounts already in a spreadsheet or table, with one row flagged as far bigger than the rest, plus access to the system that created the rows and a related table you can look its details up against.
Not covered
Deciding statistically which rows count as outliers in the first place; this recipe starts once one row is already flagged.
Leans on
An outlier is dragging your summary numbers off track
This row hasn't been flagged yet and you need a defensible way to find it first: that recipe covers the statistical detection this one assumes is already done.
Write a reproducible data cleaning log
This recipe logs one row's call in a single line; that recipe builds the full reusable log format for an entire cleaning pass.
Checked 26 Aug 2026
Part of the Data Cleaning and Validation for Analysts cookbook