Returns the quartile of a data set.
Data represents the array of data in the sample.
Type represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)
The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive.
=QUARTILE.INC(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.