Re: How to populate additional column with a quantile value
Sep 22, 2010 6:28 AM(4086 views)
JMP's Quantile functions work the other way around: given a quantile value they produce a data value. If you plot the quantile function (script below), you'll see it has flat spots, which makes it hard to define the inverse function that you want.
You can get close with (Col Rank( : x ) - 1) / (N Row() - 1), but ties are arbitrarily ordered.
The Ranking Tie() function will average ties together, but requires more set-up since it's not a "Col" function.