I'd like to calculate the 75 percentile from a frequency table (mortality data; i.e., 5 deaths on day 1, 4 deaths on day 2, 10 deaths on day 3, etc.).

I did find this similar question, http://www.excelforum.com/excel-gene...ency-data.html, but it does not give the correct answer based on Excel's percentile function.

Does anyone have a way to calculate percentiles from a frequency table? Thanks in advance.