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.)
=QUARTILE(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.