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.
Ask Your Query