## At A Glance

### Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile

See how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles. Basic Statistics. Quartile divides a data set into 4 groups with 3 marker points (.25, .5, .75) .25 quartile means that that value marks the point where 25% of the values lie below and 75% above. Quartile divides a data set into 4 groups with 3 marker points (.25, .5, .75) .25 quartile means that that value marks the point where 25% of the values lie below and 75% above. Quartile divides a data set into 4 groups with 3 marker points (.25, .5, .75) .25 quartile means that that value marks the point where 25% of the values lie below and 75% above. Quartile divides a data set into 4 groups with 3 marker points (.25, .5, .75) .25 quartile means that that value marks the point where 25% of the values lie below and 75% above. Quartile divides a data set into 4 groups with 3 marker points (.25, .5, .75) .25 quartile means that that value marks the point where 25% of the values lie below and 75% above. Basic Statistics.
Length: 05:44

## Contact

Questions about Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile