MonteGrid | Distributions | Beta-binomial

Beta-binomial distribution

MC_BETABINOM defines a Beta-binomial assumption in MonteGrid. It is in the Counts group of Define Assumption.

Syntax

=MC_BETABINOM(n, alpha, beta, MC_STATIC(value, name, group))

ArgumentDefine Assumption fieldValues
nTrialsA whole number, 0 or more.
alphaAlphaGreater than 0.
betaBetaGreater than 0.

Note: MC_STATIC holds the value the cell shows outside a simulation, the assumption's name, and its correlation group ("" for none).

Example

Define Assumption suggests these parameters for a cell that holds 100. The static value is the median.

=MC_BETABINOM(100,2,2,MC_STATIC(50,"",""))

P10 P50 P90
Beta-binomial — Trials 100 · Alpha 2 · Beta 2. Range shown: 1 to 99.
P10P50P90Mean
19508150

Crystal Ball and @RISK

ProductEquivalentIn MonteGrid
Crystal Ball None in Oracle's distribution list. —
@RISKNone that MonteGrid converts.—

Counts

All distributions