- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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.