Excel Forum



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.





Got a Question? Ask it Here in the Forum.