Skip to main content

Excel BETA.INV function

Author: Sun Last Modified: 2024-10-23
show the usage of BETA.INV function

Description

The Excel BETA.INV function returns the inverse of the cumulative beta probability density function for a specified beta distribution. This means that if probability = BETA.DIST(x,alpha,…), the BETA.INV(probability,alpha,…) returns x.

Syntax and arguments

Formula syntax

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

Arguments

  • Probability: Required, the probability of the beta distribution.
  • Alpha: Required, A distribution parameter.
  • Beta: Required, A distribution parameter.
  • A: Optional, the lower bound to the interval of x
  • B: Optional, the upper bound to the interval of x.

Return Value

The BETA.INV function returns a numeric value.

Errors

#VALUE! error value appears when any argument is nonnumeric.

#NUM! error value appears when one of below situations occurs:

  1. Argument alpha <= 0;
  2. Argument beta <= 0;
  3. Argument x < A;
  4. Argument x > B;
  5. Argument A = B.

Remarks

If the argument A and B are omitted, the BETAINV function uses the standard cumulative beta distribution, A = 0, B = 1.

Version

Excel 2013 and later versions.

Usage and Examples

Example1 basic usage

To return the inverse of cumulative beta probability density function based on the provided parameters in table C2:C6, please use the BETA.INV function as below:

=BETA.INV(C2,C3,C4,C5,C6)

Or you can directly type the arguments in the formula like:

=BETA.INV(0.6,1,6,5,10)

Press Enter key.
show the usage of BETA.INV function


Other Functions:

  • Excel BETA.DIST Function
    The Excel BETA.DIST function (Excel 2013) returns the beta distribution which is usually used to study the percentage variation of something across samples.

  • Excel BETADIST Function
    The Excel BETADIST function (Excel 2010) returns the beta distribution which is usually used to study the percentage variation of something across samples.

  • Excel NORM.S.DIST Function
    The NORM.S.DIST calculates and returns the standard normal cumulative distribution function or probability density function of a value for an arithmetic mean of 0 and standard deviation of 1

  • Excel NORM.S.INV Function
    The NORM.S.INV calculates and returns the inverse of the standard normal cumulative distribution that has an arithmetic mean of 0 and standard deviation of 1 with a given probability.


The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...


Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.