Calculating a percentile
Posted on 2011-02-24
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.