Fill Rate 90%

[chum]

Hi,

I have a list of orders with their turn around time, which belong to
different countries.
I want to calculate the fill rate 90 % for each countries, means that I
want to know in how many days 90% of the orders in France were
delivered, the same for Germany, UK, Italy etc.
I thought I could first calculte the number of records per country with
the SUMPRODUCT formula, but then I don't know how to enter "90% of the
total of the countries' records",

Does someone have any inputs ?

thanks in advance,
Chum

 

[Guest]

Use PERCENTILE()


At issue is generating enough visibility to insure that the answers make
sense. I would:

1. Separate the data into a column for each country
2. Sort the columns separately

Now say column A contains order turn-around periods in days, one for each
order, in A1 thru A120, for the UK.

=PERCENTILE(A1:A120,.9)

should yield the 90% level.

 

[chum]

Hi Gary,

many thanks for the tip, I will gain a lot of time now !
until now I was calc. the freqency, then another column with %, and
then another one with cumulative fillrate.

Take care,
Chum