Show percentile when mousing over distribution graph
t
tr
In the detail view for a cell: Mouse over the distribution graph and show a vertical line that moves with the mouse. Show the percentile of that spot: "37%th percentile" or "37% of the probability is to the left of this spot"
Use case: Modeling my future finances. I want to hover the mouse over zero on the x-axis and see what the chance is that I'll have less than zero dollars. As a workaround I made another cell called "chance it's less than zero" with the formula "=(ZZ<0)
1". The
1 is needed to convert it from a bool to a number.Ozzie Gooen
Mockup attached.
Ozzie Gooen
I'd really like this, am surprised others haven't mentioned it too much.
Another hacky way of doing this now is by,
'=(ZZ>0) ? 100 : 0' to get the percentile.