stats

Percentile Calculator

Percentile rank of a value, quartiles (P25/P50/P75/P90), and IQR for a data set.

Input

Data Set (comma or space separated)Target Value (for rank lookup)

Results

Percentile rank of target—

P25 (Q1)—

P50 (Median)—

P75 (Q3)—

P90—

IQR = Q3 − Q1—

Linear interpolation (PERCENTILE.INC) · rank = (below + 0.5×equal)/n × 100