CALC.binomdist(number_s, trials, probability_s, cumulative)
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 individual term binomial distribution probability. Number_s is the number of successes in trials. Trials is the number of independent trials. Probability_s is the probability of success on each trial. Cumulative is a logical value that determines the form of the function. If Cumulative is true, the function returns the cumulative distribution function, which is the probability that there are at most Number_s successes; if false, it returns the probability mass function, which is the probability that there are Number_s successes.
Example
CALC.binomdist(6, 10, 0.5);
// returns 0.205
| << CALC.averagea(array) | © 1996-2013 InetSoft Technology Corporation (v11.4) | CALC.correl(array1, array2) >> |