Quartiles and Percentiles - Statistics - Excel

Quartiles - Excel

=QUARTILE(range,quartile#)

Quartile# can be 0,1,2,3 or 4 as detailed below:

0 = Minimum Value        
=QUARTILE(range,1)  or  =PERCENTILE(range,0)

1 = Lower Quartile Q₁ = number that 25% of observations are less than and 75% are greater than

=QUARTILE(range,1)  or  =PERCENTILE(range,0.25)

2 = Second Quartile Q_{2 = number} Half  the observation are larger than or equal to ( median).

=QUARTILE(range,2)  or  =PERCENTILE(range,0.50)

3= Upper Quartile Q₃ = number that 75% of observations are less than and 25% are greater than

=QUARTILE(range,3)  or  =PERCENTILE(range,0.75)

4 = Maximum Value

=QUARTILE(range,4)  or  =PERCENTILE(range,1)

Percentiles - Excel

=PERCENTILE(range,percentile#)
 

Percentile# can be any value between 0 and 1, e.g. detailed below:

0.9 = 90^th Percentile =PERCENTIL(range,0.90)