What is QUARTILE?
Returns the quartile of a dataset. Divides data into four equal parts for statistical analysis.
Syntax
=QUARTILE(array, quart)
Example
Formula: =QUARTILE(A1:A100, 1)
Result: First quartile (25th percentile)
How It Works
Quart: 0=min, 1=25th percentile, 2=median, 3=75th percentile, 4=max. Essential for box plot analysis.