software

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 quot;90% of the
total of the countries' recordsquot;,

Does someone have any inputs ?

thanks in advance,
Chum--
chum
------------------------------------------------------------------------
chum's Profile: www.excelforum.com/member.php...oamp;userid=34262
View this thread: www.excelforum.com/showthread...hreadid=541000Use 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.
--
Gary''s Studentquot;chumquot; wrote:

gt;
gt; Hi,
gt;
gt; I have a list of orders with their turn around time, which belong to
gt; different countries.
gt; I want to calculate the fill rate 90 % for each countries, means that I
gt; want to know in how many days 90% of the orders in France were
gt; delivered, the same for Germany, UK, Italy etc.
gt; I thought I could first calculte the number of records per country with
gt; the SUMPRODUCT formula, but then I don't know how to enter quot;90% of the
gt; total of the countries' recordsquot;,
gt;
gt; Does someone have any inputs ?
gt;
gt; thanks in advance,
gt; Chum
gt;
gt;
gt; --
gt; chum
gt; ------------------------------------------------------------------------
gt; chum's Profile: www.excelforum.com/member.php...oamp;userid=34262
gt; View this thread: www.excelforum.com/showthread...hreadid=541000
gt;
gt;


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--
chum
------------------------------------------------------------------------
chum's Profile: www.excelforum.com/member.php...oamp;userid=34262
View this thread: www.excelforum.com/showthread...hreadid=541000