|
<< Click to Display Table of Contents >> BETA.DIST (beta distribution) |
Syntax:
BETA.DIST(X, Alpha, Beta, Cumulative [, A, B])
Description:
This returns the (cumulative) beta distribution function.
X is the value whose probability is to be calculated.
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 probability density function of the beta distribution is calculated.
A and B (optional) determine the limits of the interval for X. 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. The function is unknown in older versions.
Additional info:
The inverse function is BETA.INV
See also: