| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cycle time | Charts and Charting in Excel | |||
| Cycle Time Calculations | Excel Worksheet Functions | |||
| Cycle Time if in a Specific Year | Excel Worksheet Functions | |||
| cycle time out of range error | Excel Discussion (Misc queries) | |||
| Time Cycle | Excel Discussion (Misc queries) | |||
Hybrid Mode
