News for hackers. Stuff that matters.
Re:Guesstimate – A Spreadsheet for things that aren't certain by wenc on Saturday December 29, 2018 @09:32PM (#18787001)
Can this sample from an empirical distribution? (i.e. from a CDF, not from a known distribution family)
Re:Guesstimate – A Spreadsheet for things that aren't certain by ozgooen on Monday December 31, 2018 @09:42AM (#18794652)
You can copy & paste an array of samples and Guesstimate will sample from that cluster. For instance, try pasting the following into the value field of a cell: [1,1,1,2,2,2,2,3,3,3,3,3,4,4,4,4,4,7,7,7,7]

You can use tools like distshaper6 to generate arbitrary distributions, then copy the samples into Guesstimate.

http://smpro.ca/pjs/distshaper/

Guesstimate doesn't yet support an input format for distributions outside of via samples.

Re:Guesstimate – A Spreadsheet for things that aren't certain by wenc on Sunday December 30, 2018 @06:28PM (#18791966)
I should add that I was thinking about this method -- Inverse Transform Sampling [1].

It's also just a fancy name for generating a pseudo-random number from a Uniform distribution in [0,1], and reading off the x-axis of the CDF.

[1] https://en.wikipedia.org/wiki/Inverse_transform_sampling