ExcelBanter - 25th percentile (cycle time)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 25th percentile (cycle time) (https://www.excelbanter.com/excel-worksheet-functions/248833-25th-percentile-cycle-time.html)

25th percentile (cycle time)

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

25th percentile (cycle time)

How about (longest time - shortest time)/100*25?=(max(e:e)-min(e:e))/100*25

"Rum" wrote:

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