May
24
Filed Under (Business) by admin on 24-05-2008

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.