I'm trying to calculate different percentiles from an array of data that i have, with no luck at all.
In column A i have dates for each day, and in column B i have a value for that specific date. Dates are not necessarily consecutives. For example:
I would like Excel to return the date and value from column B, for the 10%, 25%, 50%, 75% and 90%, of the SUM of values in column B.
In the above example, the total SUM of values is 30.7, so the 10th percentile is 2.07, and the date that it should return is 9/24/09, as this is the first day that the accumulated values in column B went over the 10%.
Any help will be greatly appreciated.
Thanks a lot!