25th percentile (cycle time)

R

Rum

Here is a scenario:

If:
Column A is list of AUTO MAKERS
Column B is list of DEALERSHIPS
Column C is list of dates when DEALERSHIP OPENED
Column D is list of dates when DEALERSHIP READY TO SELL CARS
Column E is the the difference of Column D and Column C (D-C) (Cycle Time)

There are a thousand rows and multiple column in this data set.

I would like to find out how long does it take the 25th percentile of any
DEALERSHIP to get READY TO SELL CARS.

Please share your thoughts.

Rum
 
M

Mike H

Hi,

For column E I used

=DATEDIF(C2,D2,"d")

to calculate the difference in days then for the first quartile the ARRAY
formula

=AVERAGE(IF(E2:E19<>"",IF(E2:E19<=QUARTILE(E2:E19,1),E2:E19)))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike
 
D

David Biddulph

What is the advantage in using =DATEDIF(C2,D2,"d") rather than just =D2-C2,
Mike?
 
M

Mike H

David,

On reflection probably nothing, in fact on even more reflection I now prefer
D2-C2. Thanks for that.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top