# Calculating a percentile

In column A are dates (in order, from 1986 to the present).  In column B are a range of values, so each day has a corresponding value.  Using the first x days of column B values as my sample (for example, 50 days), I need to calculate a value such that a given percentage of the sample values (say, 15%) are greater than that value and the rest are below that value.
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ConsultantCommented:
Assuming that your first data row is 2 and the percentile is in cell C1 and the population size is in D1:

=SMALL(OFFSET(B2,0,0,D1,1),INT(C1*D1)+1)

Kevin
0

Experts Exchange Solution brought to you by