Need to work with binomial probability distributions? Don’t forget that Microsoft Excel supplies powerful tools for performing just this sort of statistical analysis. A binomial distribution describes the outcome of a multi-step experiment, consisting of n identical trials, where each trial ends in either a success or a failure and the probability of a success p does not change from trial to trial. This useful statistical analysis can be performed relatively easily using Microsoft Excel using the Excel BINOMDIST, CRITBINOM and NEGBINOMDIST functions. |