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 |
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) |