How to Use the PERCENTILE & QUARTILE functions in MS Excel

Apr 14, 2010 10:23 PM
Article cover image

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.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!