2 ms·
First because the probablity distribution itself would have to be pulled out of thin air, and make the results questionable. Of course. It's just a more system
by yummyfajitas 13y ago
First because the probablity distribution itself would have to be pulled out of thin air, and make the results questionable.
Of course. It's just a more systematic version of manually tweaking parameters in a spreadsheet (which are also pulled out of thin air).
With libraries like PyMC, it's one extra step beyond writing an assumption->outcome formula. You write the same formula, but then set variables to probability distributions rather than floats .
And if you need to convince someone else afterwards of your conclusions, then for 99% of audiences you anyway want to use 'specific plausible scenario story'...since it's well researched that the first kind of evidence works better in convincing homo sapiens about anything at all.
Fair enough. This is solid dark arts, but useful.
- PeterisP 13y agoIf it can handle the same formulas, then I could imagine a market for a tool that takes an existing spreadsheet and does what you say - allows to set a probability distribution for any number, recalculates everything, and shows the distribution for resultcells on, say, mouseover. Convenience matters in such things, and simply reading a 20x20 data table into any programming language already takes more time than just writing the formulas next to this table in excel.
- yummyfajitas 13y agoI'm sure you could write such a plugin for excel with DataNitro or some such. The code is roughly: outputs = [] for x in monte_carlo_input(param1_dist, param2_dist, ...): outputs.append( (x, f(x)) ) histogram/whatever(outputs) In contrast, the code to manually tweak formulas is simply: > f(10, 3, 0.07) 12 > f(12, 5, 0.09) -3.9