I need to do decile analysis on the attached data set (which shows average cycle time by numbers of deals).
We have a target goal of 17 days for deal processing and need to trim down some cycle times somewhere to achieve targets. Therefore, if I know that 10% of deals hit aspiration, what kind of movement has to occur on the other 90% to allow us to hit our goals? So if I could shave off 5 days on deciles 6-10 while keeping deciles 1 -5 static, what becomes the average?
Threshold Target Max
20 17 14
Is this analysis possible in Excel? I ran the query in Oracle – PL/SQL – any easier way to do it there?