Functions
QUARTILE.INC
Inclusive quartile
Try it
When to use it
When should I use QUARTILE.INC?
Use QUARTILE.INC for the standard inclusive quartile calculation where quart=0 returns the minimum and quart=4 returns the maximum; this is the default method used in most business and academic summaries.
Used in
Syntax
QUARTILE.INC(array,quart)Examples
=QUARTILE.INC({1,2,3,4,5,6,7,8,9,10},0) // => 1
=QUARTILE.INC({1,2,3,4,5,6,7,8,9,10},1) // => 3.25
=QUARTILE.INC({1,2,3,4,5,6,7,8,9,10},2) // => 5.5