CALC.rank(number, array, order)

Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. Number is the number whose rank you want to find. Array is an array numbers. Nonnumeric values in Array are ignored. Order is a number (0 or 1) specifying how to rank number. (0 = from top, 1 = from bottom).

Example

CALC.rank(7,[1,2,4,7,8,9,10,12],1);

// returns 4; the value '7' is fourth from bottom

CALC.rank(7,[1,2,4,7,8,9,10,12],0);

// returns 5; the value '7' is fifth from top

<< CALC.quartile(array, quart) © 1996-2013 InetSoft Technology Corporation (v11.4) CALC.rsq(known_y_values, known_x_values) >>