percentile.inc

I want to group different E populations together. I want to know the percentile rank of E1,E2,E3,E4. How do I combine these groups to make a percentile rank of the score? I'm doing a lot of combing populations this way, is there any way to make criteria an OR instead of an AND?

Hi, Here is an example with my challenge click (onedrive files) I following cues from https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-%E2%80%93-part-i/ and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/ I am trying to get...

Hello, I am looking for a formula that gives me a threshold/score value from column A up to which the revenue in column B cumulates to 10%. The scores need to be in descending order, i.e. 10 is best and 1 worst. Plus, the data cannot/should not be sorted (otherwise one could use index & match)...

I have a spreadsheet with an Access query that returns data by date. The query returns an "x" in a column next to each date where a match is found in another table in the database. In Excel, I'd like to replace the x's with the result of this function: =percentile.inc("D:D", 0.90) I figure...

Hi I have a large amount of data that I would like to calculate percentiles on but need to extract the data belonging to the same instrument first. How do I search for the instrument e.g. SD6000 and then perform the percentile calculation on only those values associated with that instrument for...