Statistical

BETA.INV Function in Excel

Returns the inverse of the beta cumulative distribution function.

Syntax

  • =BETA.INV(probability, alpha, beta, [A], [B])

Arguments

  • probability (required): Probability (0 to 1)
  • alpha (required): Alpha parameter
  • beta (required): Beta parameter
  • A (optional): Lower bound (default 0)
  • B (optional): Upper bound (default 1)

Examples

  • =BETA.INV(0.6875, 2, 3) - Inverse beta - Result: 0.5

BETA.INV for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • #NUM! if probability not between 0 and 1

Use cases

  • Statistical modeling
  • Risk analysis
  • Simulation

Frequently asked questions

  • What is the BETA.DIST function in Excel? BETA.DIST returns the beta probability distribution, commonly used in project management (PERT analysis), quality control, and statistical modeling where you need to model variables with known minimum and maximum values.
  • When should I use BETA.DIST in real work? Use BETA.DIST for project time estimation, quality control analysis, risk assessment, and any scenario where you're modeling a variable constrained between two values with a known shape.
  • What parameters does BETA.DIST require? BETA.DIST needs: x (value to evaluate), alpha and beta (shape parameters), cumulative (TRUE/FALSE), and optionally A and B (lower and upper bounds).
  • How is BETA.DIST different from normal distribution? Unlike normal distribution which extends infinitely, beta distribution is bounded between two values (usually 0 and 1). It's more flexible for modeling real-world constraints.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.