How to get Percentiles from Value Ranges

[PC_Meister]

Hello,

I have data in the following format:

Range Min	26	31	36	41	46
Range Max	30	35	40	45	50
Number of Occurences	211	134	652	121	89

<tbody>
</tbody>

How I can use Excel to get the value of a given percentile. So for example, the 15th percentile is 32, the 85th percentile is 44 and so on. Thanks in advance.

 

[vllgv]

Not sure if I am looking at this right but assuming the table above goes form A1 to F3.

I have the word "Percentile" in cell H1, decimal of your choice in cell I1, and formula =PERCENTILE.EXC(B1:F2,I1) in J1.

 

[Jon Peltier]

By binning the values, you lose the ability to generate precise quantiles from the data. For example, I know that the 25th percentile lies between 31 and 35, the 50th and 75th lie between 36 and 40, but I don't know where the percentiles are located within these ranges. I could pretend that the values are uniformly distributed within these ranges, or I could assume some kind of distribution, but that wouldn't be as accurate as if I had access to the original data.