BETA.DIST Function (LibreOffice Calc)
Use LibreOffice BETA.DIST with its required fourth-position mode, scaled densities, source-specific support errors and reproducible interval examples.
Verification status: Eight reference formulas and 3 diagnostic cases were recalculated through XLSX import in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5. This headless development-build run does not establish stable-release or GUI behavior. How formula examples are checked
Availability and version history
- Introduced: LibreOffice 4.2.
- Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
- Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
- Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
Quick answer: =BETA.DIST(0.5;2;3;1) has reference value 0.6875.
What BETA.DIST returns
BETA.DIST evaluates the beta distribution with positive shape parameters Alpha and Beta. It can return either a lower-tail cumulative probability or a density. Optional bounds scale the distribution from its standard 0-to-1 support to a different interval. A density is a height whose integral is probability; it may exceed 1. Pinned calculation logic.
Syntax and arguments
=BETA.DIST(X; Alpha; Beta; Cumulative [; Lower [; Upper]])
Four through six arguments are accepted. The cumulative flag is required in the fourth position: TRUE or nonzero selects the CDF, while FALSE or 0 selects density. Lower defaults to 0 and Upper to 1. Alpha and Beta must be positive. Use strictly increasing bounds and X within the closed interval; this dotted evaluator rejects out-of-support X in both modes.
Reproducible reference calculations
These eight formulas were recalculated through XLSX import in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5. Saved ODS values agree with independent high-precision references, rounded here to twelve decimal places. This is headless development-build evidence, not stable-release or GUI validation.
| Formula | Independent reference |
|---|---|
=BETA.DIST(0.25;2;3;1) |
0.26171875 |
=BETA.DIST(0.5;2;3;1) |
0.6875 |
=BETA.DIST(0.5;2;3;0;0;1) |
1.5 |
=BETA.DIST(0.5;1;1;1) |
0.5 |
=BETA.DIST(12;2;3;1;10;14) |
0.6875 |
=BETA.DIST(12;2;3;0;10;14) |
0.375 |
=BETA.DIST(0;2;3;1) |
0 |
=BETA.DIST(1;2;3;1) |
1 |
Practical worksheet
Consider a modeled proportion with Alpha=2 and Beta=3. =BETA.DIST(0.5;2;3;TRUE()) returns 0.6875, meaning a 68.75% model probability at or below 0.5. =BETA.DIST(0.5;2;3;FALSE();0;1) returns density 1.5. A density can exceed 1 because probability is an area over an interval, not the density’s height at one point.
To model the same shape on an interval from 10 to 14, put those bounds in D2 and E2 and evaluate =BETA.DIST(12;2;3;TRUE();D2;E2). The midpoint still has cumulative probability 0.6875. Its density is 0.375, because stretching the width to 4 divides the density by 4 while preserving total area.
Advanced interpretation and checks
An interval probability is a difference of cumulative values. =BETA.DIST(0.5;2;3;TRUE())-BETA.DIST(0.25;2;3;TRUE()) gives 0.42578125. For a continuous distribution, including or excluding an isolated endpoint makes no probability difference. This does not mean density is itself a probability.
The standardized variable is z=(X−Lower)/(Upper−Lower). Cumulative probabilities use the beta CDF at z; densities additionally divide by Upper−Lower. Preserve that scale factor when independently checking a formula. For Alpha=Beta=1 the model is uniform: on 10 through 14 its density is 0.25 and its midpoint CDF is 0.5. Choose shape parameters from a defensible model rather than merely selecting a curve that looks convenient.
For a Bayesian proportion model, Beta(1,1) is a uniform prior and independent Bernoulli data with s successes and f failures give posterior shapes s+1 and f+1. That specific prior explains the added ones; it is not a universal parameter rule. A posterior CDF at a threshold is one probability, not a central credible interval and not the probability that one A/B variant beats another.
Boundaries and troubleshooting
Unlike legacy BETADIST, the inspected BETA.DIST entry rejects X below Lower or above Upper. It does not extend the CDF to 0 or 1 outside the interval. Validate the original data instead of silently clamping observations to an endpoint.
Use Lower<Upper; a zero-width interval is not a valid continuous beta model. Endpoint densities depend on the shapes: they may be finite, zero or singular. For example, Alpha<1 at the lower endpoint can cause an invalid-argument error rather than a representable infinite density. Do not mistake the required fourth-position cumulative flag for a lower bound.
Development-build boundary checks
The following additional formulas were saved from the same headless import run. Error text is retained as an error, not converted to a successful zero result.
| Formula | Native result or error |
|---|---|
=BETA.DIST(-1;2;3;1) |
Err:502 |
=BETA.DIST(2;2;3;1) |
Err:502 |
=BETA.DIST(0.5;2;3;1;0.5;0.5) |
#NUM! |
Related functions
Evidence and checking scope
The LibreOffice 26.8.1.1 evaluator establishes the product-specific argument and domain rules. Mathematical references and composite examples were independently checked. Native evidence is limited to the eight reference formulas and listed diagnostics in the named development build. A deliberately stale SUM cache changed from 999999 to 3, and an uncached SUM returned 7 after forced recalculation. The earlier ordinary conversion failed the stale-cache control and was excluded. Composite explanatory calculations, stable releases, GUI entry and extreme-parameter accuracy were not established by this run.