- More inverse cumulative distribution functions (Poisson, Exponential, Negative Binomial, Weibull, etc.);
- Ability to confine the distribution between certain values;
- Ability to generate / simulate time series;
- Ability to sample/simulate all inverse cumulative distribution functions without continuously recalculating the workbook (ex. run the simulation behind the scenes much like the current IRR function operates though iteration);
- Ability to correlate distributions;
- Ability to run sensitivity analysis on the results;
It is currently possible to build all of the above functionalities through VBA but having dedicated tools will bring considerable efficiency improvements.
Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?
- Don't see your idea?