Calculate empirical medianThere are two definitions of the median: one as the 0.5 quantile of a (probability) distribution, the other as the "middle element" of a finite list ( Wikipedia median ).
I know how to calculate the former, but does anybody know a JMP function or elegant, fast way to calculate the latter for implementing in a rolling median in a formula column?
Creating a small list, sorting this, getting the middle value ... does not appear to be efficient to do for every row in a long table
Data TableScriptingRe: Calculate empirical medianHi @Feli,
I think the function "Col Median()" might be useful in your case, as the scripting index mentions that "the ordering is cached internally so that multiple evaluations will be efficient". You can also specify a "By" group variable.
Example on the Big class dataset from the scripting index (menu Help, Scripting Index), with a formula for median height calculated for each Age group:
dt << New Column( "Col Median Height by Age",
numeric,
continuous,
formula( Col Median( :height, :age ) )
);
I hope this answer will help you,
