JMP formula for Percentile.INCWhat is the JMP formula for Percentile.INC? I have an excel sheet that is not matching up with jmp.
AnalyticsRe: JMP formula for Percentile.INCHi,
The formula: Col Quantile (:Column, k) should return the same as Excel. If you need to subset within a column, use the expanded formula: Col Quantile (:Column, k, :By Column).
Best,
TS