Table of Contents
The BETA.DIST function in Google Sheets is used to calculate the probability density function or cumulative distribution function for a given beta distribution. To use this function, you will need to provide the value of the random variable, the alpha and beta parameters, and optionally the lower and upper bound of the distribution. This function can be useful in analyzing data with a beta distribution, such as proportions or rates. By understanding how to use the BETA.DIST function, you can effectively analyze and interpret data in Google Sheets.
BETA.DIST function
The BETA.DIST function returns the probability of a given value as defined by the beta distribution function.
Parts of a BETA.DIST function
BETA.DIST(value, alpha, beta, lower_bound, upper_bound)
| Part | Description | Notes |
value |
The value at which to evaluate the probability function. |
|
alpha |
The first shape parameter of the distribution. |
|
| beta | The second shape parameter of the distribution. |
|
lower_bound |
The lower boundary of the function. |
|
upper-bound |
The upper boundary of the function. |
|
Sample formulas
BETA.DIST(0.65, 1.234, 7, 0.5, 3)
BETA.DIST(0.42, 3, 8)
BETA.DIST(0.92, 0.5, 0.7)
BETA.DIST(A5, 0.5, 0.7, -1, 1)
Note
- You can use
BETADISTorBETA.DISTto perform this function.
Example
In this example, the cumulative probability of beta distribution at 0.3 is parameterized by an alpha of 5 and a beta of 1, defined over [-1, 1]:
| A | B | C | D | E | F | |
| 1 | Value | Alpha | Beta | Lower bound | Upper bound | Solution |
| 2 | 0.3 | 5 | 1 | -1 | 1 | 0.1160290625 |
| 3 | 0.3 | 5 | 1 | -1 | 1 | =BETA.DIST(0.3, 5, 1, -1, 1) |
| 4 | 0.3 | 5 | 1 | -1 | 1 | =BETA.DIST(A4, B4, C4, D4, E4) |
Related function
BETAINV: The BETA.INV function returns the value of the inverse beta distribution function for a given probability.
Cite this article
stats writer (2024). How do I use the BETA.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-beta-dist-function-in-google-sheets/
stats writer. "How do I use the BETA.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-beta-dist-function-in-google-sheets/.
stats writer. "How do I use the BETA.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-beta-dist-function-in-google-sheets/.
stats writer (2024) 'How do I use the BETA.DIST function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-beta-dist-function-in-google-sheets/.
[1] stats writer, "How do I use the BETA.DIST function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the BETA.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.