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.
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:
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)
- Press Enter -> beta cumulative distribution function value is:
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)
- Press Enter -> beta probability density function value is:
Above are instructions and specific examples when using BETA.DIST function in Excel.
Good luck!