BETA.DIST function - The function returns the Beta distribution in Excel

BETA.DIST function: The function returns the beta distribution to study the variability of a number of things through a sample. Support functions from Excel 2010 onwards. Syntax: BETA.DIST (x, alpha, beta, cumulative, [A], [B])

The following article introduces you to the Beta.dist function - one of the functions in the group of statistical functions that is very popular in Excel.

BETA.DIST function - The function returns the Beta distribution in Excel Picture 1 BETA.DIST function - The function returns the Beta distribution in Excel Picture 1

Description: The function returns the beta distribution to study the variability of a number of things through a sample. Support functions from Excel 2010 onwards.

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

Inside:

- x: The value between A and B used to evaluate the function, is a required parameter.

- alpha: The parameter of the distribution, is a required parameter.

- beta: The parameter of the distribution, is a required parameter.

- cumulative: The logical value determines the form of the function, if the cumulative is True -> the function returns the cumulative distribution, the False value returns the probability density function.

- A: The lower bound of about x, is an optional parameter.

- B: The upper bound of the x interval , is an optional parameter.

Attention:

- If any parameter is not a number -> the function returns the #VALUE! Error value

- If alpha ≤ 0 or beta ≤ 0 -> the function returns the #NUM! Error value

- If x or x> B , or A = B -> the function returns the #NUM! Error value

- If parameters A and B are omitted, the function uses the cumulative distribution to normalize ie A = 0 and B = 1.

For example:

Calculate the value of the beta cumulative distribution function and the probability density function using the Beta.dist function with the figures in the table below:

BETA.DIST function - The function returns the Beta distribution in Excel Picture 2

1. Calculate the value of the beta cumulative distribution function (the value that determines the function is in True).

- In the cell to calculate enter the formula : = BETA.DIST (C6, C7, C8, C9, C11, C12)

BETA.DIST function - The function returns the Beta distribution in Excel Picture 3

- Press Enter -> beta cumulative distribution function value is:

BETA.DIST function - The function returns the Beta distribution in Excel Picture 4

2. Calculate the value of the beta probability density function (the values that determine the function are in False).

- In the cell to calculate enter the formula: = BETA.DIST (C6, C7, C8, C10, C11, C12)

BETA.DIST function - The function returns the Beta distribution in Excel Picture 5

- Press Enter -> beta probability density function value is:

BETA.DIST function - The function returns the Beta distribution in Excel Picture 6

Above are instructions and specific examples when using BETA.DIST function in Excel.

Good luck!