Functions
QUARTILE.EXC
Exclusive quartile
Try it
When to use it
When should I use QUARTILE.EXC instead of QUARTILE.INC?
Use QUARTILE.EXC when you want quartiles calculated using an exclusive method that excludes the minimum and maximum, which is preferred in some statistical disciplines and box-plot standards.
Used in
Syntax
QUARTILE.EXC(array,quart)Examples
=QUARTILE.EXC({6,7,15,36,39,40,41,42,43,47,49},1) // => 15
=QUARTILE.EXC({6,7,15,36,39,40,41,42,43,47,49},2) // => 40
=QUARTILE.EXC({6,7,15,36,39,40,41,42,43,47,49},3) // => 43