CALC.trimmean(array, percent)
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 mean of the interior of a data set by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish to exclude outlying data from your analysis. Array is the array or range of values to trim and average. Percent is the fractional number of data points to exclude from the calculation.
Example
CALC.trimmean([4,5,6,7,2,3,4,5,1,2,3], 0.2);
// returns 3.777 (mean of the data set with 20% of the values eliminated, 10% from front and 10% from the back)
| << CALC.steyx(arrayy, arrayx) | © 1996-2013 InetSoft Technology Corporation (v11.4) | CALC.varN(array) >> |