‹ BackHN Continuity

Thread

Excel now supports multiple values in a single cell

278 points · 196 comments · luispa

  1. m101 · · focus · HN ↗
    What would be a revolution in excel is if we could have probability distributions in cells. Right now all spreadsheets are fairly deterministic and we think that tells us something about the real world. Having an ability to make cells distributions (and then all resultant cells would be distributions too) would represent the uncertainty in the world better (and expose lots of interesting things like distributions of tails)
    1. balderdash · · focus · HN ↗
      Check out @Risk and crystal ball - both have been around for a long time.

      I should also say what’s really nice is you can define the shape of the probability distribution and parameters for random variables, as well as the correlation of different random variables. Both are effective but also feel dated these days.

      <a href="https:&#x2F;&#x2F;lumivero.com&#x2F;products&#x2F;at-risk&#x2F;" rel="nofollow">https:&#x2F;&#x2F;lumivero.com&#x2F;products&#x2F;at-risk&#x2F;

      <a href="https:&#x2F;&#x2F;www.oracle.com&#x2F;applications&#x2F;crystalball&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.oracle.com&#x2F;applications&#x2F;crystalball&#x2F;

      1. Scharkenberg · · focus · HN ↗
        Off-topic: managing @Risk licenses in a fully on-prem, no-internet environment has been such a pain in the neck.
Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.