‹ 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. tty456 · · focus · HN ↗
      Have a few use cases or examples?
      1. m101 · · focus · HN ↗
        The main one I was thinking about was in finance when doing lending to corporates. You build a financial model of the company, and then you “stress test” it to see where the company struggles to pay you back by changing a few variables up or down. If it was distributions you’d simply assign distributions to those variables and look at the distribution of outcomes for your loan.
Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.