BETA.DIST
Formulas / BETA.DISTCalculate the cumulative beta distribution.
BETA.DIST(x,alpha,beta,cumulative,[A],[B])
- x - the value between A and B
- alpha - a parameter of the distribution
- beta - a parameter of the distribution
- cumulative - returns cumulative beta distributions if TRUE and probability density functions if FALSE
- A - [OPTIONAL] x interval lower bound
- B - [OPTIONAL] x interval upper bound
Examples
=BETA.DIST(A2,A3,A4,TRUE,A5,A6)The BETA.DIST function can be used to calculate the cumulative beta probability density function. For example, this formula will calculate the cumulative beta probability density function using the parameters A2, A3, A4, TRUE, A5, and A6.
=BETA.DIST(A2,A3,A4,FALSE,A5,A6)Another use of the BETA.DIST function is to calculate the beta probability density function. This formula can be used to calculate the beta probability density function using the parameters A2, A3, A4, FALSE, A5, and A6.
Summary
The BETADIST and BETA.DIST functions are used to calculate the cumulative beta probability density function, helping to measure the percentage of something across samples. BETA.DIST may provide improved accuracy compared to BETADIST.
- The BETA.DIST function is used to calculate the cumulative beta distribution or probability density function of the Beta distribution.
Frequently Asked Questions
What is the BETA.DIST function?
The BETA.DIST function computes the beta distribution, which is used to study how the percentage of something across samples varies.
What arguments are required for the BETA.DIST function?
The required arguments for the BETA.DIST function are X, alpha, beta, and cumulative.
What errors can be thrown by the BETA.DIST function?
The BETA.DIST function throws the following errors:
- #VALUE! error if any argument is not numeric.
- #NUM! error if alpha or beta are less than or equal to zero.
- #NUM! error if x is less than A.
- #NUM! error if x is greater than B.
- #NUM! error if A equals B.
