Statistical - BETA.DIST Function

Description

The BETA.DIST function returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples.

Syntax

BETA.DIST(x,alpha,beta,cumulative,[A],[B])

Arguments

Argument	Description	Required/ Optional
X	The value between A and B at which to evaluate the function.	Required
Alpha	A parameter of the distribution.	Required
Beta	A parameter of the distribution.	Required
Cumulative	A logical value that determines the form of the function. BETA.DIST returns − the cumulative distribution function if cumulative is TRUE the probability density function if cumulative is FALSE	Required
A	A lower bound to the interval of x.	Optional
B	An upper bound to the interval of x.	Optional

Notes

If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1
If any argument is nonnumeric, BETA.DIST returns the #VALUE! error value.
If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value.
If x < A, x > B, or A = B, BETA.DIST returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm