QUARTILE.EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
Syntax
QUARTILE.EXC(array, quart)
Parameters
- array: Required. The array or range of numeric values
- quart: Required. The quartile to return (1=25th percentile, 2=median, 3=75th percentile)
Example
=QUARTILE.EXC(A1:A10, 1)