Excel BETADIST function
The Excel BETADIST function returns the cumulative beta probability density function which is usually used to analyze the percentage variation of something across samples.
Note: This function has been replaced with BETA.DIST function that may provide improved accuracy after Excel 2010 version. This function is still can be available but considering it may be not available in the future, you should better study to use the new function from now.
Syntax and arguments
The BETADIST function returns a numeric value.
#VALUE! error value appears when any argument is nonnumeric.
#NUM! error value appears when one of below situations occurs:
- Argument alpha <= 0;
- Argument beta <= 0;
- Argument x < A;
- Argument x > B;
- Argument A = B.
If the argument A and B are omitted, the BETADIST function uses the standard cumulative beta distribution, A = 0, B = 1, which means that the argument x must be between 0 and 1.
Excel 2010 and before versions. (Still be available in Excel 2013 and later versions)
Usage and Examples
Example1 basic usage
To return cumulative beta probability density function based on the provided parameters in table C2:C6, please use the BETADIST function as below:
Or you can directly type the arguments in the formula like:
Press Enter key.
Excel BETA.DIST Function
The Excel BETA.DIST function (Excel 2013) returns the beta distribution which is usually used to study the percentage variation of something across samples.
Excel NORM.INV Function
The NORM.INV calculates and returns the inverse of the normal cumulative distribution for the given arithmetic mean and standard deviation.
Excel NORM.S.DIST Function
The NORM.S.DIST calculates and returns the standard normal cumulative distribution function or probability density function of a value for an arithmetic mean of 0 and standard deviation of 1
Excel NORM.S.INV Function
The NORM.S.INV calculates and returns the inverse of the standard normal cumulative distribution that has an arithmetic mean of 0 and standard deviation of 1 with a given probability.