Interquartile Range (IQR)

Use p25, p50, and p75 together to show the interquartile range - a measure of statistical dispersion.

Interactive Example

Try It

TABLE ROWS occupation * income.(p25 | p50 | p75);

Dataset:samplesoccupation, education, gender, income

Try Variations

Query Breakdown

• income.(p25 | p50 | p75) - Multi-binding syntax: applies three percentile aggregations to income
• p25 - First quartile (25th percentile)
• p50 - Median (50th percentile)
• p75 - Third quartile (75th percentile)

The IQR (p75 - p25) contains the middle 50% of the data. It's useful for understanding data spread and identifying outliers.

Percentile Reference

Syntax	Percentile	Description
p25	25th	First quartile
p50	50th	Median (also available as median)
p75	75th	Third quartile
p90	90th	Common for performance metrics
p95	95th	Common for SLA/latency reporting
p99	99th	Tail latency metric

Related Examples

• Median - Just the 50th percentile
• Statistical Summary - Complete distribution view
• Multiple Aggregates - General multi-aggregation syntax