CALC.prob(arrayx, arrayprob, lower_limit, upper_limit)
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 probability that values in a range are between two limits. Arrayx is the range of numeric values of x with which there are associated probabilities. Arrayprob is a set of probabilities associated with values in Arrayx. Lower_limit is the lower bound on the value for which you want a probability. Upper_limit is the optional upper bound on the value for which you want a probability if not supplied the function returns the probability that values in Arrayx are equal to Lower_limit.
Example
CALC.prob([0,1,2,3], [0.2,0.3,0.1,0.4], 1, 3);
// returns 0.8 (probability that x lies within 1 and 3)
| << CALC.poisson(x, mean, cumulative) | © 1996-2013 InetSoft Technology Corporation (v11.4) | CALC.quartile(array, quart) >> |