CALC.rank(number, array, order)
CALC.binomdist(number_s, trials, probability_s, cumulative)
CALC.expondist(x, lambda, cumulative)
CALC.forecast(x, known_y_values, known_x_values)
CALC.frequency(data_array, bins_array)
CALC.hypgeomdist(sample_s, number_sample, population_s, number_population)
CALC.intercept(arrayY, arrayX)
CALC.negbinomdist(number_f, number_s, probability_s)
CALC.percentrank(array, x, significance)
CALC.permut(number, number_chosen)
CALC.poisson(x, mean, cumulative)
CALC.prob(arrayx, arrayprob, lower_limit, upper_limit)
CALC.rank(number, array, order)
CALC.rsq(known_y_values, known_x_values)
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) >> |