BETA.DIST
Returns the beta cumulative distribution function.
StatisticalStatistics & Analysis
What it does
Returns the beta distribution. Used to study variation in the percentage of something across samples.
Syntax
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
Arguments
x(number) — The value at which to evaluate the function.alpha(number) — Parameter of the distribution.beta(number) — Parameter of the distribution.cumulative(logical) — TRUE for cumulative function, FALSE for density function.
Examples
Beta Distribution
Calculate cumulative beta distribution.
FORMULA
=BETA.DIST(0.5, 8, 10, TRUE)
RESULT
0.6855
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | x | Alpha | Beta |
| 2 | 0.5 | 8 | 10 |