I understand that this is a really easy function to do yourself. But I can imagine all the people feeling dumb for searching for it for a few minutes before resorting to the peasant method of typing two functions that are always put together in almost every Excel spreadsheet ever.1 vote
Can you give a bit more detail on what you’re looking for here? I’m not sure I understand from your description.
Is it the MAX of a range minus the MIN of that same range?
1. More inverse cumulative distribution functions (Poisson, Exponential, Negative Binomial, Weibull, etc.);
2. Ability to confine the distribution between certain values;
3. Ability to generate / simulate time series;
4. 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);
5. Ability to correlate distributions;
6. 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.11 votes
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?