DAX Function Guide

BETA.DIST
Empty image or helper icon

Sam McKay

CEO & Founder

How does the BETA.DIST work?
The BETA.DIST function (DAX) returns the cumulative probability density function for a supplied set of parameters.
BETA.DIST Formula Syntax

BETA.DIST(
     x,alpha,beta,cumulative,[A],[B]
)

How do you use the BETA.DIST?

As a type of statistical function, it returns the beta distribution which is used to study the variation of a percentage across samples. 

Related Blog Posts

Loading

Considerations when using the BETA.DIST?

If any argument is nonnumeric, BETA.DIST returns the #VALUE! error value. If any argument is not an integer, it is rounded. 

If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value. If x < A, 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.

Related Video Tutorials

Loading

Formula examples using the BETA.DIST

=BETA.DIST (0.2,3,9,FALSE,0,1)

=BETA.DIST (0.2,3,9,TRUE,0,1)

=BETA.DIST (2,8,10,TRUE,1,3)

Related Courses

Loading