End (optional) is the upper bound for number Start (optional) is the lower bound for number. Alpha is a parameter to the distribution. Number is the value between Start and End at which to evaluate the function. Returns the inverse of the cumulative beta probability density function.

End (optional) is the upper bound for number. Returns the cumulative beta probability density function. T_2 (optional) defines the upper limit for the number of trials.īETADIST(number alpha beta start end) T_1 defines the lower limit for the number of trials. SP is the probability of success on each trial. Trials is the number of independent trials. Returns the probability of a sample with binomial distribution. number_30 are numerical values or ranges. Each number can also be replaced by a reference.ĪVERAGE(number_1 number_2. number_30 are values or ranges that represent a sample.

Returns the average of the absolute deviations of data points from their mean. Calc includes over 70 statistical functions which enable the evaluation of data from simple arithmetic calculations, such as averaging, to advanced distribution and probability computations.Several other statistics-based functions are available through the Add-ins which are noted at the end of this appendix.

Openoffice calc graph forecast