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.
pwflexnerAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.