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.
Need help with Formulas?
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?
What arguments are required for the BETA.DIST function?
What errors can be thrown by the BETA.DIST function?
- #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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.