Home

How to Use the PERCENTILE & QUARTILE functions in MS Excel

Excel spreadsheet showing percentile data with dimensions and statistical values.

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.

A 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.

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.