Bernoulli distribution

Format: Bernoulli(p)


The Bernoulli distribution is a Binomial distribution with n = 1. The Bernoulli distribution returns a 1 with probability p and a zero otherwise.


The Bernoulli distribution, named after Swiss scientist Jakob Bernoulli, is very useful for modeling an event that may or may not occur. For example, if you believe that there is a 20% chance of a competitor enter your market you can model this as VoseBernoulli(0.2) or VoseBernoulli(20%): in 20% of the scenarios it will generate a 1 which you can use to build further logic on.

For a simple example, =VoseBernoulli(0.2)*VoseLognormal(12,72) models a risk event with a probability of 20% of occurring and an impact, should it occur, equal to Lognormal(12,72). In fact, a better way of modeling this is to use the VoseRiskEvent function.

ModelRisk functions added to Microsoft Excel for the Bernoulli distribution

VoseBernoulli generates random values from this distribution for Monte Carlo simulation, or calculates a percentile if used with a U parameter.

VoseBernoulliObject constructs a distribution object for this distribution.

VoseBernoulliProb returns the probability mass or cumulative distribution function for this distribution.

VoseBernoulliProb10 returns the log10 of the probability mass or cumulative distribution function.

VoseBernoulliFit generates values from this distribution fitted to data, or calculates a percentile from the fitted distribution.

VoseBernoulliFitObject constructs a distribution object of this distribution fitted to data.

VoseBernoulliFitP returns the parameters of this distribution fitted to data.


Bernoulli distribution equations




Monte Carlo simulation in Excel. Learn more


Adding risk and uncertainty to your project schedule. Learn more



For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now


For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now