Field note · August 1, 2024

The top of sessions is 2.8× the 99th percentile

A max 2.8× the 99th percentile, and the three different things that could be.

1 min read ·Statistics ·statistics quality

sessions on ab-test-checkout: p99 is 8 and the max is 22.

The max is 2.8× the 99th percentile and 11.3 standard deviations above the mean. The median is 2, so the top of this column lives in a different regime from the middle of it.

sql
select *
from ab_test_checkout
order by sessions desc
limit 20;

Run that before deciding anything. There are three things an extreme value can be, and they need opposite treatment: a data error, a real but rare event, or a different population that got mixed into the same table. Only the first is safe to drop, and you cannot tell them apart from the summary statistics — you have to look at the rows.

A ratio this large usually means the third case. Something in this column is not the same kind of thing as the rest, and the honest fix is a filter with a stated reason rather than a percentile clip.

Clipping at the 99th percentile is a decision to discard your most interesting rows. Sometimes right. Never automatic, and never silent — if a number in a report was computed on clipped data, the report has to say so.