Getting Percentiles with the =PERCENTILE() Function

If you have data values in a column or row, you can use the PERCENTILE function to calculate any desired percentile.

An advantage of the PERCENTILE function is that your data does not have to be sorted in ascending or descending order.

Suppose the data is stored in column B, rows 25 through 100, and we want the $75^{th}$ percentile.

The syntax of the function call is:

   =PERCENTILE(B25:B100,.75)

By adjusting the value of the second parameter, you can obtain any percentile you want.