DAX Statistical - BETA.DIST function
Description
Returns the beta distribution.
The beta distribution is commonly used to study the variation in the percentage of something across samples.
DAX BETA.DIST function is new in Excel 2016.
Syntax
BETA.DIST (x, alpha, beta, cumulative, [A, [B]])
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
x The value between A and B at which to evaluate the function. |
2 |
alpha A parameter of the distribution. |
3 |
beta A parameter of the distribution. |
4 |
cumulative Logical value that determines the function’s form − TRUE: Returns the cumulative distribution function. FALSE: Returns the probability density function. |
5 |
A Optional. A lower bound to the interval of x. |
6 |
B Optional. An upper bound to the interval of x. |
Return Value
Returns the beta distribution.
A real number, probability, where 0 < probability <= 1.
Remarks
If any parameter is nonnumeric, BETA.DIST returns the #VALUE! error value.
If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value.
If x < A, or x > B, or A = B, BETA.DIST returns the #NUM! error value.
If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1.
Example
= BETA.DIST(0.5,9,10, TRUE (),0,1) returns 0.592735290527344. = BETA.DIST(0.5,9,10, FALSE (),0,1) returns 3.33847045898437.