EXCEL BETA.DIST FUNCTION

For a given set of parameters, the Excel Beta.Dist function computes the cumulative beta distribution function or the probability density function of the Beta distribution. Because the function was introduced in Excel 2010, it is not available in previous versions of Excel. The Beta.Dist function, on the other hand, is an upgraded version of the Betadist function, which was accessible in older versions of Excel.

Syntax :

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

Parameters :

x – The value at which the function should be computed (must be between [A] and [B]).

alpha – A distribution parameter (must be greater than 0).

beta – A distribution parameter (must be greater than 0).

Cumulative – A logical input that determines the type of distribution to be utilised. This might be either:

TRUE  = Cumulative Beta Distribution Function.

 FALSE = Beta probability  Density Function.

[A] – An optional parameter that specifies the lower bound of the x interval.
(If omitted, [A] is set to 0 by default.)

[B] – An optional parameter that specifies the upper bound of the x interval.(If omitted, [B] is set to the default value of 1).

The Standard Beta Distribution is obtained by setting the parameters [A] and [B] to 0 and 1, respectively.

Example :

The Cumulative Beta Distribution is seen above with the parameter alpha set to 4 and the parameter beta set to 5. The x interval is set to [0, 1], resulting in the Standard Cumulative Beta Distribution. If you wish to determine the value of this function at x = 0.4 in Excel, use the Beta.Dist function as follows:
=BETA.DISTANCE ( 0.4, 4, 5, TRUE, 0, 1 ) This yields the value 0.4059136.

  • #NUM! – Occurs if either: the provided x value is [A] or > [B], or the supplied [A] and [B] arguments are equal, or the supplied alpha or beta is 0.
  • #VALUE! – This error occurs if any of the supplied parameters is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now