<< Click to Display Table of Contents >> BETA.DIST (beta distribution) |
Syntax:
BETA.DIST(X, Alpha, Beta, Cumulative [, A, B])
Description:
Returns the (cumulative) beta distribution function.
X is the value to be evaluated.
Alpha and Beta are shape parameters of the function. They both have to be greater than zero.
Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the beta distribution is calculated. By entering the value FALSE, the density function of the beta distribution is calculated.
A and B (optional) are the lower and upper bound to the interval. If they are omitted, A is set to 0 and B is set to 1 (thus leading to a normal distribution).
X must be in the range A to B.
Note:
The BETA.DIST function supplements the previous BETADIST function with the additional argument Cumulative.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
Annotation:
The inverse function is BETA.INV
See also: