Table of Contents
The BETA.DIST function in Google Sheets allows users to calculate the probability of a value falling within a specified range in a beta distribution. To use this function, open a Google Sheets document and click on the cell where you want to use the function. Type the equal sign to start the formula, then begin typing BETA.DIST and select it from the list of functions that appears. The function’s syntax, description, and examples will appear. Enter the required arguments following the syntax and press Enter to see the result. The first argument is the value at which the distribution is evaluated, followed by the alpha value, beta value, cumulative or probability, and distribution type. For more information on the usage of this function, refer to the Google Sheets help center.
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 To use the BETA.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/to-use-the-beta-dist-function-in-google-sheets-follow-these-steps1-open-a-new-or-existing-google-sheets-document-2-click-on-a-cell-where-you-want-to-use-the-function-3-type-the-equal-sign/
stats writer. "How To use the BETA.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/to-use-the-beta-dist-function-in-google-sheets-follow-these-steps1-open-a-new-or-existing-google-sheets-document-2-click-on-a-cell-where-you-want-to-use-the-function-3-type-the-equal-sign/.
stats writer. "How To use the BETA.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/to-use-the-beta-dist-function-in-google-sheets-follow-these-steps1-open-a-new-or-existing-google-sheets-document-2-click-on-a-cell-where-you-want-to-use-the-function-3-type-the-equal-sign/.
stats writer (2024) 'How To use the BETA.DIST function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/to-use-the-beta-dist-function-in-google-sheets-follow-these-steps1-open-a-new-or-existing-google-sheets-document-2-click-on-a-cell-where-you-want-to-use-the-function-3-type-the-equal-sign/.
[1] stats writer, "How To use the BETA.DIST function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How To use the BETA.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.