The BETA.DIST function returns the probability of a given value as defined by the beta distribution function.
Parts of a BETA.DIST function
BETA.DIST(value, alpha, beta, lower_bound, upper_bound)
Part
Description
Notes
value
The value at which to evaluate the probability function.
- The given value must be a number from the given lower boundary to the given upper boundary.
alpha
The first shape parameter of the distribution.
- The given alpha must be a positive number.
beta
The second shape parameter of the distribution.
- The given beta must be a positive number.
lower_bound
The lower boundary of the function.
- The default lower boundary is 0.
upper-bound
The upper boundary of the function.
- The default upper boundary is 1.
Sample formulas
BETA.DIST(0.65, 1.234, 7, 0.5, 3)
BETA.DIST(0.42, 3, 8)
BETA.DIST(0.92, 0.5, 0.7)
BETA.DIST(A5, 0.5, 0.7, -1, 1)
Note
- You can use
BETADISTorBETA.DISTto perform this function.
Example
In this example, the cumulative probability of beta distribution at 0.3 is parameterized by an alpha of 5 and a beta of 1, defined over [-1, 1]:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
|
1
|
Value | Alpha | Beta | Lower bound | Upper bound | Solution |
|
2
|
0.3 | 5 | 1 | -1 | 1 | 0.1160290625 |
|
3
|
0.3 | 5 | 1 | -1 | 1 | =BETA.DIST(0.3, 5, 1, -1, 1) |
|
4
|
0.3 | 5 | 1 | -1 | 1 | =BETA.DIST(A4, B4, C4, D4, E4) |
Related function
BETAINV : The BETA.INV function returns the value of the inverse beta distribution function for a given probability.
