How to Use Excel to Find Percentiles

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Excel to Find Percentiles
Excel can compute percentiles from a range of cells. (per cent image by Soja Andrzej from Fotolia.com)

Excel isn't just for entering information into spreadsheets -- it can be used to calculate a number of different mathematical formulas and functions, including finding percentiles. The Excel function used to calculate percentages is the percentile function, which has the formula "=percentile(RANGE,K)" where RANGE is a range of cells in the Excel spreadsheet and K is a percentile between 0 and 1. For example, the percentile function "=percentile(B1:B5,.25)" calculates the 25th percentile for the values in cells B1 to B5.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Click on a blank cell in the worksheet with your pre-filled in values (the values for which you would like to find a percentile).

  2. 2

    Type "=percentile(."

  3. 3

    Type a range of cells. For example, if the numbers that you want to find a percentile for are located in cells A1 to A10, type "A1:A10."

  4. 4

    Type a comma followed by the percentile you want to find. This must be in decimal form. For example, instead of typing "90%," type ".9."

  5. 5

    Type a closing parenthesis ")" and then press the "Enter" key.

Don't Miss

References

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.