Guesstimate – A Spreadsheet for things that aren't certain

Re:Guesstimate – A Spreadsheet for things that aren't certain by carlob on Saturday December 29, 2018 @05:00PM (#18785974)

Maybe it's just the short video and the FAQ, but I found it particularly difficult to find information about the distributions involved and how to choose that.

I imagine there a bunch of cases where the defaults would not work like you're trying to do error propagation (all normal distributions) or you're trying to compute interval arithmetic.

Is it the case that if you input a range which span multiple orders of magnitude then you get lognormal rather than normal?

I might not be exactly the target audience, but I would appreciate a more in-depth of the math and heuristics involved

EDIT: I found this on their blog

https://medium.com/guesstimate-blog/lognormal-normal-833bf41...

[ Parent | on HN ]

Re:Guesstimate – A Spreadsheet for things that aren't certain by ozgooen on Saturday December 29, 2018 @07:52PM (#18786660)

Thanks for the feedback.

We have some documentation [here](https://docs.getguesstimate.com/), and some in the sidebar entree.

Generally, we recommend lognormal distributions for estimated parameters that can't be negative. This works when you span multiple orders of magnitude, though it's possible you may want an even more skewed distribution (which is unsupported).

I may be able to make a much longer video introduction some-time soon.

[ Parent | on HN ]