BETA.DIST functionThe 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 BETADIST or BETA.DIST to 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.